Skip to main content

Reports Generation Takes a While and Completes With Errors

Symptom​

Predefined reports and subscriptions for wide date ranges are generated slowly and complete with one of the errors below:

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 resolve the issue, do one of the following:

  • On your SQL Server host, restart the SQL Server (Instance name) windows service.

  • Follow the recommendations to improve the overall Netwrix Auditor performance. Learn more in Long Data Collection — Improving the Performance.

  • Disable the report generating timeout by following these steps:

    1. Open the ReportManager URL and click the Site Settings link in the top-right corner.
    2. In the left-hand panel, click the General tab.
    3. Set the Limit the copies of report history to 5.
    4. Select the Do not timeout report checkbox.
    5. Click Apply to save changes.

  • Set a limit to SQL server memory consumption. Learn more in Server memory configuration options ⸱ Microsoft 🡥. Consider that the min. and max. SQL memory values are completely dependent on the environment and how many resources you have. For the maximum value, Netwrix recommends do not exceed more than 80% of the total resources for the SQL server. And ideally, SQL Server should be on the different server as Netwrix Auditor itself.