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

Query Studio not working on cognos BI 10.2.2

Started by pkunjir, 07 Jan 2015 03:50:57 AM

Previous topic - Next topic

pkunjir

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

pkunjir

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