Knowledge Base
cancel
Showing results for 
Search instead for 
Did you mean: 

Report can not be displayed - The request failed with HTTP status 503: Service Unavailable

Issue

When trying to open a report, you get an error message like below:

Msg=DDL creation failed ex=Error creating DropDownddlTopCount The request failed with HTTP status 503: Service Unavailable

Ex=ButtonRunReport The request failed with HTTP status 503: Service Unavailable

 

Environment

Reports server

Cause

Cause 1: The Report Server Service is not started

To check if this is the cause, open the report manager. If you get the error below, continue to resolution 1.

 

Cause 2: The Report Server Service takes too long to generate the report and thus times out

The root cause should also be investigated. It can be a slow network connection, fragmented SQL database, antivirus software or memory limitation that is slowing the request to compile a report down.

Resolution

Resolution 1

  1. Open "Reporting Services Configuration Manager"
  2. Start the server

 

Resolution 2

Increase the timeout for the report service

  1. Open Report Manager
  2. Click "Site Settings"
  3. Change the Report Timeout. Default is 1800 which is 30 seconds.

 

Check that the memory usage for the SQL server is not limited (Further information)

  1. Open SQL Management Studio
  2. Open the properties for the SQL Server
  3. Click "Memory" and check that the value is default (2147483647)

 

Reindex and defragment the SQL database e.g. using "SBO Reports Agent Config"

Tags (4)
Labels (1)
Version history
Revision #:
1 of 1
Last update:
‎2018-09-11 03:45 AM
Updated by: