IBM Support

CM-SYS-5001 Content Manager internal error occurred

Troubleshooting


Problem

[

  • error appears while trying to open or to execute a report
  • system hangs after the error appears
]

Symptom

CM-SYS-5001 Interner Content Manager-Fehler ist aufgetreten/Internal error occured.
ORA-00001: unique constraint (COGNOS10.PK_CMOBJECTS) violated

Cause

This error means that an attempt has been made to insert a record with a duplicate (unique) key. This error will also be generated if an existing record is updated to generate a duplicate (unique) key. Typically this is a duplicate primary key, but it need not be the primary key.

Environment

Windows 2003 Server
Oracle Server 9.2.0.6.0
Oracle Client 9.2.0.6.0
JDBC 9.2.0
UTF-8 instance of database

Resolving The Problem

  • create a new content store and make a full deployment from the old content store
Steps:
  • create a new schema in your oracle db server for the new content store
  • open Cognos Connection -> Tools -> Content Administration
  • use the export functionality to make a full deployment
  • open Cognos Configuration and enter under Data Access -> Content Manager -> Content Store the new content store
  • restart the server
  • make an import of the full deployment

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

Document Information

Modified date:
15 June 2018

UID

swg21340367