Support Article
IH schema generate script seems incorrect
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.
Published July 28, 2016 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.