Avatar of Shen
Flag for United States of America asked on

Sql Server 2008 r2 Reports

We are running a report that is generating the following error:

An error has occurred during report processing(rsProcessingaborted) . can not read the next data row for the dataset (dataset name) (rserrorreadingnextdataflow)

If we run this report with less records selection (1 month instead 4 month) the report runs, but  when we run it for longer -4 month) it generate the error above.

Alos when we ran it from the actual report server:
we got error:

an error ocurred within the report server database. this may be due to a connection failure, timeout, or low disk condition within the database (rsreportserverdatabaseerror)
Microsoft SQL Server

Avatar of undefined
Last Comment
Anthony Perkins

8/22/2022 - Mon
Anthony Perkins

Sounds like it is time to roll up your sleeves and optimize the query.  If you are unsure of how to do that, post the query here and there should be a lot of help forthcoming.

This is the problem. i am not too familiar with reports. These reports were created by the vendor. I see the .rdl file for the report(file  attached) . The query has a lot of parameters and is very long.

Is it possible to setup a trace, run the report through report server (http://localhost/reports) and get the query with the parameters. I tried but i can't see it in the trace.
Anthony Perkins

View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck