Error in Cognos Configuration with Content Store Setting Up Test Environment

[jguevin]

I need some assistance or need to know if anyone else had this issue.

I have installed an instance of Cognos 8.3 on a test server.  I had our DBA copy the production content store (sql database) and rename it to  production_test (for example).  I then open Cognos Configuration on the test server, and configure all components pointing to this new content store and go to start the service.  I then get the following error during startup:

[Start Service]
1. 10:34:09, 'LogService', 'StartService', 'Success'.
2. 10:34:16, 'ContentManager', 'getActiveContentManager', 'Failure'.
DPR-CMI-4006 Unable to determine the active Content Manager. Will retry periodically.
3. 10:34:17, 'com.cognos.pogo.contentmanager.coordinator.ActiveCMControl', 'pogo', 'Failure'.
DPR-DPR-1035 Dispatcher detected an error.

4. 10:34:16, CM-CFG-5063 A Content Manager configuration error was detected while connecting to the content store.
CM-CFG-5029 Content Manager is unable to determine whether the content store is initialized.
DBComms.error reading input. Context:Read packet header, Unexpected end of stream, readBytes:-1, negative read result, PktNumber:0, ReadThisPacket:0, PktDataSize:4096
5. 10:34:36, 'ContentManagerService', 'StopService', 'Success'.
6. 10:34:36, 'ContentManagerService', 'StopService', 'Success'.
7. 10:34:36, 'CPS Producer Registration Service', 'StopService', 'Success'.
8. 10:34:36, 'CPS Producer Registration Service', 'StopService', 'Success'.
9. 10:34:36, 'MonitorService', 'StopService', 'Success'.
10. 10:34:36, 'MonitorService', 'StopService', 'Success'.
11. 10:34:36, 'DeliveryService', 'StopService', 'Success'.
12. 10:34:36, 'DeliveryService', 'StopService', 'Success'.
13. 10:34:37, 'EventService', 'StopService', 'Success'.
14. 10:34:37, 'EventService', 'StopService', 'Success'.
15. 10:34:37, 'JobService', 'StopService', 'Success'.
16. 10:34:37, 'JobService', 'StopService', 'Success'.
17. 10:34:37, 'com.cognos.pogo.services.DefaultHandlerService', 'pogo', 'Failure'.
DPR-DPR-1035 Dispatcher detected an error.

18. 10:34:37, 'com.cognos.pogo.services.DefaultHandlerService', 'pogo', 'Failure'.
DPR-DPR-1035 Dispatcher detected an error.

19. 10:34:37, 'SystemService', 'StopService', 'Success'.
20. 10:34:37, 'SystemService', 'StopService', 'Success'.
21. 10:34:37, 'BatchReportService', 'StopService', 'Success'.
22. 10:34:37, 'BatchReportService', 'StopService', 'Success'.
23. 10:34:37, 'ReportService', 'StopService', 'Success'.
24. 10:34:37, 'ReportService', 'StopService', 'Success'.
25. 10:34:37, 'ReportDataService', 'StopService', 'Success'.
26. 10:34:37, 'ReportDataService', 'StopService', 'Success'.
27. 10:34:37, 'LogService', 'StopService', 'Success'.
28. 10:34:37, 'LogService', 'StopService', 'Success'.
29. [ ERROR ] An error has occurred within Tomcat. Please check the log file 'C:/Program Files/cognos/c8/logs/tomcat.log'.
30. [ ERROR ] CFG-ERR-0103 Unable to start Cognos 8 service.
Execution of the external process returns an error code value of '-1'.


The production content store and the new test content store live on the same server.  Version of Cognos is 8.3, database is SQL Server 2005  Any help would be appreciated.  Thanks Jeff

[kolonell]

I have seen this error before. Check the Packet Data size setting on your SQL Server instance. It needs to be set to 4096 Due to some JDBC driver issue. (http://msdn.microsoft.com/en-us/library/ms187866(SQL.90).aspx)

[goose]

When you test your settings in Cognos configuration does everything pass?

[jguevin]

everything passes the test except for "testing the mail server connection" because I have not configured this setting, don't really need it in the test environment at this point.

[ducthcogtechie]

How about connecting back to the original Content Store, in Cognos connection do a full content store backup, ask the DBA to create a new empty content store (ie schema user) connect to that, and them import the full content store export.

[jguevin]

I'm at that point now.  I'm going to have the DBA create a new empty content store and import the export from production via cognos connection.

thanks
Jeff

[LeeJang]

i would create a new db then get the configuration working and then create an export from the existing environment and then take the exported file, import it into you dev...i believed this is more clean doing this way.

[LBond]

I'm a SQL DBA, not a cognos expert...I tried exactly what you tried at the beginning, and could never get it to work.  I finally just created an empty SQL database, then did an export from prod, import to my test (using content manager), and it all worked nicely.
Lori