If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Cognos Services failed to start

Started by mx5mike, 21 Mar 2016 02:49:33 AM

Previous topic - Next topic

mx5mike

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

sunosoft

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.
Thanks
SK