locked
Query execution failed for dataset 'PlannedSupervisionActivities'. ---> System.Exception: For more information about this error navigate to the report server on the local server machine, or enable remote errors RRS feed

  • Question

  • Hi, I have an SSRS report deployed to CRM 2011. I also have a workflow which programatically renders the report and loads it into a given sharepoint url. Whenever i run the report from front end it just runs fine. But from workflow, its throwing the error Query execution failed for dataset 'PlannedSupervisionActivities'. That data set related data is displaying properly when the report is run from front end manually. The details of the error is as below.

    Error Message:

    Unhandled Exception: Microsoft.Xrm.Sdk.InvalidPluginExecutionException: An error has occurred in the HP.APRA.CRM.Workflows.Sharepoint.UploadDocument Workflow of Share point. Please download the error trace and contact the system administrator. Message: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for dataset 'PlannedSupervisionActivities'. ---> System.Exception: For more information about this error navigate to the report server on the local server machine, or enable remote errors
       at HP.APRA.CRM.Workflows.SharepointIntegration.Handler.ThrowException(Exception exception, ITracingService trace, String workflowName)
       at HP.APRA.CRM.Workflows.SharepointIntegration.UploadDocumentHandler.UploadReportToSharepoint(Entity imageEntity, OutArgument isUploadedToSharepoint, String organisationName)
       at HP.APRA.CRM.Workflows.SharepointIntegration.UploadDocument.Execute(CodeActivityContext executionContext)
       at System.Activities.CodeActivity.InternalExecute(ActivityInstance instance, ActivityExecutor executor, BookmarkManager bookmarkManager)
       at System.Activities.Runtime.ActivityExecutor.ExecuteActivityWorkItem.ExecuteBody(ActivityExecutor executor, BookmarkManager bookmarkManager, Location resultLocation)
    Inner Exception: System.Web.Services.Protocols.SoapException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for dataset 'PlannedSupervisionActivities'. ---> System.Exception: For more information about this error navigate to the report server on the local server machine, or enable remote errorsDetail: 
    <detail><ErrorCode xmlns="http://www.microsoft.com/sql/reportingservices">rsProcessingAborted</ErrorCode><HttpStatus xmlns="http://www.microsoft.com/sql/reportingservices">400</HttpStatus><Message xmlns="http://www.microsoft.com/sql/reportingservices">An error has occurred during report processing.</Message><HelpLink xmlns="http://www.microsoft.com/sql/reportingservices">http://go.microsoft.com/fwlink/?LinkId=20476&amp;EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&amp;EvtID=rsProcessingAborted&amp;ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&amp;ProdVer=11.0.2100.60</HelpLink><ProductName xmlns="http://www.microsoft.com/sql/reportingservices">Microsoft SQL Server Reporting Services</ProductName><ProductVersion xmlns="http://www.microsoft.com/sql/reportingservices">11.0.2100.60</ProductVersion><ProductLocaleId xmlns="http://www.microsoft.com/sql/reportingservices">1033</ProductLocaleId><OperatingSystem xmlns="http://www.microsoft.com/sql/reportingservices">OsIndependent</OperatingSystem><CountryLocaleId xmlns="http://www.microsoft.com/sql/reportingservices">1033</CountryLocaleId><MoreInformation xmlns="http://www.microsoft.com/sql/reportingservices"><Source>Microsoft.ReportingServices.ProcessingCore</Source><Message msrs:ErrorCode="rsProcessingAborted" msrs:HelpLink="http://go.microsoft.com/fwlink/?LinkId=20476&amp;EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&amp;EvtID=rsProcessingAborted&amp;ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&amp;ProdVer=11.0.2100.60" xmlns:msrs="http://www.microsoft.com/sql/reportingservices">An error has occurred during report processing.</Message><MoreInformation><Source>Microsoft.ReportingServices.ProcessingCore</Source><Message msrs:ErrorCode="rsErrorExecutingCommand" msrs:HelpLink="http://go.microsoft.com/fwlink/?LinkId=20476&amp;EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&amp;EvtID=rsErrorExecutingCommand&amp;ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&amp;ProdVer=11.0.2100.60" xmlns:msrs="http://www.microsoft.com/sql/reportingservices">Query execution failed for dataset 'PlannedSupervisionActivities'.</Message><MoreInformation><Source></Source><Message>For more information about this error navigate to the report server on the local server machine, or enable remote errors</Message></MoreInformation></MoreInformation></MoreInformation><Warnings xmlns="http://www.microsoft.com/sql/reportingservices" /></detail>
       at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
       at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
       at HP.APRA.CRM.Workflows.SharepointIntegration.ReportExecutionService.ReportExecutionService.Render(String Format, String DeviceInfo, String& Extension, String& MimeType, String& Encoding, Warning[]& Warnings, String[]& StreamIds)
       at HP.APRA.CRM.Workflows.SharepointIntegration.UploadDocumentHandler.RenderReport(Guid contextId, String parameterName, String reportPath, ITracingService trace)
       at HP.APRA.CRM.Workflows.SharepointIntegration.UploadDocumentHandler.RenderAndUpload(String overallAssessment, EntityDocType typeOfDocumet, Guid entityGuid, EntityCollection orgsCollection, String reportParameterName, String reportPath, String entityName, String recordName, String& errorMessage)
       at HP.APRA.CRM.Workflows.SharepointIntegration.UploadDocumentHandler.UploadReportToSharepoint(Entity imageEntity, OutArgument isUploadedToSharepoint, String organisationName)

    Any help will be greatly appreciated.

    Thank you.

    Thank you.


    Thursday, August 22, 2013 6:42 AM

All replies

  • Which user account is the CRM Application Service running under? Also, which user account is the CrmAppPool running under in IIS? Once you identify these, please ensure that the user account has the correct SPNs configured for the server where CRM is installed.

    Thursday, August 22, 2013 7:34 AM