Dynamics Community Forum Thread Details

Hello,

several hours of troubleshooting already for reporting services. Two CRM 2011 UR12 with Claims and Ifd.

Most of the time reports rendering fails with

[ReportServerException: Query execution failed for dataset 'LanguageInfo'. (rsErrorExecutingCommand)]

Could it be that report rendering language cannot be set and therefore report content not displayed at all?

Help much appreciated

Trace when rendrering report:

>MessageProcessor finish processing message 'IsReportingDataConnectorInstalled' for 'none'.

>ExecutionContext not in use (OnEndRequest) for organization {040A871B-6F2E-4010-976F-D72138D2D3E0}

>OrganizationSdkService finished processing request for user:IsReportingDataConnectorInstalled

As user:deb108e5-fb41-439d-b8b0-31a20a3a90d5

Response Xml:

>Post-Platform Request: IsReportingDataConnectorInstalled

at SrsReportViewer.ReportErrorHandler(Object sender, ReportErrorEventArgs e) ilOffset = 0x122

at ReportViewer.OnError(Exception e) ilOffset = 0x22

at ReportViewer.OnPreRender(EventArgs e) ilOffset = 0x2AB

at Control.PreRenderRecursiveInternal() ilOffset = 0x54

at Control.PreRenderRecursiveInternal() ilOffset = 0x8E

at Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) ilOffset = 0x69E

at Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) ilOffset = 0x3C

at Page.ProcessRequest() ilOffset = 0x14

at Page.ProcessRequest(HttpContext context) ilOffset = 0x31

at CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() ilOffset = 0x11D

at HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) ilOffset = 0x15

at ApplicationStepManager.ResumeSteps(Exception error) ilOffset = 0x10E

at HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData) ilOffset = 0x5C

at HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr) ilOffset = 0xFC

at ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType) ilOffset = 0x45

>Crm Exception: Message: An error occurred during report rendering., ErrorCode: -2147187924, InnerException: Microsoft.Reporting.WebForms.ReportServerException: Une erreur s'est produite lors du traitement du rapport. (rsProcessingAborted) ---> Microsoft.Reporting.WebForms.ReportServerException: Query execution failed for dataset 'LanguageInfo'. (rsErrorExecutingCommand) ---> Microsoft.Reporting.WebForms.ReportServerException: Pour obtenir plus d'informations sur cette erreur, accédez au serveur de rapports sur le serveur local ou activez les erreurs distantes.

--- End of inner exception stack trace ---

at Microsoft.Reporting.WebForms.ServerReport.ServerUrlRequest(Boolean isAbortable, String url, Stream outputStream, String& mimeType, String& fileNameExtension)

at Microsoft.Reporting.WebForms.ServerReport.InternalRender(Boolean isAbortable, String format, String deviceInfo, NameValueCollection urlAccessParameters, Stream reportStream, String& mimeType, String& fileNameExtension)

at Microsoft.Reporting.WebForms.ServerReport.Render(String format, String deviceInfo, NameValueCollection urlAccessParameters, String& mimeType, String& fileNameExtension)

at Microsoft.Reporting.WebForms.ServerModeSession.RenderReport(String format, Boolean allowInternalRenderers, String deviceInfo, NameValueCollection additionalParams, Boolean cacheSecondaryStreamsForHtml, String& mimeType, String& fileExtension)

at Microsoft.ReportingServices.Rendering.HtmlRenderer.ViewerRenderer.SPBProcessingStub.GetNextPage(RPLReport& rplReport)

at Microsoft.ReportingServices.Rendering.HtmlRenderer.HTML4Renderer.GetNextPage()

at Microsoft.ReportingServices.Rendering.HtmlRenderer.HTML4Renderer.InitializeReport()

at Microsoft.ReportingServices.Rendering.HtmlRenderer.ViewerRenderer.Render(HtmlTextWriter outputWriter)

at Microsoft.Reporting.WebForms.LocalHtmlRenderer.Render(NameValueCollection deviceInfo, PageCountMode pageCountMode, ReportControlSession reportControlSession, CreateAndRegisterStream streamCallback, String& scrollScript, String& pageStyle)

at Microsoft.Reporting.WebForms.ReportControlSession.RenderReportHTML4(NameValueCollection deviceInfo, PageCountMode pageCountMode, String& scrollScript, String& pageStyle)

at Microsoft.Reporting.WebForms.ReportControl.RenderReport(ReportControlSession session, String viewerInstanceIdentifier, PageCountMode pageCountMode, Int32 pageNumber, InteractivityPostBackMode interactivityMode, SearchState searchState, String replacementRoot, String hyperlinkTarget, ScrollTarget scrollTarget, String alertMessage, DeviceInfoCollection initialDeviceInfos, String browserMode, Boolean sizeToContent)

at Microsoft.Reporting.WebForms.ReportArea.RenderReport(ReportControlSession session, String viewerInstanceIdentifier, PageCountMode pageCountMode, Int32 pageNumber, InteractivityPostBackMode interactivityMode, SearchState searchState, String replacementRoot, String hyperlinkTarget, ScrollTarget scrollTarget, String alertMessage, DeviceInfoCollection initialDeviceInfos, String browserMode, Boolean sizeToContent)

at Microsoft.Reporting.WebForms.ReportViewer.RenderReport(Boolean updateDocMap)

at Microsoft.Reporting.WebForms.ReportViewer.OnPreRender(EventArgs e)

>MSCRM Error Report:

--------------------------------------------------------------------------------------------------------

Error: Exception of type 'System.Web.HttpUnhandledException' was thrown.

Error Number: 0x8004832C

Error Message: An error occurred during report rendering.

Error Details: An error occurred during report rendering.

Source File: Not available

Line Number: Not available

Request URL: http://fla-prep-crm01/PET/CRMReports/rsviewer/reportviewer.aspx

Stack Trace Info: [ReportServerException: Pour obtenir plus d'informations sur cette erreur, accédez au serveur de rapports sur le serveur local ou activez les erreurs distantes.]

[ReportServerException: Query execution failed for dataset 'LanguageInfo'. (rsErrorExecutingCommand)]

[ReportServerException: Une erreur s'est produite lors du traitement du rapport. (rsProcessingAborted)]