Tuesday, May 8, 2012

the problem of cognos configuration for oracle database connection


1. 20:04:41, 'LogService', 'StartService', 'Success'.
2. 20:04:47, 'ContentManager', 'getActiveContentManager', 'Failure'.
DPR-CMI-4006 Unable to determine the active Content Manager. Will retry periodically.
3. 20:04:47, 'com.cognos.pogo.contentmanager.coordinator.ActiveCMControl', 'pogo', 'Failure'.
DPR-DPR-1035 Dispatcher detected an error.

4. 20:04:46, CM-CFG-5063 A Content Manager configuration error was detected while connecting to the content store.
CM-CFG-5063 A Content Manager configuration error was detected while connecting to the content store.
CM-CFG-5137 Content Manager was unable to complete the initialization of the content store. For more information, review the log file. Before you restart Content Manager, you may need to recreate the content store database or clean it using dbClean_*.sql.
5. 20:05:10, 'ContentManagerService', 'StopService', 'Success'.
6. 20:05:10, 'ContentManagerService', 'StopService', 'Success'.
7. 20:05:10, 'CPS Producer Registration Service', 'StopService', 'Success'.
8. 20:05:10, 'CPS Producer Registration Service', 'StopService', 'Success'.
9. 20:05:10, 'MonitorService', 'StopService', 'Success'.
10. 20:05:10, 'MonitorService', 'StopService', 'Success'.
11. 20:05:10, 'DeliveryService', 'StopService', 'Success'.
12. 20:05:10, 'DeliveryService', 'StopService', 'Success'.
13. 20:05:11, 'EventService', 'StopService', 'Success'.
14. 20:05:11, 'EventService', 'StopService', 'Success'.
15. 20:05:11, 'JobService', 'StopService', 'Success'.
16. 20:05:11, 'JobService', 'StopService', 'Success'.
17. 20:05:11, 'com.cognos.pogo.services.DefaultHandlerService', 'pogo', 'Failure'.
DPR-DPR-1035 Dispatcher detected an error.

18. 20:05:11, 'com.cognos.pogo.services.DefaultHandlerService', 'pogo', 'Failure'.
DPR-DPR-1035 Dispatcher detected an error.

19. 20:05:11, 'SystemService', 'StopService', 'Success'.
20. 20:05:11, 'SystemService', 'StopService', 'Success'.
21. 20:05:11, 'MetricsManagerService', 'StopService', 'Success'.
22. 20:05:11, 'MetricsManagerService', 'StopService', 'Success'.
23. 20:05:11, 'BatchReportService', 'StopService', 'Success'.
24. 20:05:11, 'BatchReportService', 'StopService', 'Success'.
25. 20:05:11, 'DataIntegrationService', 'StopService', 'Success'.
26. 20:05:11, 'DataIntegrationService', 'StopService', 'Success'.
27. 20:05:11, 'ReportService', 'StopService', 'Success'.
28. 20:05:11, 'ReportService', 'StopService', 'Success'.
29. 20:05:11, 'LogService', 'StopService', 'Success'.
30. 20:05:11, 'LogService', 'StopService', 'Success'.
31. [ ERROR ] CFG-ERR-0103 Unable to start Cognos 8 service.
Execution of the external process returns an error code value of '-1'.
how to solve this problem
1 alter oracle database character to utf8
2 create a new user and grant the user resource, connect, and dba privilage
3 restart database
4 delete the privious configuration in content manager, and setup a new one
5 happy, it can work

No comments:

Post a Comment