Not able to download cognos out of the box reports.

[talk1234]

We are using cognos 10.1 on linux environment. We have already imported order management system out of the box 
reports into cognos. We recieve following error while downloading reports.                                                               
                                                                       
===============================                                         
Error Title:                                                           
DPR-ERR-2002 Unable to execute the request because there were no       
connections to the process available within the configured time limit. 
                                                                       
Error Details:                                                         
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             
===============================                                         
                                                                       
Here are some excerpts from the logs:                                   
                                                                       
cogserver.log                                                           
==================                                                     
9.113.209.166:49605269232013-03-29 18:52:41.831+05:30-549337392
BITSrv62351Audit.RTUsage.BITSrvFailureCCL-SRV-0513 The         
BIBusTKServer process ran out of memory.<Messages><Message Name="     
CCLMessage" File="cclbitmsgs" Severity="Error" Nesting="0"             
><MessageText>CCL-SRV-0513 The BIBusTKServer process ran out of memory.
</MessageText></Message><Message Name="CCLMessageString" File=""       
Severity="Error" Nesting="0"                                           
><MessageText>CCLOutOfMemoryError</MessageText></Message><Message Name="
CCLMessageString" File="" Severity="Error" Nesting="0"                 
><MessageText></MessageText></Message></Messages>                       
==================                                                     
                                                                       
pogo logs                                                               
                                                                       
==================                                                     
2013-03-29 18:52:41.171 FATAL [m.cognos.pogo.reportservice.             
ProcessManager] warpmta-ProcessManager-ProcessMgrThread: External       
Report Server process BIBusTKServerMain cannot be started java.io.     
IOException: Failed to send HTTP request or read HTTP response         
at java.lang.Throwable.<init>(Throwable.java:67)                       
at com.cognos.pogo.http.ServerConnection.executeMethod                 
(ServerConnection.java:760)                                             
at com.cognos.pogo.http.ServerConnection.sendRequest(ServerConnection.
java:208)                                                               
at com.cognos.pogo.reportservice.ProcessFacade.sendXML(ProcessFacade. 
java:316)                                                               
at com.cognos.pogo.reportservice.ProcessFacade.configureProcess       
(ProcessFacade.java:290)                                               
at com.cognos.pogo.reportservice.ProcessFacade.<init>(ProcessFacade.   
java:124)                                                               
at com.cognos.pogo.reportservice.RSComponentFactory.newProcessFacade   
(RSComponentFactory.java:67)                                           
at com.cognos.pogo.reportservice.ProcessManager.createProcessFacade   
(ProcessManager.java:514)                                               
at com.cognos.pogo.reportservice.ProcessManager.startProcess           
(ProcessManager.java:490)                                               
at com.cognos.pogo.reportservice.ProcessManager.                       
startProcessesDueToCapacity(ProcessManager.java:385)                   
at com.cognos.pogo.reportservice.ProcessManager.safeRun(ProcessManager.
java:343)                                                               
at com.cognos.pogo.util.threads.SafeThread.run(SafeThread.java:61)     
==================                                                     
                                                                       
Could you please help us identifying root cause behind this error. Any help would be appreciated.

Regards,

[blom0344]

'out of memory' seems to be the repeating part of the message. Not sure whether you have a working Cognos environment. What does work?

[talk1234]

Currently we only need to get the report downloaded from the cognos environment. We can see the cognons application invoking fine using http://<IP>:8080/ibmcognos URL. and we can see the configuration screen where we can create data connections, We can also import reports successfully into cognos environment. but we have not really looked at other part of application.

Moreover, we have also noticed data connection test failing in cognos. we use websphere as application server and db2 as a database.
Regards,
Parivesh

[talk1234]

We did following as a troubleshooting measures but the issue is not yet resolved.

A) set LD_LIBRARY_PATH variable to the path of cognos bin directory.
B) report execution changed from 64 bit to 32 bit.
C) Temp system storage buffer pool and table spaces were added.
D)sscap namespace added.
E) Created data connections so that Cognos can connect to the order managment system db. However these data connection tests are failing with similar errors (Unable to execute the request because there were no       
connections to the process available within the configured time limit.
F) Enabled GC in application server.
G) Heap size increased in application server.

[blom0344]

You mention reports, Cognos connection , application etc.  I do not know what reports you are using, but each report will need a package to run against. Are packages present?  Did you publish any packages from a Cognos model?  How did you define datasource connections to the DB2 database?