Data Source Connection Error in IBM Cognos BI 10.

[Rakshith K P]

Hi,

I was trying to connect the below listed from the IBM COGNOS 10 through JDBC Drivers

1. Connect LUW system which is having Postgresql,  but I was getting error like
" XQE-JDB-0004 A problem occurred finding the driver class "org.postgresql.Driver" ".

2. Connecting BIGSQL server .I was getting an error  "XQE-ROL-0183 Insufficient memory. The current JVM maximum heap size of the QueryService is 972MB and may need to be increased: Java heap space" , then I increased the heap size to 1536MB(previously it was 1024MB) but then I was facing another issue.

" 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
[queryChainHandler] com.cognos.pogo.handlers.logic.ChainHandler
[queryAsyncHandler] com.cognos.pogo.async.impl.AsyncHandler
[queryServiceHandler] com.cognos.xqebifw.cubingservices.CubingServicesHandler "

then I increased the Queue time limit of report service in Query Services but still I had the same issue. Then I reset the Query Service settings values to default value but I still facing the same issue DPR-ERR-2002.

3. Connecting z/OS DB2, I successfully created the Data Source connection in IBM Administration but in Metadata Wizard - Select Data Source(in IBM Frame Work Manager) step after selecting the created Data source if i gave next option the tool was not responding, so i was not able to create project for the same, I have attached the screen shot for the same.




Kindly help me how to solve this issue and also let me know the jar files to be added for Postgresql.