ERROR Report processing has been canceled by the user

Advanced reports are generated slowly Cannot read the next data row for the Dataset DS The remote server returned the error: (500) Internal Server Error. Report processing has been canceled by the user.
Email It to Me Print this Page
Symptoms
Advanced reports for wide date are generated slowly and in the end they are giving one of these errors: 
Cannot read the next data row for the Dataset DS.
The remote server returned the error: (500) Internal Server Error.
Report processing has been canceled by the user.
 
Cause Too much audit data in the report.
Resolution
To solve the issue, perform the following steps:
  1. Restart the "SQL Server (Instance name)" windows service.
  2. Decrease the Event Log Manager database size by excluding unnecessary types of events from being imported into the database (use the audit archive filters).
  3. Disable the report generating timeout by following these steps:
Open the ReportManager URL and click Site Settings link in the top-right corner. 
In the left hand panel, click the General tab. 
Specify the following settings:
  • Limit the copies of report history: 5 
  • Do not timeout report
Click Apply to save changes.
Was this information helpful?