locked
Blank page when opening SSRS report from CRM RRS feed

  • Question

  • Hi,

    when I run reports from the CRM interface most of the times I get a blank page. To see the report I have to repeat the process until the report is finally rendered.

    That doesn't log any error on the SSRS server, as I think request never got that far, I've seen in the Network requests that when this fails, there are two 404 errors:

    https://OrgName.domain.com/WebResource.axd?d=8kbvfGkAnOEWT71A1j9HEXpdvTzXZ1vCOt1wQ4s9VLwuGImgrUkEM7XjBLC68W3kqqXNrIbvqpbxAknGvAaDcbFw5Wo6xZHAtiv04vVZsiM1&t=635589435571259667
    
    https://OrgName.domain.com/ScriptResource.axd?d=_ESMrSAjQWJygkWpK7UspjV8Asi2YXqM1PutDxxhCS_SQRtQ0yYGzA7DWmO4ljyTTswyPlwEIb_yLAz79kCDln9oqRSUF-okaauzpV8zzVdVQ_LRIkWqSdI2EE1S5CLWWNO8cpLajDFXHwmh8bNQ8MTNk45s6895ReJZZ_-GRxM1&t=ffffffff805766b3

    On the Console tab I have some errors:

    SCRIPT5007: Unable to get property 'PageRequestManager' of undefined or null reference
    File: QuirksReportViewer.aspx, Line: 103, Column: 1
    File: QuirksReportViewer.aspx, Line: 373, Column: 1

    All these errors only show when SSRS report doesn't render.

    I have read that were many issues with IE8 in the past, but this is ha penning to me in IE11, Chrome and Firefox.

    Is there any browser configuration that I'm missing?


    Tuesday, June 28, 2016 8:28 AM

All replies

  • You might have issues due the maximum number of concurrent connections to the hostname, which was more heavily restricted in early IE versions, but shouldn't be an issue with the browsers you state - see http://www.browserscope.org/?category=network

    Can you identify how quickly the 404 errors occur ? If they're immediate, then they are getting to a server, which is then not able to process them, but if it takes a few seconds, then that indicates a network issue

    Do you have just the one SSRS server, or is there any load-balancing involved ?


    Microsoft CRM MVP - http://mscrmuk.blogspot.com/ http://www.excitation.co.uk

    Tuesday, June 28, 2016 11:15 AM
    Moderator
  • Hi, thanks for your reply, it has been helpful.

    404 errors are not immediate, but I would say request are not hitting the server, these images are a request summary:

    I do have load-balancing involved but in the SQL servers, I have double checked all data sources in SSRS server and all point to the SQL cloud service so requests should be redirected to the active SQL node.

    I also update the configdb registry entry in SSRS server to point to this SQL cloud service.

    Tuesday, June 28, 2016 11:30 AM