I have a standard report that runs every quarter that extracts data from the SQL Server and drops it into a Word document.
This should run automatically for each of our clients at the end of every quarter. This time around the reports haven’t run.
I’ve manually tried to run these reports (we have a link on our Intranet site) and when I do I get an error message, see below.
I thought it might be worth trying running the reports directly off the server (rather than locally) and I get this error:
"An error has occurred during report processing. (rsProcessingAborted)
Cannot read the next data row for the dataset MovementsSummary. (rsErrorReadingNextDataRow)
Error: 802, Severity: 17, State: 20. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped."
The server has been re-booted and all services re-stared successfully.
I am ansure what might of changed, looking onling I see that it might be memory related. The running specifications are:
Running on Hyper -V
6GB Ram dynamically upto 10GB
No drive space issues
The error logs show nothing regarding this, could anyone point me in the right dirtection in troubleshooting this, SQL is not my stong point :-(