Troubleshooting the docstore issues
Use the following topics to resolve common issues with the docstore.
Symptoms
When you try to run the IBM® MDMPIM DocStore Maintenance report, the report fails with the following message in the console.The Job did not sucessfully.
CWREP0009E: There was an error generating this report.
Could not execute query.
CWREP0009E: There was an error generating this report.
Could not execute query.
Causes
If you create a company in IBM Db2® and then migrate the database to Oracle, the database queries script present in the docstore does not get updated because it is database-dependent and thus the report fails.Resolving the problem
Run the $TOP/bin/db/install_Maintenance_Reports.sh script to resolve the issue.install_Maintenance_Reports.sh --code=<name of the company>