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.

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.