Query Execution Failed in Reporting Services reports

Posted by Chris Herring on Server Fault See other posts from Server Fault or by Chris Herring
Published on 2010-04-06T02:28:25Z Indexed on 2012/03/19 10:07 UTC
Read the original article Hit count: 463

I have some reporting services reports that talk to Analysis Services and at times they fail with the following error:

An error occurred during client rendering.
An error has occurred during report processing.
Query execution failed for dataset 'AccountManagerAccountManager'.
The connection cannot be used while an XmlReader object is open. 

This occurs sometimes when I change selections in the filter. It also occurs when the machine has been under heavy load and then will consistently error until SSAS is restarted.

The log file contains the following error:

processing!ReportServer_0-18!738!04/06/2010-11:01:14:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for dataset 'AccountManagerAccountManager'., ; Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for dataset 'AccountManagerAccountManager'. ---> System.InvalidOperationException: The connection cannot be used while an XmlReader object is open.
   at Microsoft.AnalysisServices.AdomdClient.XmlaClient.CheckConnection()
   at Microsoft.AnalysisServices.AdomdClient.XmlaClient.ExecuteStatement(String statement, IDictionary connectionProperties, IDictionary commandProperties, IDataParameterCollection parameters, Boolean isMdx)
   at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.IExecuteProvider.ExecuteTabular(CommandBehavior behavior, ICommandContentProvider contentProvider, AdomdPropertyCollection commandProperties, IDataParameterCollection parameters)
   at Microsoft.AnalysisServices.AdomdClient.AdomdCommand.ExecuteReader(CommandBehavior behavior)
   at Microsoft.AnalysisServices.AdomdClient.AdomdCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
   at Microsoft.ReportingServices.DataExtensions.AdoMdCommand.ExecuteReader(CommandBehavior behavior)
   at Microsoft.ReportingServices.OnDemandProcessing.RuntimeDataSet.RunDataSetQuery()

Can anyone shed light on this issue?

© Server Fault or respective owner

Related posts about reporting-services

Related posts about analysis-services