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 13, 2016 - Updated July 28, 2016

Have a question? Get answers now.

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