IBM Support

DPR-ERR-2002 Unable to execute request when attempting to test a data source.

Troubleshooting


Problem

Reports may not execute and attempting to test a data source via the IBM Cognos Administration page will result in a DPR-ERR-2002 error.

Symptom

  • When attempting to test a data source, the following error occurs:
      • DPR-ERR-2002 Unable to execute request because no connection available in time limit.

  • Reports may fail to execute.
  • An error similar to the following is found in the cogserver.log:

      • DPR-ERR-2084 Received request from dispatcher with GUID=2. I cannot resolve that dispatcher's GUID. This likely means we are running against different content stores, and I am registered in both. There may be an old/incorrect registration for me in the other content store

    The GUI is a unique id given to a dispatcher, it is not a value that an Administrator would typically know.

    • Checking the status url of the expected Primary Content Manager shows it as StandBy and not Running

      The status URL is
      http://machine.domain.com:9300/p2pd/servlet
    • Where machine.domain.com:9300 is the Content Manager machine and the port which the Content Manager runs on.

    [{"Product":{"code":"SSEP7J","label":"Cognos Business Intelligence"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Cognos Connection","Platform":[{"code":"PF033","label":"Windows"},{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"}],"Version":"8.4.1;8.4;8.3;10.1","Edition":"","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"}}]

    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:
    08 May 2025

    UID

    swg21595001