Reports from SQL server not running, Cannot read Error: 802, Severity: 17, State: 20. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notificatio

Hi
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:

W2008 R2
SQL R2
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 :-(

Regards



 
 
 

mercuriousu2Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

David ToddSenior Database AdministratorCommented:
Hi,

This suggests, all other things being equal, that there is a problem with some of the data on the database.

Given the number of layers between your report and the data in SQL, I'd run SQL profiler to try and grab the actual sql that is being executed. Then follow that lead - ie execute the sql in SSMS.

For time it might pay to hire a SQL professional ... How much leeway can you get on delivery of these reports?

HTH
  David
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Ashok KumarCommented:
- Do systematic debugging.

1. Separate the queries contained in the reports, and run them one by one through Sql Query analyzer.
      - You can eliminate, performance errors, memory errors, or column name changes, or if there exist
          smaller data length in transactions tables

2. if there exist no error in step 1, run the report in reports designer,

3. if it still works, Remove exporting of data to word, instead set-up reports for pdf Subscription / Excel subscription, and run the report. eventually you if there exist any problem with data you will find it on excel sheet export.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Exchange

From novice to tech pro — start learning today.