Hi,
We use Cognos 10.2.1 and Report Studio as a part from Oncommand Insight (Netapp).
After a Server reboot the Cogons Service failed with this Error:
0.18.73.195:9300 1564 2016-03-07 01:35:14.716 +1 Initialization_SESS Initialization_REQ
Thread-24 CM 5006 1 Audit.cms.CM StartService Warning
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.
Method-Name: "handleSQLExceptionForNewObject" Object-ID: "119". Cause:
The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint
or unique index identified by 'PK_CMOBJECTS' defined on 'CMOBJECTS'.
Stack trace: java.sql.SQLIntegrityConstraintViolationException:
The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint
or unique index identified by 'PK_CMOBJECTS' defined on 'CMOBJECTS'.
at org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(Unknown Source)
at org.apache.derby.client.am.SqlException.getSQLException(Unknown Source)
at org.apache.derby.client.am.PreparedStatement.executeUpdate(Unknown Source)
at com.cognos.cm.dbstore.CMPreparedStatementBase.executeUpdate(CMPreparedStatementBase.java:264)
at com.cognos.cm.dbstore.StatementProxy.executeUpdate(StatementProxy.java:321)
at com.cognos.cm.dbstore.CMDbConnection.executeUpdate(CMDbConnection.java:597)
at com.cognos.cm.dbstore.CMDbStore.createCopyObject(CMDbStore.java:4025)
at com.cognos.cm.dbstore.CMDbStore.copy(CMDbStore.java:1222)at com.cognos.cm.dbstore.CMDbStore.copyTenantAccountTemplate
CMDbStore.java:2115)
Does anyone know this error ?
Thanks Michael
By any chance your content store got corrupted ? Try pointing your content manager configuration to new empty database and let all tables creates. Then you may import your old content store here.