data server connections fails

[londondog]

Hi,

I have a site where they are using cognos 11.1 connecting to a sql server database.

The site used to work ok , but we since then I have encrypted the data in transit on the sql side with an SSL certificate, and upgraded java to version 8, and since then the data server connection doesn't connect anymore,
the error is

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
[wrapped_lb_forwarder] com.cognos.pogo.auth.NewAuthHandler
[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

I'm not really sure how to troubleshoot this issue, which logs can I check to see why its failing.

The certificate has been imported into the keystore, and Cognos starts up fine, but I can't run any reports, and the connection always fails.

where am I going wrong?

[MFGF]

Hi,

I have a site where they are using cognos 11.1 connecting to a sql server database.

The site used to work ok , but we since then I have encrypted the data in transit on the sql side with an SSL certificate, and upgraded java to version 8, and since then the data server connection doesn't connect anymore,
the error is

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
[wrapped_lb_forwarder] com.cognos.pogo.auth.NewAuthHandler
[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

I'm not really sure how to troubleshoot this issue, which logs can I check to see why its failing.

The certificate has been imported into the keystore, and Cognos starts up fine, but I can't run any reports, and the connection always fails.

where am I going wrong?

Hi,

I would start with the simple checks first. Did you update the JDBC connection string to use the SSL port rather than the non-SSL port? Does the data server connection test successfully?

I would look in the XQE logs to see what is being written into there. It might give you a better steer on what is causing the issue.

Cheers!

MF.

[londondog]

I would start with the simple checks first. Did you update the JDBC connection string to use the SSL port rather than the non-SSL port?

I thought this should still be port 1433 to connect to sql ? Is that correct?

Does the data server connection test successfully?

no it fails

I would look in the XQE logs to see what is being written into there. It might give you a better steer on what is causing the issue.

I googled how to turn on xqe logs but I couldn't find it. How do I do it?

thanks again for the help

[MFGF]

I would start with the simple checks first. Did you update the JDBC connection string to use the SSL port rather than the non-SSL port?

I thought this should still be port 1433 to connect to sql ? Is that correct?

Does the data server connection test successfully?

no it fails

I would look in the XQE logs to see what is being written into there. It might give you a better steer on what is causing the issue.

I googled how to turn on xqe logs but I couldn't find it. How do I do it?

thanks again for the help

Hi,

Cognos writes some details to the XQE logs by default. Unless this setting has been altered, they should be there in the logs folder? If you need more details in them, the instructions for enabling more detailed logging are here:

https://www.ibm.com/support/pages/enabling-xqe-diagnostic-logging-info-cognos-analytics

Cheers!

MF.

[londondog]

I was tearing my hair out with this.I ended up uninstalling everything, and went back to a clean database as well.

It worked as it should.

I restored the non working db, restarted everything, and it failed again.

I restored the clean db and it worked first time, so somewhere so how, the db was corrupted.

I have no idea what might have caused this but its resolved.

Thanks for helping along the way