Content store key violation - Eartheration/IBM-Cognos-Wiki GitHub Wiki

Technote (troubleshooting)

Problem(Abstract)

Getting Content store key violation error in starting IBM Cognos BI 10.2.x

Symptom

CM-CFG-5064 A Content Manager configuration error was detected while creating the initial content objects.

CM-SYS-5227 A database constraint violation was detected. The current database transaction will be rolled back

Cause

Content Store inconsistency

Environment

Content Store on MS SQL 2005

Diagnosing the problem

1.stop service

  1. run c10\configuration\schemas\content\sqlserver\AddConsistencyCheckFlag_mssqlserver.sql against the content store database.
  2. Start service
  3. The AddConsistencyCheckFlag_mssqlserver.sql will check the inconsistency in the content store during start up.
  4. One can check cogserver.log in the /log folder for inconsistency which has been detected.

Resolving the problem

Before running the scripts, please perform content store backup by using database backup facility.

Run c10\configuration\schemas\content\sqlserver\AddConsistencyFixFlag_mssqlserver.sql at database then start service

⚠️ **GitHub.com Fallback** ⚠️