Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
CRM 2011: SSRS report is throwing "Report cannot be displayed. ()" some times RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi, 

    We have SSRS reporting in CRM 2011 on premise and some times the report is throwing the error as shown below. From the logs of reporting service, there is no error seen. Do I need to set any config to get all the logs? Thanks!

    "library!ReportServer_0-1!371c!04/22/2014-09:07:29:: i INFO: RenderForNewSession('/MY_MSCRM/Reports/{800BC102-E0B7-E211-8277-00155D590C11}')
    webserver!ReportServer_0-1!371c!04/22/2014-09:08:31:: i INFO: Processed report. Report='/MY_MSCRM/Reports/{800BC102-E0B7-E211-8277-00155D590C11}', Stream=

    Tuesday, April 22, 2014 4:14 PM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    Check the following url to enable the CRM log and gather server trace once you are able to reproduce the issue:

    http://support.microsoft.com/kb/907490/en-us

    The log file will located under:

    SystemDrive:\Program Files\Microsoft Dynamics CRM\Trace


    Wilson

    Thursday, May 8, 2014 6:03 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Thanks Wilson for the response. I will try enabling the CRM log.

    Raghunath

    Sunday, May 11, 2014 8:45 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    From this message it looks like there is an issue with this specific report rather than a general issue - does this happen for any out of the box or Wizard Generated reports - or is it only the custom reports. It could be that there is a function in the Report that is throwing an error for specific parameters (dates sometimes cause problems due to string conversions). You may need to run a trace on SQL Server to find out what is happening.

    Hope this helps,

    Scott

    Scott Durow
    Blog www.develop1.net    Follow Me
    Rockstar365
    If this post answers your question, please click "Mark As Answer" on the post and "Mark as Helpful"

    Sunday, May 11, 2014 9:29 AM
    Answerer
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Scott,

    I noticed that the error is happening when the report time is crossing ~60 sec. This error is with Custom reports. In my case SSRS is hosted on separate servers. How does the communication happens between CRM UI to the reporting servers and any parameters controls the timeout?

    Raghunath

    Sunday, May 11, 2014 11:04 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    The custom report has three filters, Start time, End time and Third Filter (~50 options and multiple select capability). I tried keeping the Start time and End Time constant and varied the Third Option. Below are the observations,

    1) When all the Options are selected in the Third Filter, the above error is occurring after ~60 sec

    2) When I select few options in the third filter (~10) each time the report gave the results.

    3) Every time I queried with few options in the third filter the result showed up < 60 sec.

    Thanks, Raghunath

    Sunday, May 11, 2014 11:36 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    I further checked for the events on CRM UI server and noticed the following event whenever report is throwing the error. Surprisingly, the event is indicating "Unauthorized". If it is unauthorized the report should not show for any filters but as mentioned in the above post when the Third filter options are kept less the report is getting generated.

    Report render failure. Error: The remote server returned an error: (401) Unauthorized.

    <Event
    xmlns    ="http://schemas.microsoft.com/win/2004/08/events/event">
    - <System>
    <Provider Name="MSCRMReporting"
    />
    <EventID
    Qualifiers    ="49152">19970</EventID>
    <Level>2</Level>
    <Task>0</Task>
    <Keywords>0x80000000000000</Keywords>
    <TimeCreated SystemTime="2014-05-11T11:45:33.000000000Z" />
    <EventRecordID>95451</EventRecordID>
    <Channel>Application</Channel>
    <Computer>machine</Computer>
    <Security />
    </System>
    - <EventData>
    <Data>The remote server returned an error: (401) Unauthorized.</Data>
    <Data>w3wp</Data>
    <Data>C:\Microsoft Dynamics CRM\CRM\</Data>
    </EventData>
    </Event>

    Thanks, Raghunath

    Sunday, May 11, 2014 12:14 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Wilson,

    I enabled trace and the following error is noticed. But unauthorized here seems to be misleading as the same report is getting fetched when given filters which can return data before 60 sec.

    >Crm Exception: Message: An error occurred during report rendering., ErrorCode: -2147187924, InnerException: Microsoft.Reporting.WebForms.ReportServerException: The remote server returned an error: (401) Unauthorized. ---> System.Net.WebException: The remote server returned an error: (401) Unauthorized.
       at System.Net.HttpWebRequest.EndGetResponse(IAsyncResult asyncResult)
       at Microsoft.Reporting.WebForms.ServerReport.ServerUrlRequest(Boolean isAbortable, String url, Stream outputStream, String& mimeType, String& fileNameExtension)
       --- 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)
    [2014-05-11 06:34:17.092] Process: w3wp |Organization:10da4185-ef43-4602-a0f2-eb8c8aa44411 |Thread:   39 |Category: Application |User: 00000000-0000-0000-0000-000000000000 |Level: Error |ReqId: c5372407-453b-463d-b0a6-77df82d213cc | ErrorInformation.LogError  ilOffset = 0x17

    >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: https://*********/CRMReports/rsviewer/reportviewer.aspx

    Stack Trace Info: [WebException: The remote server returned an error: (401) Unauthorized.]
       at System.Net.HttpWebRequest.EndGetResponse(IAsyncResult asyncResult)
       at Microsoft.Reporting.WebForms.ServerReport.ServerUrlRequest(Boolean isAbortable, String url, Stream outputStream, String& mimeType, String& fileNameExtension)

    [ReportServerException: The remote server returned an error: (401) Unauthorized.]
       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)

    [CrmException: An error occurred during report rendering.]
       at Microsoft.Crm.Web.Reporting.SrsReportViewer.ReportErrorHandler(Object sender, ReportErrorEventArgs e)
       at Microsoft.Reporting.WebForms.ReportViewer.OnError(Exception e)
       at Microsoft.Reporting.WebForms.ReportViewer.OnPreRender(EventArgs e)
       at System.Web.UI.Control.PreRenderRecursiveInternal()
       at System.Web.UI.Control.PreRenderRecursiveInternal()
       at System.Web.UI.Control.PreRenderRecursiveInternal()
       at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

    [HttpUnhandledException: Exception of type 'System.Web.HttpUnhandledException' was thrown.]
       at System.Web.UI.Page.HandleError(Exception e)
       at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
       at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
       at System.Web.UI.Page.ProcessRequest()
       at System.Web.UI.Page.ProcessRequest(HttpContext context)
       at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
       at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)


    [2014-05-11 06:34:17.123] Process: w3wp |Organization:00000000-0000-0000-0000-000000000000 |Thread:   39 |Category: Platform |User: 00000000-0000-0000-0000-000000000000 |Level: Error |ReqId: c5372407-453b-463d-b0a6-77df82d213cc | ExceptionConverter.ConvertToFault  ilOffset = 0x57
    >UNEXPECTED: no fault?
    [2014-05-11 06:34:17.139] Process: w3wp |Organization:00000000-0000-0000-0000-000000000000 |Thread:   39 |Category: Platform |User: 00000000-0000-0000-0000-000000000000 |Level: Error |ReqId: c5372407-453b-463d-b0a6-77df82d213cc | ExceptionConverter.ConvertMessageAndErrorCode  ilOffset = 0x23B
    >System.Web.HttpUnhandledException: Microsoft Dynamics CRM has experienced an error. Reference number for administrators or support: #26EB5B8A: System.Web.HttpUnhandledException (0x80004005): Exception of type 'System.Web.HttpUnhandledException' was thrown. ---> Microsoft.Crm.CrmException: An error occurred during report rendering. ---> Microsoft.Reporting.WebForms.ReportServerException: The remote server returned an error: (401) Unauthorized. ---> System.Net.WebException: The remote server returned an error: (401) Unauthorized.
    >   at System

    Thanks, Raghunath

    Sunday, May 11, 2014 1:54 PM
  • Question
    Sign in to vote
    1
    Sign in to vote

    In that case, please check if you have the spn set right:

    setspn -A http/crmservername domainname\crmservice account
    setspn -A http/crmservername.fqdn.com domainname\crmservice account

    setspn -A http/reportservername.domainname\reportingservice account
    setspn -A http/reportservername.fqdn.com domainname\reporting account

    Also make sure there are duplicated

    Wilson

    Friday, May 16, 2014 6:17 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Wilson,

    I got the following result by running "setspn -L reportingserver"

            WSMAN/reportingserver.domain
            TERMSRV/reportingserver.domain
            RestrictedKrbHost/reportingserver.domain
            HOST/reportingserver.domain
            WSMAN/reportingserver
            TERMSRV/reportingserver
            RestrictedKrbHost/reportingserver
            HOST/reportingserver

    Raghunath


    Monday, May 26, 2014 11:59 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Wilson,

    I realised that I checked wrongly with the servername instead of the service account.

    Now I checked the following, 

    L domain\crmserviceaccount" and noticed it has

    HTTP/crmservername but it don't have http/crmservername.fqdn.com

    Now I am trying to set

    setspn -A http/crmservername.fqdn.com domainname\crmservice account

    However encountering the following error,

    "Failed to assign SPN on account 'CN=_crmserviceaccount,OU=ServiceAccounts,DC=domain,DC=xxx', error 0x2098/8344 -> Insufficient access rights to perform the operation."

    Any idea on this? Thanks!

    Raghunath

    Saturday, May 31, 2014 8:21 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    That means you don't have right to set SPN, try to use the account with more privilege like domain admin account.

    Wilson

    Thursday, June 12, 2014 7:23 AM