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
- 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"}}]
Was this topic helpful?
Document Information
Modified date:
15 June 2018
UID
swg21340367