The HTTP service located at https://MACHINE:32843/a49407bfb2c3432e9953dc831d8b0a0f/ReportingWebService.svc is too busy

 

Playing around with the SharePoint integration with the new Addin of Reporting Services 2012 I suddenly found myself with the following error while running a report that used to work perfectly before:

 

Error

The HTTP
service located at https://MACHINE:32843/a49407bfb2c3432e9953dc831d8b0a0f/ReportingWebService.svc
is too busy.

The HTTP
service located at https:// MACHINE:32843/a49407bfb2c3432e9953dc831d8b0a0f/ReportingWebService.svc
is too busy.

The remote
server returned an error: (503) Server Unavailable.
 

 

I know the password of my account had changed by after correcting it in the application pools in IIS and in Central Administration under managed accounts, the error persisted and I couldn’t get it to work again.

I finally fixed it by re-provision the Reporting Services Service Application.

I am sharing the steps I used in PowerShell:

 

  •  First of all you need to open the SharePoint Management Shell to be able to run cmdlets:

 (From) https://msdn.microsoft.com/en-us/library/gg492249.aspx

  1. Type the following command from the SharePoint 2010 Management Shell:
  2. Click the Start button
  3. Click the Microsoft SharePoint 2010 Products group
  4. Click the SharePoint 2010 Management Shell.

 

  • These are the commands run in SharePoint Management Shell console:

 

1. To Get all the Reporting Services service applications run the following command:

 Get-SPRSServiceApplication

  
 
  
  
  In my case, I only had one that corresponded to the ID of the error, although you could have several

 

 2. Then run the two commands:

 

$sts = Get-SPRSServiceApplication

$sts.Provision()

 

And the report started working again!!!

 

 

 

Maria Esteban

Reporting Services Support Engineer