IBM Support

DPR-ERR-2002 when user runs a report from a DQM package

Troubleshooting


Problem

After successfully publishing a package using Dynamic Query Mode in Framework Manager, running a report from the package fails and throws the following: DPR-ERR-2002 Unable to execute the request because there were no connections to the process available within the configured time limit. When checking the Data source connections in Cognos Administration, the user can see that the JDBC connection is successful, however, the package is using a default Compatible Mode connection that was not created by the user. When tested, this connection fails. The package properties show it was published to allow Dynamic Query Mode.

Symptom

When running a report in Cognos 11.0.3, the user gets the following error message:

DPR-ERR-2002 Unable to execute the request because there were no connections to the process available within the configured time limit.


The detailed error message prompted to the user is:

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

com.ibm.bi.soap.services.SoapException: {

"severity": "error",

"faultcode": "Server",

"faultstring": "The server did something wrong",

"errorCode": "NO_PROCESS",

"messages": [

"DPR-ERR-2002 Unable to execute the request because there were no connections to the process available within the configured time limit."

[{"Product":{"code":"SSTSF6","label":"IBM Cognos Analytics"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Administration and Configuration v11x","Platform":[{"code":"PF016","label":"Linux"}],"Version":"11.0","Edition":"All Editions","Line of Business":{"code":"LOB76","label":"Data Platform"}},{"Product":{"code":"SS6G84","label":"IBM Cognos Analytics on Cloud"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}},{"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB77","label":"Automation Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
13 January 2026

UID

swg21992965

Page Feedback