January 4, 2016 at 10:26 am
When accessing deployed SSRS reports via URL link using AD authenticated username/password, reports do not complete their rendering. The parameter bar displays with appropriate values and the Loading wheel displays until an error is thrown.
About 75% of the time the error shown is:
Sys.WebForms.PageRequestManagerServerErrorException: An unknown error has occurred while processing the request on the server. The status code returned from the server was: 500
The rest of the time the status code returned is: 0
As an added curveball, when connected to internal Wifi the reports render accurately and quickly in Safari on Apple devices.
Reports render correctly in IE, Firefox and Chrome. Using Chrome on any Apple device has been shown to work in all tests so far. Unfortunately using any other browser than Safari is not possible in production.
Additional information
Server does receive a successful login in Event Viewer but nothing gets to the Reporting Services ExecutionLog stored procedures.
The rendering times out at around 120 seconds. A timeout issue could be involved but I can not currently find the appropriate setting to change and even if this is the fault, waiting over 2 minutes to reports this small is inappropriate.
Environment
- SQL Server Reporting Services 2014
- Accessing data from SQL Server 2000
- Issue occurs in Safari browser on Mac, iPhone, iPad for iOS 9.1 and 9.2 (other OSs not tested)
- When working reports show a variety of data from multiple databases on a single SQL server. They access several stored procedures to display parameter dropdowns and general report data organised in tables and graphs with images
Resolves trialled (and failed 🙂
- Creating non database linked report with picture and one line of text (still did not render)
- Changing ReportingServices and ReportManager web config file to increase httpRuntime executionTimeout and maxRequestLength values (still did not render)
- Changing to Basic authentication (stopped any connection to any aspect of report manager etc)
- Changes to javascript file (still did not render)
I have scanned the internet and on Stack Overflow to little avail. I may have missed something or interpreted it incorrectly so any assistance, suggestions and help would be most appreciated.
January 6, 2016 at 11:16 pm
Since no one else has responded, I've had a similar rendering problem where the reports displayed the parameter header area but blank report:
You need to update the correct DIV based on the version of reporting services.
January 7, 2016 at 2:27 am
Thank you for getting back to me 🙂
I've tested changing the divs already and unfortunately it hasn't worked for me.
I believe my issue to be slightly different as I have no problems in Chrome and that the reports render correctly on our network in Safari.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply