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

SA-25571

Summary



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 generateIHddl.sh script:
           ./generateIHddl.sh --dbType oracledate --dbSchema SampleIHSTORE
Also, user has tried following approach:
           ./generateIHddl.sh --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 setupDatabase.properties file already has "data.schema.name=<PEGADATA>" and the generated IH_install_on_.sql file will be appended with schema name <PEGADATA> instead of external schema <IHSTORE>.

Resolution



Local-change is to remove the "data.schema.name" entry from the setupDatabase.properties file.

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

Suggest Edit

Published July 28, 2016 - Updated October 8, 2020

Did you find this content helpful? Yes No

Have a question? Get answers now.

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

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