DPR-ERR-2002 Unable to execute the request because there were no connections to the process available

by ·Comments Off on DPR-ERR-2002 Unable to execute the request because there were no connections to the process available

Product:
Cognos Analytics 11.0.13
Microsoft Windows 2016 server

Problem:
When test the data source connection in cognos connection administrative page, you get a error for the JDBC Dynamic connection. The Compatible Query Mode is working. Happens on server with not default temp and data folder.

Error:
Oracle (JDBC) /Dynamic Failed DPR-ERR-2002 Unable to execute the request because there were no connections to the process available within the configured time limit.

Suggested Solution:
Go into Cognos Configuration.
Stop the Cognos service.
Change temp and data locations back to default values.
Save and start the Cognos Service.
Surf into IBMCOGNOS again and test the data sources.

Can be that corrupted files in the temp and data folder does not make the Query/Report service to start correct.

More information:
https://www-01.ibm.com//support/docview.wss?uid=swg1PH15577
https://www.ibm.com/support/pages/dpr-err-2002-unable-execute-request-because-there-were-no-connections-process-available-within-configured-timeout