Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

Support Article

IH schema generate script seems incorrect



After following the instructions in the DSM 7.2 Installation Guide, user has created a separate schema for IH called SampleIHSTORE and passed that as the dbSchema parameter to the script:
           ./ --dbType oracledate --dbSchema SampleIHSTORE
Also, user has tried following approach:
           ./ --action install --dbType oracledate --dbSchema SampleIHSTORE --dbDataSchema PEGADATA

However, both approaches seem to have created the DDLs with PEGADATA as schema prefix. 

Error Messages

Not Applicable.

Steps to Reproduce

1 Refer "Interaction History Database Tables in a Dedicated Schema" section in the DSM Operations Guide 721 (Page No.9)
2 In Step 5, run the command "generateIHddl.bat --dbType oracledate --dbSchema <IHSTORE>"

Root Cause

The file already has "<PEGADATA>" and the generated IH_install_on_.sql file will be appended with schema name <PEGADATA> instead of external schema <IHSTORE>.


Local-change is to remove the "" entry from the file.

BUG-255973 and BUG-255978, are created to mitigate doc defect.

Published July 28, 2016 - Updated October 8, 2020

Was this useful?

0% found this useful

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

Did you find this content helpful?

Want to help us improve this content?

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us