Troubleshooting
Problem
Cognos service does not start and ends up giving error CM-CFG-5064 and CM-SYS-5226. The detailed error message is mentioned below
Symptom
CM-SYS-5007 Content Manager build <version> failed to start! Review the Content Manager log files and then contact your system administrator or customer support.
CM-CFG-5064 A Content Manager configuration error was detected while creating the initial content objects. CM-SYS-5226 An error occurred during the rollback of a database transaction. Method-Name: "rollbackForNewObject" Object-ID: "25111"
Environment
Windows, Unix
Diagnosing The Problem
After going through the <install Dir>\logs\cogserver.log file you will find the above mentioned error to appear first in cogserver.log file.
Resolving The Problem
Follow the below steps to resolve the issue:
- Take a complete backup of the Content store as a precautionary step.
- Execute the following script
<install Dir>/configuration/schemas/content/<Database>/dbCheckConsistency_<Database>.sql
where <Database> represents the database vendor of the used Content Store. - Execute the following script
<install Dir>/configuration/schemas/content/<Database>/dbMakeConsistent_<Database>.sql
where <Database> represents the database vendor of the used Content Store. - Once you are done with running the above 2 scripts, start the Cognos service.
Note :
(a) While you execute the above script you should be logged in with the same credentials as the one which you have provided in Cognos Configuration.
(b) dbCheckConsistency_<Database>.sql - This script checks if there are any inconsistencies and lists those.
(c) dbMakeConsistent_<Database>.sql - This script rectifies the inconsistencies in the content store.
Related Information
Was this topic helpful?
Document Information
Modified date:
15 June 2018
UID
swg21428773