Welcome to the new CogKnowHow.com!


If you have trouble logging in, reset your password via the login window
by clicking the 'Forgot Password' link.

DPR-ERR-2087 The request has exceeded the execution time limit


#1

Symptom
During the execution of some reports the following error occurs:
DPR-ERR-2087 The request has exceeded the execution time limit

Cause
The timeout threshold was set to a lower value than before

Solution
Assuming the report in question does not have more fundamental issues that prevent it from executing properly, the timeout setting can be changed on the Server Administration page within Cognos Connection.
Steps:

  1. Navigate to the properties of the dispatcher
  2. On the Settings tab, set “Maximum execution time for the report service (seconds)” to an higher length of time (0 = unlimited time)
    If the errors occurs regardless of the timeout settings used, examine both the report and the base model in case there are any issues due to table joins generated, etc.