Upon Cognos 10 start up from a Cognos 8 content store I was prompted to run
dbMakeConsistent_mssqlserver.sql, which I did.
After running the sql and restarting the Cognos 10 configuration tool I recieved the following error.
21:31:46, CM-CFG-5063 A Content Manager configuration error was detected while connecting to the content store. class java.lang.NullPointerException Runtime Exception stack trace: java.lang.NullPointerException at com.cognos.cm.dbstore.CMDbStoreConsistency.isCircular(CMDbStoreConsistency.java:1319) at com.cognos.cm.dbstore.CMDbStoreConsistency.isCircular(CMDbStoreConsistency.java:1328) at com.cognos.cm.dbstore.CMDbStoreConsistency.checkCircularChildParentCMIDs(CMDbStoreConsistency.java:1282) at com.cognos.cm.dbstore.CMDbStoreConsistency.checkInternalInconsistencies(CMDbStoreConsistency.java:292) at com.cognos.cm.dbstore.CMDbStoreConsistency.performConsistencyCheck(CMDbStoreConsistency.java:223) at com.cognos.cm.dbstore.CMDbStoreConsistency.performConsistencyCheckAtUpgrade(CMDbStoreConsistency.java:199) at com.cognos.cm.dbstore.CMDbStore.initializeContentDependent(CMDbStore.java:4162) at com.cognos.cm.server.CMServlet.initializeContentStoreForActive(CMServlet.java:2185) at com.cognos.cm.server.CMServlet.init(CMServlet.java:1886) at com.cognos.cm.server.ContentManager.start(ContentManager.java:409) at com.cognos.cm.server.ContentManagerLifecycleHandler.start(ContentManagerLifecycleHandler.java:62) at com.cognos.pogo.services.DefaultHandlerService.start(DefaultHandlerService.java:94) at com.cognos.pogo.services.DispatcherServices.startInititalServices(DispatcherServices.java:388) at com.cognos.pogo.transport.PogoServlet$PogoStartup.run(PogoServlet.java:690) at com.cognos.pogo.util.threads.SafeThread.safeRun(SafeThread.java:70) at com.cognos.pogo.util.threads.SafeThread.run(SafeThread.java:61)
Does any one have a solution for this error?
Do you still have a backup/copy of the original c8 DB and c8 instll? If yes try the follwing...
- run db consistency check and fix from c8
- copy db to new db
- run C10 against copy of db and let it upgrade
Grim,
I have performed the steps you mentioned. Unfortunately, the issue was not resolved.
I am still awaiting a solution.
From IBM:
The issue you face is that the cm database as used is
in a inconsistent-circular state and there exist an issue COGCQ00655457
in Cognos 10.1.1 on certain cm that may be tag as inconsistent during
startup. The fixed is to get the hotsite and apply it to the install
before upgrading and using the cm database ( a backup of 8.4.1 cm).
Should this still fail you may have to run the following sqls against
the 10.1.1 cm database first to get rid of the circular objects and
shows the reports affected. But before hand make sure you have good
backup of the cm database. (Do note that the cm database as backup from
8.4.1 for use in Cognos 10.1.1 should be done when the Cognos 8.4.1
service is stopped to ensure no active write to the cm database during
backup.)
A solution was provided by IBM to fix the corrupted content store.
1. Run (Delete from CMOBJECTS where pcmid not in (select cmid from cmobjects)) against the content store.
2. Run dbMakeConsistent_mssqlserver.sql
Thank you