Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => COGNOS 8 Administration => Topic started by: jguevin on 12 Jan 2009 09:43:09 AM

Title: Error in Cognos Configuration with Content Store Setting Up Test Environment
Post by: jguevin on 12 Jan 2009 09:43:09 AM
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
Title: Re: Error in Cognos Configuration with Content Store Setting Up Test Environment
Post by: kolonell on 12 Jan 2009 10:47:39 AM
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)
Title: Re: Error in Cognos Configuration with Content Store Setting Up Test Environment
Post by: goose on 13 Jan 2009 06:43:25 AM
When you test your settings in Cognos configuration does everything pass?
Title: Re: Error in Cognos Configuration with Content Store Setting Up Test Environment
Post by: jguevin on 13 Jan 2009 08:03:14 AM
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.
Title: Re: Error in Cognos Configuration with Content Store Setting Up Test Environment
Post by: ducthcogtechie on 13 Jan 2009 12:38:24 PM
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.
Title: Re: Error in Cognos Configuration with Content Store Setting Up Test Environment
Post by: jguevin on 13 Jan 2009 01:26:52 PM
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
Title: Re: Error in Cognos Configuration with Content Store Setting Up Test Environment
Post by: LeeJang on 25 Mar 2009 03:45:31 PM
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.
Title: Re: Error in Cognos Configuration with Content Store Setting Up Test Environment
Post by: LBond on 30 Mar 2009 05:19:28 PM
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
Text only | Text with Images