Problem with Cognos 10 Migration.

[derrickj]

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?

[Grim]

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

[derrickj]

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.)         

[derrickj]

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