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

db2 as datasource error

Started by danieldaya, 24 Nov 2014 12:53:36 AM

Previous topic - Next topic

danieldaya

Hi,
i'm new on cognos bi.
I have error when create datasource to db2
This my step to create new ds Lunch > IBM Cognos Administration > Configuration > Data Source Connections > New Data Source
On New Data Source wizard
Type : IBM DB2
DB2 database name: DMIS
DB2 connect string: 127.0.0.1:50000
username:xxxxx
pass:xxx

this the connection string : ^User ID:^?Password:;LOCAL;D2;DSN=DMIS;UID=%s;PWD=%s;127.0.0.1:50000@ASYNC=0@0/0@COLSEQ=

this the result after test connection : IBM DB2 / Compatible      Failed      DPR-ERR-2002 Unable to execute the request because there were no connections to the process available within the configured time limit.

DPR-ERR-2002 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
[mdaChainHandler] com.cognos.pogo.handlers.logic.ChainHandler
[asyncMetadataServiceHandler] com.cognos.pogo.async.impl.AsyncHandler
[metadataServiceHandler] com.cognos.metadataService.bibusHandler.MDSRVHandler

on cogserver.log this error log :
127.0.0.1:9300   29135   2014-11-24 13:46:17.509   +7   rsProcessStarter   na      0   metadataServiceHandler-MDSRVProcessManager-ProcessMgrThread   DISP   5000   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:192)   at com.cognos.pogo.reportservice.ReportServerProcess.start(ReportServerProcess.java:129)   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.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)

this is error on pogo_2014_24_11.log
2014-11-24 13:46:17.513 FATAL [m.cognos.pogo.reportservice.ProcessManager] metadataServiceHandler-MDSRVProcessManager-ProcessMgrThread: External Report Server process BmtMDProviderMain cannot be started java.io.IOException: Process BmtMDProviderMain failed to start properly.
   at com.cognos.pogo.reportservice.ReportServerProcess.getProcessOutput(ReportServerProcess.java:192)
   at com.cognos.pogo.reportservice.ReportServerProcess.start(ReportServerProcess.java:129)
   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.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)

any one can solve my problem ?

this is my environment :
IB Cognos Server 10.2.1, DB2 10.5.0 on RHEL 64bit

Thanks

MFGF

Quote from: danieldaya on 24 Nov 2014 12:53:36 AM
Hi,
i'm new on cognos bi.
I have error when create datasource to db2
This my step to create new ds Lunch > IBM Cognos Administration > Configuration > Data Source Connections > New Data Source
On New Data Source wizard
Type : IBM DB2
DB2 database name: DMIS
DB2 connect string: 127.0.0.1:50000
username:xxxxx
pass:xxx

this the connection string : ^User ID:^?Password:;LOCAL;D2;DSN=DMIS;UID=%s;PWD=%s;127.0.0.1:50000@ASYNC=0@0/0@COLSEQ=

this the result after test connection : IBM DB2 / Compatible      Failed      DPR-ERR-2002 Unable to execute the request because there were no connections to the process available within the configured time limit.

DPR-ERR-2002 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
[mdaChainHandler] com.cognos.pogo.handlers.logic.ChainHandler
[asyncMetadataServiceHandler] com.cognos.pogo.async.impl.AsyncHandler
[metadataServiceHandler] com.cognos.metadataService.bibusHandler.MDSRVHandler

on cogserver.log this error log :
127.0.0.1:9300   29135   2014-11-24 13:46:17.509   +7   rsProcessStarter   na      0   metadataServiceHandler-MDSRVProcessManager-ProcessMgrThread   DISP   5000   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:192)   at com.cognos.pogo.reportservice.ReportServerProcess.start(ReportServerProcess.java:129)   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.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)

this is error on pogo_2014_24_11.log
2014-11-24 13:46:17.513 FATAL [m.cognos.pogo.reportservice.ProcessManager] metadataServiceHandler-MDSRVProcessManager-ProcessMgrThread: External Report Server process BmtMDProviderMain cannot be started java.io.IOException: Process BmtMDProviderMain failed to start properly.
   at com.cognos.pogo.reportservice.ReportServerProcess.getProcessOutput(ReportServerProcess.java:192)
   at com.cognos.pogo.reportservice.ReportServerProcess.start(ReportServerProcess.java:129)
   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.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)

any one can solve my problem ?

this is my environment :
IB Cognos Server 10.2.1, DB2 10.5.0 on RHEL 64bit

Thanks

Hi,

Do you have the DB2 native client libraries installed on the server? You need these to be able to connect when setting up a data source connection as you describe here. The alternative is to use the JDBC tab and set up only JDBC access (which restricts you to Dynamic Query Mode) - in which case you will need the Class 4 DB" JDBC for your version of DB2 to be on the Cognos server, plus the relevant license file that goes along with it.

Cheers!

MF.
Meep!