During the execution of some reports the following error occurs:
DPR-ERR-2087 The request has exceeded the execution time limit
The timeout threshold was set to a lower value than before
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.
- Navigate to the properties of the dispatcher
- 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.