System.InvalidOperationException in SRS 2000

[dldev]

Hello,

I have a financial report which takes quite a while to run, approximately 30 minutes. It is a data intensive report pulling in many years worth of data which I have converted from an RPT to RDL. The RPT takes a long time as well but eventually renders the report and has been in production for quite some time. To the point. When I run the SRS report with the same parameters (beginning of one fiscal year to the end of another), the report processes for some time, maybe about 15, 20 minutes then returns this error:

The Group expression used in grouping ‘TableGrouping0’ references a data set field which contains an error: System.InvalidOperationException: Invalid attempt to MetaData when reader is closed. at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlDataReader.GetValue(Int32 i) at Microsoft.ReportingServices.DataExtensions.DataReaderWrapper.GetValue(Int32 fieldIndex) at Microsoft.ReportingServices.DataExtensions.MappingDataReader.GetFieldValue(Int32 aliasIndex)

I've Googled this and gone through many SQL and SSRS resources to nail this down but still am unable to find a definitive answer. Has anyone experienced this or know what is causing this?

Thanks in advance,
DL

 

[philhege]

What's the query time? Have you optimized everything you can? Is the data in a warehouse or a normal SQL store?

30 minutes is a long time for an online, on-demand process. I'd start with a query analysis and go from there.

Phil Hegedusich
Senior Programmer/Analyst
IIMAK

http://www.iimak.com

-----------
Pity the insomniac dyslexic agnostic. He stays up all night, wondering if there really is a dog.