If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Unable to start Cognos Analytics

Started by matta_anupama, 21 Feb 2018 04:14:23 AM

Previous topic - Next topic

matta_anupama

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

MFGF

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.
Meep!

matta_anupama

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

matta_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

MFGF

What are you using as your content store? Are you seeing any relevant entries in cogserver.log that identify what is going on?

MF.
Meep!

matta_anupama

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

MFGF

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.
Meep!

matta_anupama

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

MFGF

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.
Meep!

matta_anupama

Yes.  The database user has dbo previliges on the database.

Thanks,
Anupama

MFGF

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.
Meep!

matta_anupama

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