cognos 10.2 连接内容库问题 数据库为sql 2005 系统是windows 2008

0

13:40:16, 'LogService', 'StartService', 'Success'.
13:40:17, CAF input validation enabled.
13:40:17, CAF Third Party XSS checking disabled.
13:40:21, 'ContentManager', 'getActiveContentManager', 'Failure'.
DPR-CMI-4006 Unable to determine the active Content Manager. Will retry periodically.
13:40:21, CM-CFG-5063 A Content Manager configuration error was detected while connecting to the content store. CM-SYS-5003 Content Manager is unable to connect to the content store. Verify that the database connection properties in the configuration tool are correct and that when you test the connection, the test is successful. Failed Logon:com.jnetdirect.jsql.JSQLException: TCP/IP connection failed to host:localhost com.jnetdirect.jsql.JSQLException: 用户 'sa' 登录失败。 url:jdbc:JSQLConnect://localhost:1433/cognosdb/applicationName=IBM_C10_2_CM Cause: Failed Logon:com.jnetdirect.jsql.JSQLException: TCP/IP connection failed to host:localhost com.jnetdirect.jsql.JSQLException: 用户 'sa' 登录失败。 url:jdbc:JSQLConnect://localhost:1433/cognosdb/applicationName=IBM_C10_2_CM Stack trace: com.jnetdirect.jsql.JSQLException: Failed Logon:com.jnetdirect.jsql.JSQLException: TCP/IP connection failed to host:localhost com.jnetdirect.jsql.JSQLException: 用户 'sa' 登录失败。 url:jdbc:JSQLConnect://localhost:1433/cognosdb/applicationName=IBM_C10_2_CM at com.jnetdirect.jsql.JSQLDriver.connect(JSQLDriver.java:302) at java.sql.DriverManager.getConnection(DriverManager.java:379) at java.sql.DriverManager.getConnection(DriverManager.java:415) at com.cognos.cm.dbstore.CMDbStoreFactory.getJDBCConnection(CMDbStoreFactory.java:1955) at com.cognos.cm.dbstore.CMDbStoreFactory.getInitialConnection(CMDbStoreFactory.java:1742) at com.cognos.cm.dbstore.CMDbStoreFactory.initContentIndependentBeforeLock(CMDbStoreFactory.java:1975) at com.cognos.cm.dbstore.CMDbStore.initializeContentIndependentBeforeLock(CMDbStore.java:3973) at com.cognos.cm.server.CMServlet.initializeContentStoreContentIndependentBeforeLock(CMServlet.java:2079) at com.cognos.cm.server.CMServlet.init(CMServlet.java:1847) at com.cognos.cm.server.ContentManager.start(ContentManager.java:405) 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.startInitialService(DispatcherServices.java:415) at com.cognos.pogo.services.DispatcherServices.startInititalServices(DispatcherServices.java:401) at com.cognos.pogo.transport.PogoServlet$PogoStartup.run(PogoServlet.java:751) at com.cognos.pogo.util.threads.SafeThread.safeRun(SafeThread.java:70) at com.cognos.pogo.util.threads.SafeThread.run(SafeThread.java:61)
13:40:21, 'com.cognos.pogo.contentmanager.coordinator.ActiveCMControl', 'pogo', 'Failure'.
DPR-DPR-1035 Dispatcher detected an error.
null
13:41:17, 'CPS Producer Registration Service', 'StopService', 'Success'.
13:41:18, 'AnnotationService', 'StopService', 'Success'.
13:41:18, 'AgentService', 'StopService', 'Success'.
13:41:17, 'MetadataService', 'StopService', 'Success'.
13:41:17, 'Dispatcher', 'Stop', 'Success'.
13:41:18, 'DimensionManagementService', 'StopService', 'Success'.
13:41:17, 'IndexDataService', 'StopService', 'Success'.
13:41:18, 'JobService', 'StopService', 'Success'.
13:41:17, 'EventService', 'StopService', 'Success'.
13:41:18, 'IndexUpdateService', 'StopService', 'Success'.
13:41:18, 'DeliveryService', 'StopService', 'Success'.
13:41:18, 'HumanTaskService', 'StopService', 'Success'.
13:41:18, 'relationalMetadataService', 'StopService', 'Success'.
13:41:18, 'camAsyncAA', 'StopService', 'Success'.
13:41:18, 'ReportDataService', 'StopService', 'Success'.
13:41:18, 'IndexSearchService', 'StopService', 'Success'.
13:41:18, 'com.cognos.pogo.services.DefaultHandlerService', 'pogo', 'Failure'.
DPR-DPR-1035 Dispatcher detected an error.
null
13:41:18, 'IBM Cognos Enhanced Search Service', 'StopService', 'Success'.
13:41:18, 'ContentManagerCacheService', 'StopService', 'Success'.
13:41:18, 'CacheService', 'StopService', 'Success'.
13:41:18, 'MonitorService', 'StopService', 'Success'.
13:41:18, 'idVizService', 'StopService', 'Success'.
13:41:18, 'ReportService', 'StopService', 'Success'.
13:41:18, 'GraphicsService', 'StopService', 'Success'.
13:41:18, 'com.cognos.pogo.services.DefaultHandlerService', 'pogo', 'Failure'.
DPR-DPR-1035 Dispatcher detected an error.
null
13:41:18, 'RepositoryService', 'StopService', 'Success'.
13:41:18, 'BatchReportService', 'StopService', 'Success'.
13:41:18, 'SystemService', 'StopService', 'Success'.
13:41:18, 'com.cognos.pogo.services.DefaultHandlerService', 'pogo', 'Failure'.
DPR-DPR-1035 Dispatcher detected an error.
null
13:41:18, 'ContentManagerService', 'StopService', 'Success'.
13:41:18, 'BUX Service', 'StopService', 'Success'.
13:41:18, 'Fragment Server Service', 'StopService', 'Success'.
13:41:18, 'QueryService', 'StopService', 'Success'.
13:41:18, 'LogService', 'StopService', 'Success'.


CFG-ERR-0103 Unable to start IBM Cognos service.
Execution of the external process returns an error code value of '-1'.
已邀请:
0

housheng33 - 专注金融BI http://blog.csdn.net/housheng33 2013-08-11 回答

用户 'sa' 登录失败。

请先测试一下cognos configuration --数据访问 -----content manager

SQLSERVER的jar 是否放到安装目录C:\Program Files\IBM\cognos\c10\webapps\p2pd\WEB-INF\lib
下?
0

nts - 学习者 2013-08-11 回答

测试 内容库连接是下图所示,你说的那个sql server jar 包一定要放到 安装目录下面吗? jar 包在那个目录下面,请指教。 我连接时显示如下错误 :

15:52:07, 'LogService', 'StartService', 'Success'.
15:52:08, CAF input validation enabled.
15:52:08, CAF Third Party XSS checking disabled.
15:52:13, 'com.cognos.pogo.contentmanager.coordinator.ActiveCMControl', 'pogo', 'Failure'.
DPR-DPR-1035 Dispatcher detected an error.
null
15:52:13, 'ContentManager', 'getActiveContentManager', 'Failure'.
DPR-CMI-4006 Unable to determine the active Content Manager. Will retry periodically.
15:52:12, 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. Cause: 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. Stack trace: 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. at com.cognos.cm.dbstore.CMDbStoreFactory.initContentIndependentBeforeLock(CMDbStoreFactory.java:1993) at com.cognos.cm.dbstore.CMDbStore.initializeContentIndependentBeforeLock(CMDbStore.java:3973) at com.cognos.cm.server.CMServlet.initializeContentStoreContentIndependentBeforeLock(CMServlet.java:2079) at com.cognos.cm.server.CMServlet.init(CMServlet.java:1847) at com.cognos.cm.server.ContentManager.start(ContentManager.java:405) 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.startInitialService(DispatcherServices.java:415) at com.cognos.pogo.services.DispatcherServices.startInititalServices(DispatcherServices.java:401) at com.cognos.pogo.transport.PogoServlet$PogoStartup.run(PogoServlet.java:751) at com.cognos.pogo.util.threads.SafeThread.safeRun(SafeThread.java:70) at com.cognos.pogo.util.threads.SafeThread.run(SafeThread.java:61)
15:53:06, 'Dispatcher', 'Stop', 'Success'.
15:53:07, 'JobService', 'StopService', 'Success'.
15:53:07, 'AnnotationService', 'StopService', 'Success'.
15:53:07, 'EventService', 'StopService', 'Success'.
15:53:07, 'AgentService', 'StopService', 'Success'.
15:53:07, 'MetadataService', 'StopService', 'Success'.
15:53:07, 'HumanTaskService', 'StopService', 'Success'.
15:53:07, 'IndexUpdateService', 'StopService', 'Success'.
15:53:07, 'DeliveryService', 'StopService', 'Success'.
15:53:07, 'CPS Producer Registration Service', 'StopService', 'Success'.
15:53:07, 'IndexDataService', 'StopService', 'Success'.
15:53:07, 'MonitorService', 'StopService', 'Success'.
15:53:07, 'DimensionManagementService', 'StopService', 'Success'.
15:53:07, 'IndexSearchService', 'StopService', 'Success'.
15:53:07, 'ReportService', 'StopService', 'Success'.
15:53:07, 'CacheService', 'StopService', 'Success'.
15:53:07, 'relationalMetadataService', 'StopService', 'Success'.
15:53:07, 'ReportDataService', 'StopService', 'Success'.
15:53:07, 'GraphicsService', 'StopService', 'Success'.
15:53:07, 'com.cognos.pogo.services.DefaultHandlerService', 'pogo', 'Failure'.
DPR-DPR-1035 Dispatcher detected an error.
null
15:53:07, 'com.cognos.pogo.services.DefaultHandlerService', 'pogo', 'Failure'.
DPR-DPR-1035 Dispatcher detected an error.
null
15:53:07, 'IBM Cognos Enhanced Search Service', 'StopService', 'Success'.
15:53:07, 'idVizService', 'StopService', 'Success'.
15:53:07, 'camAsyncAA', 'StopService', 'Success'.
15:53:07, 'ContentManagerCacheService', 'StopService', 'Success'.
15:53:08, 'QueryService', 'StopService', 'Success'.
15:53:08, 'Fragment Server Service', 'StopService', 'Success'.
15:53:08, 'RepositoryService', 'StopService', 'Success'.
15:53:08, 'ContentManagerService', 'StopService', 'Success'.
15:53:08, 'BatchReportService', 'StopService', 'Success'.
15:53:08, 'com.cognos.pogo.services.DefaultHandlerService', 'pogo', 'Failure'.
DPR-DPR-1035 Dispatcher detected an error.
null
15:53:08, 'SystemService', 'StopService', 'Success'.
15:53:08, 'BUX Service', 'StopService', 'Success'.
15:53:08, 'LogService', 'StopService', 'Success'.


CFG-ERR-0103 Unable to start IBM Cognos service.
Execution of the external process returns an error code value of '-1'.

要回复问题请先登录注册