COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Cognos Administration => Topic started by: pkunjir on 07 Jan 2015 03:50:57 AM

Title: Query Studio not working on cognos BI 10.2.2
Post by: pkunjir on 07 Jan 2015 03:50:57 AM
Hi Guys,

I've installed and configured cognos 10.2.2 64 bit on single linux machine. Previously we were using 10.1.1.  When I click on query studio it asks for package and once I select package it gives below error.

Unable to execute the request because there were no connections to the process available within the configured time limit.
Handler trace back:
[the_dispatcher] com.cognos.pogo.handlers.performance.PerformanceIndicationHandler
[the_dispatcher] com.cognos.pogo.handlers.logic.ChainHandler
[service_lookup] com.cognos.pogo.handlers.engine.ServiceLookupHandler
[load_balancer] com.cognos.pogo.handlers.logic.ChainHandler
[lb_forwarder] com.cognos.p2plb.clerver.LoadBalanceHandler
[reportservicechain] com.cognos.pogo.handlers.logic.ChainHandler
[warp_with_authenticate] com.cognos.pogo.handlers.logic.ChainHandler
[do_warp] com.cognos.pogo.handlers.logic.ChainHandler
[warpmta] com.cognos.pogo.reportservice.ReportServerHandler


Not sure what's causing this issue. Also I can see below error message is getting generated repeatedly in  cogserver.log. 

Audit.Other.dispatcher.DISP.pogo        pogo    com.cognos.pogo.reportservice.ProcessManager   Failure         
<messages><message><messageString>DPR-DPR-1035 Dispatcher detected an error.</messageString></message>
<message><messageString>Process BIBusTKServerMain failed to start properly.</messageString></message></messages>
External Report Server process BIBusTKServerMain cannot be startedProcess BIBusTKServerMain failed to start properly.
java.io.IOException: Process BIBusTKServerMain failed to start properly.
at com.cognos.pogo.reportservice.ReportServerProcess.getProcessOutput(ReportServerProcess.java:182)
at com.cognos.pogo.reportservice.ReportServerProcess.start(ReportServerProcess.java:125)
at com.cognos.pogo.reportservice.ProcessFacade.createServerProcess(ProcessFacade.java:275)
at com.cognos.pogo.reportservice.ProcessFacade.<init>(ProcessFacade.java:158)
at com.cognos.pogo.reportservice.ProcessFacade.<init>(ProcessFacade.java:117)
at com.cognos.pogo.reportservice.RSComponentFactory.newProcessFacade(RSComponentFactory.java:76)
at com.cognos.pogo.reportservice.ProcessManager.createProcessFacade(ProcessManager.java:516)
at com.cognos.pogo.reportservice.ProcessManager.startProcess(ProcessManager.java:492)
at com.cognos.pogo.reportservice.ProcessManager.startProcessesDueToCapacity(ProcessManager.java:387)
at com.cognos.pogo.reportservice.ProcessManager.safeRun(ProcessManager.java:345)
at com.cognos.pogo.util.threads.SafeThread.run(SafeThread.java:61)


Also I can see below error message while starting cognos service.

DISP    6100    1       Audit.Other.dispatcher.DISP.pogo     pogo    com.cognos.pogo.reportservice.ProcessManager           
Failure <messages><message><messageString>DPR-DPR-1035 Dispatcher detected an error.</messageString></message>
<message><messageString>Process BmtMDProviderMain failed to start properly.</messageString></message></messages>       
External Report Server process BmtMDProviderMain cannot be startedProcess BmtMDProviderMain failed to start properly.
java.io.IOException: Process BmtMDProviderMain failed to start properly.     
at com.cognos.pogo.reportservice.ReportServerProcess.getProcessOutput(ReportServerProcess.java:182)     
at com.cognos.pogo.reportservice.ReportServerProcess.start(ReportServerProcess.java:125)     
at com.cognos.metadataService.bibusHandler.mdprovider.MDProviderProcess.start(MDProviderProcess.java:58)     
at com.cognos.pogo.reportservice.ProcessFacade.createServerProcess(ProcessFacade.java:275)     
at com.cognos.pogo.reportservice.ProcessFacade.<init>(ProcessFacade.java:158)       
at com.cognos.pogo.reportservice.ProcessFacade.<init>(ProcessFacade.java:117)   
at com.cognos.metadataService.bibusHandler.mdprovider.MDProviderProcessFacade.<init>(MDProviderProcessFacade.java:61)       
at com.cognos.metadataService.bibusHandler.mdprovider.MDProviderComponentFactory.newProcessFacade(MDProviderComponentFactory.java:52)       
at com.cognos.pogo.reportservice.ProcessManager.createProcessFacade(ProcessManager.java:516)
at com.cognos.pogo.reportservice.ProcessManager.startProcess(ProcessManager.java:492)   
at com.cognos.pogo.reportservice.ProcessManager.startInitialProcesses(ProcessManager.java:366)       
at com.cognos.pogo.reportservice.ProcessManager.start(ProcessManager.java:297) 
at com.cognos.metadataService.bibusHandler.mdprovider.MDProviderProcessManager.start(MDProviderProcessManager.java:77)       
at com.cognos.metadataService.bibusHandler.MDSRVHandler.start(MDSRVHandler.java:324)
at com.cognos.pogo.services.DefaultHandlerService.start(DefaultHandlerService.java:88) 
at com.cognos.pogo.services.DispatcherServices.start(DispatcherServices.java:210)   
at com.cognos.pogo.services.DispatcherServices.continueStartup(DispatcherServices.java:466)     
at com.cognos.pogo.services.DispatcherServices.configure(DispatcherServices.java:158)       
at com.cognos.pogo.contentmanager.coordinator.RefreshController.composeAndConfigureServices(RefreshController.java:122)     
at com.cognos.pogo.contentmanager.coordinator.RefreshController.run(RefreshController.java:82) 
at com.cognos.pogo.contentmanager.coordinator.BootstrapConfigurePublish.startConfiguration(BootstrapConfigurePublish.java:151)       
at com.cognos.pogo.contentmanager.coordinator.BootstrapConfigurePublish.checkConfiguration(BootstrapConfigurePublish.java:130)       
at com.cognos.pogo.contentmanager.coordinator.BootstrapConfigurePublish.access$000(BootstrapConfigurePublish.java:34)       
at com.cognos.pogo.contentmanager.coordinator.BootstrapConfigurePublish$ConfigurationCheckTask.safeRun(BootstrapConfigurePublish.java:122)   
at com.cognos.pogo.util.threads.SafeTimerTask.run(SafeTimerTask.java:40)       
at java.util.TimerThread.mainLoop(Timer.java:555)   
at java.util.TimerThread.run(Timer.java:505)


And while shutdown it gives below error.


com.cognos.pogo.async.service.connection.bibustkserver.BIBusTKServerConnectionFactory-queryProcessManager-ProcessReaper     
DISP    6100    1       Audit.Other.dispatcher.DISP.pogo        pogo    com.cognos.pogo.reportservice.ProcessFacade         
Failure <messages><message><messageString>DPR-DPR-1035 Dispatcher detected an error.</messageString></message>
<message><messageString>Failed to send HTTP request or read HTTP response</messageString></message></messages>
Query Service - V5DataServerProcessFacade.sendStop failure. Failed to send HTTP request or read HTTP response
java.io.IOException: Failed to send HTTP request or read HTTP response 
at com.cognos.pogo.http.ServerConnection.executeMethod(ServerConnection.java:796)   
at com.cognos.pogo.http.ServerConnection.sendRequest(ServerConnection.java:252)
at com.cognos.xqebifw.cubingservices.CubingServicesComponentFactory$V5DataServerProcessFacade.sendStop(CubingServicesComponentFactory.java:392)     
at com.cognos.pogo.reportservice.ProcessReaper.destroyProcesses(ProcessReaper.java:183)     
at com.cognos.pogo.reportservice.ProcessReaper.safeRun(ProcessReaper.java:237) 
at com.cognos.pogo.util.threads.SafeThread.run(SafeThread.java:61)Caused by: java.net.ConnectException: Connection refused   
at java.net.PlainSocketImpl.socketConnect(Native Method)     
at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339)
at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200)       
at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:182)   
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)       
at java.net.Socket.connect(Socket.java:579)     
at java.net.Socket.connect(Socket.java:528)     
at java.net.Socket.<init>(Socket.java:425) 
at java.net.Socket.<init>(Socket.java:280)       
at org.apache.commons.httpclient.protocol.DefaultProtocolSocketFactory.createSocket(DefaultProtocolSocketFactory.java:80)   
at org.apache.commons.httpclient.protocol.DefaultProtocolSocketFactory.createSocket(DefaultProtocolSocketFactory.java:122)     
at org.apache.commons.httpclient.HttpConnection.open(HttpConnection.java:707)       
at org.apache.commons.httpclient.HttpMethodDirector.executeWithRetry(HttpMethodDirector.java:387)   
at org.apache.commons.httpclient.HttpMethodDirector.executeMethod(HttpMethodDirector.java:171) 
at org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:397)       
at org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:323) 
at com.cognos.pogo.http.ServerConnection.executeMethodSynchronously(ServerConnection.java:825)       
at com.cognos.pogo.http.ServerConnection.executeMethod(ServerConnection.java:777)       ... 5 more



If anyone have any idea, please guide me on this.

Thanks,
Prashant
Title: Re: Query Studio not working on cognos BI 10.2.2
Post by: pkunjir on 05 Feb 2015 09:20:02 AM
This issue lies in linux library files. BIBusTKServerConnectionFactory need 32 bit linux libraries as well. Have installed that and all errors wiped off. Now all the things are working fine.

Thanks,
Prashant