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 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.
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>"
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>.
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