IBM Support

Cognos BI service fails to start and issues an error

Troubleshooting


Problem

Cognos Business Intelligence service fails to start and issues an error

Symptom

cogserver.log file recorded the following error message: CM-CFG-5063 A Content Manager configuration error was detected while connecting to the content store. CM-CFG-5063 A Content Manager configuration error was detected while connecting to the content store. CM-CFG-5137 Content Manager was unable to complete the initialization of the content store. For more information, review the log file. Before you restart Content Manager, you might need to re-create the content store database or clean it using dbClean_*.sql.

Resolving The Problem

Have the Database Administrator run the dbClean_*.sql on the Content Store database or delete and create a new one.

NOTE: Running this script will delete all Cognos Content in Cognos Connection.

Steps for sql script:

  1. Stop all Cognos Services.
  2. Have the DBA make a back up the Content Store.
  3. Have the DBA run the install_path\configuration\schemas\content\dbVendor\dbClean_dbVendor.sql script on the Content Store database.
  4. Start the Cognos with Cognos Configuration.

[{"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;8.4.1;8.4;8.3","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Historical Number

1034834

Document Information

Modified date:
15 June 2018

UID

swg21342265

Page Feedback