Hi All,
Our company is using Cognos 10.2.1 and now we want to upgrade to Cognos Analytics.
I have downloaded Cognos Analytics (11.0.8 ) and Installed Content Manager components. Set up a new SQL server database for CM.
When I start from the configuration, it has created all the tables in Content Store and Audit log databases but failed to start with the following error:
CM-CFG-5064 A Content Manager configuration error was detected while creating the initial content objects. CM-REQ-4332 Unable to create security object proxy. Unable to retrieve user information required to create account proxy object for the object "::Anonymous".
I have disabled 'Anonymous' access.
Tried creating the content store again (on a new database), but the error is same.
Could some one please shed some light on how to resolve this issue?
Thanks,
Anupama
Quote from: matta_anupama on 21 Feb 2018 04:14:23 AM
Hi All,
Our company is using Cognos 10.2.1 and now we want to upgrade to Cognos Analytics.
I have downloaded Cognos Analytics (11.0.8 ) and Installed Content Manager components. Set up a new SQL server database for CM.
When I start from the configuration, it has created all the tables in Content Store and Audit log databases but failed to start with the following error:
CM-CFG-5064 A Content Manager configuration error was detected while creating the initial content objects. CM-REQ-4332 Unable to create security object proxy. Unable to retrieve user information required to create account proxy object for the object "::Anonymous".
I have disabled 'Anonymous' access.
Tried creating the content store again (on a new database), but the error is same.
Could some one please shed some light on how to resolve this issue?
Thanks,
Anupama
CM-REQ-4332 makes me think there is an issue with your cryptographic keys. Are you installing on the same machine as Cognos 10.2.1 or a different machine?
MF.
Hi MF,
I have un-installed Cognos 10.2.1 and installing Cognos Analytics on that machine.
I thought that could be a case, but I don't see the folders: encryptkeypair and signkeypair at all.
Thanks,
Anupama
Also, one other thing I observed is, the newly created content store database has got just 110 tables and there are no NC_* tables.
I tried cleaning up the database / with a new empty database and start cognos content mangaer. Both times I ended up with only 110 tables in the content store?
Any idea why NC_* tables are not getting created?
Thanks,
Anupama
What are you using as your content store? Are you seeing any relevant entries in cogserver.log that identify what is going on?
MF.
I am using SQL server 2014 as the content store. I could only see the following error in the log file:
CM-CFG-5064 A Content Manager configuration error was detected while creating the initial content objects. CM-REQ-4332 Unable to create security object proxy. Unable to retrieve user information required to create account proxy object for the object "::Anonymous".
10.240.181.29:9300 46956 2018-02-26 18:13:04.449 +5:30 Initialization_SESS Initialization_REQ Thread-52 CM 9 1 Audit.cms.CM StartService ContentManagerService Failure CM-SYS-5007 Content Manager build 11.0.9.10 failed to start! Review the Content Manager log files and then contact your system administrator or customer support.
10.240.181.29:9300 46956 2018-02-26 18:13:35.214 +5:30 pogoStartup na na 0 Thread-52 DISP 8 1 Audit.Other.dispatcher.DISP.com.cognos.pogo.contentmanager.coordinator.CMBootstrap getActiveContentManager ContentManager Failure <messages><message><messageString>DPR-CMI-4006 Unable to determine the active Content Manager. Will retry periodically.</messageString></message></messages>
Following exception is there in cognosserver.log
2018-02-27T13:09:40.133+0530 INFO STATU.com.cogno.pogo.servi.DispatcherServices [Default Executor-thread-104] NA StopService CPS Producer Registration Service Success
2018-02-27T13:09:40.243+0530 INFO STATU.com.cogno.pogo.servi.DispatcherServices [Default Executor-thread-104] NA StopService AnnotationService Success
2018-02-27T13:09:40.133+0530 ERROR com.cogno.pogo.conte.coord.ActiveCMControl [Timer-23] NA DPR-CMI-4007 Unable to perform an active Content Manager election on the local IP node. For more information, see the dispatcher and Content Manager detailed logs. Ensure that the local Content Manager service is started.
com.cognos.pogo.bibus.CommandExecutionIOException: Failed to send HTTP request or read HTTP response
at com.cognos.pogo.bibus.BIBusCommand.handleDefaultException(BIBusCommand.java:372) ~[p2pd.jar:?]
at com.cognos.pogo.bibus.BIBusCommand.execute(BIBusCommand.java:205) ~[p2pd.jar:?]
at com.cognos.pogo.contentmanager.StandbyContentManagerElectionCommand.executeIfLocal(StandbyContentManagerElectionCommand.java:53) ~[p2pd.jar:?]
at com.cognos.pogo.contentmanager.coordinator.ActiveCMControl.sendElectCommand(ActiveCMControl.java:213) [p2pd.jar:?]
at com.cognos.pogo.contentmanager.coordinator.ActiveCMControl.access$300(ActiveCMControl.java:30) [p2pd.jar:?]
at com.cognos.pogo.contentmanager.coordinator.ActiveCMControl$GetActiveCMTask.safeRun(ActiveCMControl.java:204) [p2pd.jar:?]
at com.cognos.pogo.util.threads.SafeTimerTask.run(SafeTimerTask.java:40) [p2pd.jar:?]
at java.util.TimerThread.mainLoop(Timer.java:566) [?:1.8.0]
at java.util.TimerThread.run(Timer.java:516) [?:1.8.0]
Caused by: java.io.IOException: Failed to send HTTP request or read HTTP response
at com.cognos.pogo.http.ServerConnection.executeMethod(ServerConnection.java:800) ~[p2pd.jar:?]
at com.cognos.pogo.http.ServerConnection.sendRequest(ServerConnection.java:254) ~[p2pd.jar:?]
at com.cognos.pogo.bibus.BIBusCommand.sendRequest(BIBusCommand.java:230) ~[p2pd.jar:?]
at com.cognos.pogo.bibus.BIBusCommand.executeCommand(BIBusCommand.java:214) ~[p2pd.jar:?]
at com.cognos.pogo.bibus.BIBusCommand.execute(BIBusCommand.java:199) ~[p2pd.jar:?]
... 7 more
Caused by: java.net.ConnectException: Connection refused: connect
at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:380) ~[?:1.8.0]
at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:236) ~[?:1.8.0]
at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:218) ~[?:1.8.0]
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:183) ~[?:1.8.0]
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:403) ~[?:1.8.0]
at java.net.Socket.connect(Socket.java:666) ~[?:1.8.0]
at java.net.Socket.connect(Socket.java:606) ~[?:1.8.0]
at java.net.Socket.<init>(Socket.java:469) ~[?:1.8.0]
at java.net.Socket.<init>(Socket.java:314) ~[?:1.8.0]
at org.apache.commons.httpclient.protocol.DefaultProtocolSocketFactory.createSocket(DefaultProtocolSocketFactory.java:80) ~[commons-httpclient-3.1.jar:?]
at org.apache.commons.httpclient.protocol.DefaultProtocolSocketFactory.createSocket(DefaultProtocolSocketFactory.java:122) ~[commons-httpclient-3.1.jar:?]
at org.apache.commons.httpclient.HttpConnection.open(HttpConnection.java:707) ~[commons-httpclient-3.1.jar:?]
at org.apache.commons.httpclient.HttpMethodDirector.executeWithRetry(HttpMethodDirector.java:387) ~[commons-httpclient-3.1.jar:?]
at org.apache.commons.httpclient.HttpMethodDirector.executeMethod(HttpMethodDirector.java:171) ~[commons-httpclient-3.1.jar:?]
at org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:397) ~[commons-httpclient-3.1.jar:?]
at org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:323) ~[commons-httpclient-3.1.jar:?]
at com.cognos.pogo.http.ServerConnection.executeMethodSynchronously(ServerConnection.java:829) ~[p2pd.jar:?]
at com.cognos.pogo.http.ServerConnection.executeMethod(ServerConnection.java:781) ~[p2pd.jar:?]
at com.cognos.pogo.http.ServerConnection.sendRequest(ServerConnection.java:254) ~[p2pd.jar:?]
at com.cognos.pogo.bibus.BIBusCommand.sendRequest(BIBusCommand.java:230) ~[p2pd.jar:?]
at com.cognos.pogo.bibus.BIBusCommand.executeCommand(BIBusCommand.java:214) ~[p2pd.jar:?]
at com.cognos.pogo.bibus.BIBusCommand.execute(BIBusCommand.java:199) ~[p2pd.jar:?]
... 7 more
2018-02-27T13:09:43.971+0530 INFO STATU.com.cogno.pogo.servi.DispatcherServices [Default Executor-thread-104] NA StopService HumanTaskService Success
2018-02-27T13:09:44.033+0530 INFO STATU.com.cogno.pogo.servi.DispatcherServices [Default Executor-thread-104] NA StopService MetadataService Success
2018-02-27T13:09:44.642+0530 INFO STATU.com.cogno.pogo.servi.DispatcherServices [Default Executor-thread-104] NA StopService SACamSrvc Success
2018-02-27T13:09:44.642+0530 INFO STATU.com.cogno.pogo.servi.DispatcherServices [Default Executor-thread-104] NA StopService idVizService Success
2018-02-27T13:09:44.657+0530 INFO STATU.com.cogno.pogo.servi.DispatcherServices [Default Executor-thread-104] NA StopService SACamSrvcInternal Success
2018-02-27T13:09:44.657+0530 INFO STATU.com.cogno.pogo.servi.DispatcherServices [Default Executor-thread-104] NA StopService BatchReportService Success
2018-02-27T13:09:44.657+0530 INFO STATU.com.cogno.pogo.servi.DispatcherServices [Default Executor-thread-104] NA StopService relationalMetadataService Success
2018-02-27T13:09:44.657+0530 ERROR com.cogno.pogo.servi.DefaultHandlerService [stopper-DropinFolderMonitorHandler] NA problem stopping handler directorywatcher
java.lang.NullPointerException: null
at com.cognos.pogo.dropin.DropinFolderMonitorHandler.stop(DropinFolderMonitorHandler.java:70) ~[p2pd.jar:?]
at com.cognos.pogo.services.DefaultHandlerService.stop(DefaultHandlerService.java:157) [p2pd.jar:?]
at com.cognos.pogo.services.DispatcherServices$ServiceStopper.safeRun(DispatcherServices.java:364) [p2pd.jar:?]
at com.cognos.pogo.util.threads.SafeThread.run(SafeThread.java:61) [p2pd.jar:?]
2018-02-27T13:09:44.657+0530 INFO STATU.com.cogno.pogo.servi.DispatcherServices [Default Executor-thread-104] NA StopService ContentManagerCacheService Success
2018-02-27T13:09:44.657+0530 INFO STATU.com.cogno.pogo.servi.DispatcherServices [Default Executor-thread-104] NA StopService ReportDataService Success
2018-02-27T13:09:44.673+0530 INFO STATU.com.cogno.pogo.servi.DispatcherServices [Default Executor-thread-104] NA StopService SystemService Success
2018-02-27T13:09:44.689+0530 INFO STATU.com.cogno.pogo.servi.DispatcherServices [Default Executor-thread-104] NA StopService Fragment Server Service Success
2018-02-27T13:09:44.689+0530 INFO STATU.com.cogno.pogo.servi.DispatcherServices [Default Executor-thread-104] NA StopService camAsyncAA Success
2018-02-27T13:09:44.689+0530 INFO STATU.com.cogno.pogo.servi.DispatcherServices [Default Executor-thread-104] NA StopService CacheService Success
2018-02-27T13:09:44.704+0530 INFO STATU.com.cogno.pogo.servi.DispatcherServices [Default Executor-thread-104] NA StopService MobileService Success
2018-02-27T13:09:44.782+0530 INFO STATU.com.cogno.pogo.servi.DispatcherServices [Default Executor-thread-104] NA StopService visualisationGalleryService Success
2018-02-27T13:09:44.782+0530 INFO STATU.com.cogno.pogo.servi.DispatcherServices [Default Executor-thread-104] NA StopService ReportService Success
2018-02-27T13:09:44.782+0530 INFO STATU.com.cogno.pogo.servi.DispatcherServices [Default Executor-thread-104] NA StopService QueryService Success
2018-02-27T13:09:44.782+0530 INFO STATU.com.cogno.pogo.servi.DispatcherServices [Default Executor-thread-104] NA StopService RepositoryService Success
2018-02-27T13:09:44.782+0530 INFO STATU.com.cogno.pogo.servi.DispatcherServices [Default Executor-thread-104] NA StopService burstDistributionService Success
2018-02-27T13:09:44.798+0530 INFO STATU.com.cogno.pogo.servi.DispatcherServices [Default Executor-thread-104] NA StopService GraphicsService Success
2018-02-27T13:09:44.798+0530 ERROR com.cogno.pogo.servi.DefaultHandlerService [stopper-graphicsService] NA problem stopping handler graphicsServiceHandler
java.lang.NullPointerException: null
at com.ibm.cgsBus.service.GraphicsServiceHandler.stop(Unknown Source) ~[cgsService.jar:?]
at com.cognos.pogo.services.DefaultHandlerService.stop(DefaultHandlerService.java:157) [p2pd.jar:?]
at com.cognos.pogo.services.DispatcherServices$ServiceStopper.safeRun(DispatcherServices.java:364) [p2pd.jar:?]
at com.cognos.pogo.util.threads.SafeThread.run(SafeThread.java:61) [p2pd.jar:?]
2018-02-27T13:09:44.798+0530 INFO STATU.com.cogno.pogo.servi.DispatcherServices [Default Executor-thread-104] NA StopService BUX Service Success
2018-02-27T13:09:44.798+0530 ERROR com.cogno.pogo.servi.DefaultHandlerService [stopper-buxService] NA problem stopping handler buxServiceHandler
java.lang.NullPointerException: null
at com.ibm.cognos.bux.buxservice.BUXServiceBaseHandler.stop(BUXServiceBaseHandler.java:270) ~[com.ibm.cognos.bux.handler.jar:?]
at com.cognos.pogo.services.DefaultHandlerService.stop(DefaultHandlerService.java:157) [p2pd.jar:?]
at com.cognos.pogo.services.DispatcherServices$ServiceStopper.safeRun(DispatcherServices.java:364) [p2pd.jar:?]
at com.cognos.pogo.util.threads.SafeThread.run(SafeThread.java:61) [p2pd.jar:?]
2018-02-27T13:09:44.860+0530 ERROR com.cogno.pogo.servi.DefaultHandlerService [stopper-presentationService] NA problem stopping handler cognosViewerExpeditorHandler
java.lang.NullPointerException: null
at com.cognos.viewer.controller.expeditor.CognosViewerExpeditorDispatcherHandler.stop(Unknown Source) ~[viewer.jar:?]
at com.cognos.pogo.services.DefaultHandlerService.stop(DefaultHandlerService.java:157) [p2pd.jar:?]
at com.cognos.pogo.services.DispatcherServices$ServiceStopper.safeRun(DispatcherServices.java:364) [p2pd.jar:?]
at com.cognos.pogo.util.threads.SafeThread.run(SafeThread.java:61) [p2pd.jar:?]
2018-02-27T13:09:44.860+0530 INFO STATU.com.cogno.pogo.servi.DispatcherServices [Default Executor-thread-104] NA StopService zipiService Success
2018-02-27T13:09:44.860+0530 INFO STATU.com.cogno.pogo.servi.DispatcherServices [Default Executor-thread-104] NA StopService PDC Success
Thanks,
Anupama
Quote from: matta_anupama on 27 Feb 2018 07:36:23 AM
I am using SQL server 2014 as the content store. I could only see the following error in the log file:
CM-CFG-5064 A Content Manager configuration error was detected while creating the initial content objects. CM-REQ-4332 Unable to create security object proxy. Unable to retrieve user information required to create account proxy object for the object "::Anonymous".
10.240.181.29:9300 46956 2018-02-26 18:13:04.449 +5:30 Initialization_SESS Initialization_REQ Thread-52 CM 9 1 Audit.cms.CM StartService ContentManagerService Failure CM-SYS-5007 Content Manager build 11.0.9.10 failed to start! Review the Content Manager log files and then contact your system administrator or customer support.
10.240.181.29:9300 46956 2018-02-26 18:13:35.214 +5:30 pogoStartup na na 0 Thread-52 DISP 8 1 Audit.Other.dispatcher.DISP.com.cognos.pogo.contentmanager.coordinator.CMBootstrap getActiveContentManager ContentManager Failure <messages><message><messageString>DPR-CMI-4006 Unable to determine the active Content Manager. Will retry periodically.</messageString></message></messages>
Following exception is there in cognosserver.log
2018-02-27T13:09:40.133+0530 INFO STATU.com.cogno.pogo.servi.DispatcherServices [Default Executor-thread-104] NA StopService CPS Producer Registration Service Success
2018-02-27T13:09:40.243+0530 INFO STATU.com.cogno.pogo.servi.DispatcherServices [Default Executor-thread-104] NA StopService AnnotationService Success
2018-02-27T13:09:40.133+0530 ERROR com.cogno.pogo.conte.coord.ActiveCMControl [Timer-23] NA DPR-CMI-4007 Unable to perform an active Content Manager election on the local IP node. For more information, see the dispatcher and Content Manager detailed logs. Ensure that the local Content Manager service is started.
com.cognos.pogo.bibus.CommandExecutionIOException: Failed to send HTTP request or read HTTP response
at com.cognos.pogo.bibus.BIBusCommand.handleDefaultException(BIBusCommand.java:372) ~[p2pd.jar:?]
at com.cognos.pogo.bibus.BIBusCommand.execute(BIBusCommand.java:205) ~[p2pd.jar:?]
at com.cognos.pogo.contentmanager.StandbyContentManagerElectionCommand.executeIfLocal(StandbyContentManagerElectionCommand.java:53) ~[p2pd.jar:?]
at com.cognos.pogo.contentmanager.coordinator.ActiveCMControl.sendElectCommand(ActiveCMControl.java:213) [p2pd.jar:?]
at com.cognos.pogo.contentmanager.coordinator.ActiveCMControl.access$300(ActiveCMControl.java:30) [p2pd.jar:?]
at com.cognos.pogo.contentmanager.coordinator.ActiveCMControl$GetActiveCMTask.safeRun(ActiveCMControl.java:204) [p2pd.jar:?]
at com.cognos.pogo.util.threads.SafeTimerTask.run(SafeTimerTask.java:40) [p2pd.jar:?]
at java.util.TimerThread.mainLoop(Timer.java:566) [?:1.8.0]
at java.util.TimerThread.run(Timer.java:516) [?:1.8.0]
Caused by: java.io.IOException: Failed to send HTTP request or read HTTP response
at com.cognos.pogo.http.ServerConnection.executeMethod(ServerConnection.java:800) ~[p2pd.jar:?]
at com.cognos.pogo.http.ServerConnection.sendRequest(ServerConnection.java:254) ~[p2pd.jar:?]
at com.cognos.pogo.bibus.BIBusCommand.sendRequest(BIBusCommand.java:230) ~[p2pd.jar:?]
at com.cognos.pogo.bibus.BIBusCommand.executeCommand(BIBusCommand.java:214) ~[p2pd.jar:?]
at com.cognos.pogo.bibus.BIBusCommand.execute(BIBusCommand.java:199) ~[p2pd.jar:?]
... 7 more
Caused by: java.net.ConnectException: Connection refused: connect
at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:380) ~[?:1.8.0]
at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:236) ~[?:1.8.0]
at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:218) ~[?:1.8.0]
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:183) ~[?:1.8.0]
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:403) ~[?:1.8.0]
at java.net.Socket.connect(Socket.java:666) ~[?:1.8.0]
at java.net.Socket.connect(Socket.java:606) ~[?:1.8.0]
at java.net.Socket.<init>(Socket.java:469) ~[?:1.8.0]
at java.net.Socket.<init>(Socket.java:314) ~[?:1.8.0]
at org.apache.commons.httpclient.protocol.DefaultProtocolSocketFactory.createSocket(DefaultProtocolSocketFactory.java:80) ~[commons-httpclient-3.1.jar:?]
at org.apache.commons.httpclient.protocol.DefaultProtocolSocketFactory.createSocket(DefaultProtocolSocketFactory.java:122) ~[commons-httpclient-3.1.jar:?]
at org.apache.commons.httpclient.HttpConnection.open(HttpConnection.java:707) ~[commons-httpclient-3.1.jar:?]
at org.apache.commons.httpclient.HttpMethodDirector.executeWithRetry(HttpMethodDirector.java:387) ~[commons-httpclient-3.1.jar:?]
at org.apache.commons.httpclient.HttpMethodDirector.executeMethod(HttpMethodDirector.java:171) ~[commons-httpclient-3.1.jar:?]
at org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:397) ~[commons-httpclient-3.1.jar:?]
at org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:323) ~[commons-httpclient-3.1.jar:?]
at com.cognos.pogo.http.ServerConnection.executeMethodSynchronously(ServerConnection.java:829) ~[p2pd.jar:?]
at com.cognos.pogo.http.ServerConnection.executeMethod(ServerConnection.java:781) ~[p2pd.jar:?]
at com.cognos.pogo.http.ServerConnection.sendRequest(ServerConnection.java:254) ~[p2pd.jar:?]
at com.cognos.pogo.bibus.BIBusCommand.sendRequest(BIBusCommand.java:230) ~[p2pd.jar:?]
at com.cognos.pogo.bibus.BIBusCommand.executeCommand(BIBusCommand.java:214) ~[p2pd.jar:?]
at com.cognos.pogo.bibus.BIBusCommand.execute(BIBusCommand.java:199) ~[p2pd.jar:?]
... 7 more
2018-02-27T13:09:43.971+0530 INFO STATU.com.cogno.pogo.servi.DispatcherServices [Default Executor-thread-104] NA StopService HumanTaskService Success
2018-02-27T13:09:44.033+0530 INFO STATU.com.cogno.pogo.servi.DispatcherServices [Default Executor-thread-104] NA StopService MetadataService Success
2018-02-27T13:09:44.642+0530 INFO STATU.com.cogno.pogo.servi.DispatcherServices [Default Executor-thread-104] NA StopService SACamSrvc Success
2018-02-27T13:09:44.642+0530 INFO STATU.com.cogno.pogo.servi.DispatcherServices [Default Executor-thread-104] NA StopService idVizService Success
2018-02-27T13:09:44.657+0530 INFO STATU.com.cogno.pogo.servi.DispatcherServices [Default Executor-thread-104] NA StopService SACamSrvcInternal Success
2018-02-27T13:09:44.657+0530 INFO STATU.com.cogno.pogo.servi.DispatcherServices [Default Executor-thread-104] NA StopService BatchReportService Success
2018-02-27T13:09:44.657+0530 INFO STATU.com.cogno.pogo.servi.DispatcherServices [Default Executor-thread-104] NA StopService relationalMetadataService Success
2018-02-27T13:09:44.657+0530 ERROR com.cogno.pogo.servi.DefaultHandlerService [stopper-DropinFolderMonitorHandler] NA problem stopping handler directorywatcher
java.lang.NullPointerException: null
at com.cognos.pogo.dropin.DropinFolderMonitorHandler.stop(DropinFolderMonitorHandler.java:70) ~[p2pd.jar:?]
at com.cognos.pogo.services.DefaultHandlerService.stop(DefaultHandlerService.java:157) [p2pd.jar:?]
at com.cognos.pogo.services.DispatcherServices$ServiceStopper.safeRun(DispatcherServices.java:364) [p2pd.jar:?]
at com.cognos.pogo.util.threads.SafeThread.run(SafeThread.java:61) [p2pd.jar:?]
2018-02-27T13:09:44.657+0530 INFO STATU.com.cogno.pogo.servi.DispatcherServices [Default Executor-thread-104] NA StopService ContentManagerCacheService Success
2018-02-27T13:09:44.657+0530 INFO STATU.com.cogno.pogo.servi.DispatcherServices [Default Executor-thread-104] NA StopService ReportDataService Success
2018-02-27T13:09:44.673+0530 INFO STATU.com.cogno.pogo.servi.DispatcherServices [Default Executor-thread-104] NA StopService SystemService Success
2018-02-27T13:09:44.689+0530 INFO STATU.com.cogno.pogo.servi.DispatcherServices [Default Executor-thread-104] NA StopService Fragment Server Service Success
2018-02-27T13:09:44.689+0530 INFO STATU.com.cogno.pogo.servi.DispatcherServices [Default Executor-thread-104] NA StopService camAsyncAA Success
2018-02-27T13:09:44.689+0530 INFO STATU.com.cogno.pogo.servi.DispatcherServices [Default Executor-thread-104] NA StopService CacheService Success
2018-02-27T13:09:44.704+0530 INFO STATU.com.cogno.pogo.servi.DispatcherServices [Default Executor-thread-104] NA StopService MobileService Success
2018-02-27T13:09:44.782+0530 INFO STATU.com.cogno.pogo.servi.DispatcherServices [Default Executor-thread-104] NA StopService visualisationGalleryService Success
2018-02-27T13:09:44.782+0530 INFO STATU.com.cogno.pogo.servi.DispatcherServices [Default Executor-thread-104] NA StopService ReportService Success
2018-02-27T13:09:44.782+0530 INFO STATU.com.cogno.pogo.servi.DispatcherServices [Default Executor-thread-104] NA StopService QueryService Success
2018-02-27T13:09:44.782+0530 INFO STATU.com.cogno.pogo.servi.DispatcherServices [Default Executor-thread-104] NA StopService RepositoryService Success
2018-02-27T13:09:44.782+0530 INFO STATU.com.cogno.pogo.servi.DispatcherServices [Default Executor-thread-104] NA StopService burstDistributionService Success
2018-02-27T13:09:44.798+0530 INFO STATU.com.cogno.pogo.servi.DispatcherServices [Default Executor-thread-104] NA StopService GraphicsService Success
2018-02-27T13:09:44.798+0530 ERROR com.cogno.pogo.servi.DefaultHandlerService [stopper-graphicsService] NA problem stopping handler graphicsServiceHandler
java.lang.NullPointerException: null
at com.ibm.cgsBus.service.GraphicsServiceHandler.stop(Unknown Source) ~[cgsService.jar:?]
at com.cognos.pogo.services.DefaultHandlerService.stop(DefaultHandlerService.java:157) [p2pd.jar:?]
at com.cognos.pogo.services.DispatcherServices$ServiceStopper.safeRun(DispatcherServices.java:364) [p2pd.jar:?]
at com.cognos.pogo.util.threads.SafeThread.run(SafeThread.java:61) [p2pd.jar:?]
2018-02-27T13:09:44.798+0530 INFO STATU.com.cogno.pogo.servi.DispatcherServices [Default Executor-thread-104] NA StopService BUX Service Success
2018-02-27T13:09:44.798+0530 ERROR com.cogno.pogo.servi.DefaultHandlerService [stopper-buxService] NA problem stopping handler buxServiceHandler
java.lang.NullPointerException: null
at com.ibm.cognos.bux.buxservice.BUXServiceBaseHandler.stop(BUXServiceBaseHandler.java:270) ~[com.ibm.cognos.bux.handler.jar:?]
at com.cognos.pogo.services.DefaultHandlerService.stop(DefaultHandlerService.java:157) [p2pd.jar:?]
at com.cognos.pogo.services.DispatcherServices$ServiceStopper.safeRun(DispatcherServices.java:364) [p2pd.jar:?]
at com.cognos.pogo.util.threads.SafeThread.run(SafeThread.java:61) [p2pd.jar:?]
2018-02-27T13:09:44.860+0530 ERROR com.cogno.pogo.servi.DefaultHandlerService [stopper-presentationService] NA problem stopping handler cognosViewerExpeditorHandler
java.lang.NullPointerException: null
at com.cognos.viewer.controller.expeditor.CognosViewerExpeditorDispatcherHandler.stop(Unknown Source) ~[viewer.jar:?]
at com.cognos.pogo.services.DefaultHandlerService.stop(DefaultHandlerService.java:157) [p2pd.jar:?]
at com.cognos.pogo.services.DispatcherServices$ServiceStopper.safeRun(DispatcherServices.java:364) [p2pd.jar:?]
at com.cognos.pogo.util.threads.SafeThread.run(SafeThread.java:61) [p2pd.jar:?]
2018-02-27T13:09:44.860+0530 INFO STATU.com.cogno.pogo.servi.DispatcherServices [Default Executor-thread-104] NA StopService zipiService Success
2018-02-27T13:09:44.860+0530 INFO STATU.com.cogno.pogo.servi.DispatcherServices [Default Executor-thread-104] NA StopService PDC Success
Thanks,
Anupama
Hmmm. Looks exactly like the issue the technote below addresses:
http://www-01.ibm.com/support/docview.wss?uid=swg21346491
Any luck with these?
MF.
First two options won't fit as I am starting on a new empty database and Cognos Analytics runs on WebSphere and not on tomcat.
Third option too don't make sense because it is able to create few tables in the content store.
Thanks,
Anupama
Quote from: matta_anupama on 01 Mar 2018 04:27:43 AM
First two options won't fit as I am starting on a new empty database and Cognos Analytics runs on WebSphere and not on tomcat.
Third option too don't make sense because it is able to create few tables in the content store.
Thanks,
Anupama
The process needs to do more than just create tables. Are you sure the database user ID you are using to connect has enough privileges?
MF.
Yes. The database user has dbo previliges on the database.
Thanks,
Anupama
Quote from: matta_anupama on 01 Mar 2018 07:46:20 AM
Yes. The database user has dbo previliges on the database.
Thanks,
Anupama
Not sure what else to suggest. I'd log a call with IBM to see what they can do to help.
Cheers!
MF.
Hi MF,
>>Third option too don't make sense because it is able to create few tables in the content store.
To check against this issue, I got a new server in the same location as the database server and started a fresh installation.
With both application and database servers are in the same location, I am able to start the the service.
Thanks a lot for your support.
- Anupama