IBM Support

Getting error CM-CFG-5064 and CM-SYS-5226 while trying to start Cognos service

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:

  1. Take a complete backup of the Content store as a precautionary step.
  2. Execute the following script
    <install Dir>/configuration/schemas/content/<Database>/dbCheckConsistency_<Database>.sql
    where <Database> represents the database vendor of the used Content Store.
  3. Execute the following script
    <install Dir>/configuration/schemas/content/<Database>/dbMakeConsistent_<Database>.sql
    where <Database> represents the database vendor of the used Content Store.
  4. 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

[{"Product":{"code":"SSEP7J","label":"Cognos Business Intelligence"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Install and Config","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"10.2.2;10.2.1;10.2;10.1.1;10.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
15 June 2018

UID

swg21428773