none
SSRS Error - The request failed with HTTP status 503: Server Too Busy. RRS feed

  • Question

  • Hello

    We have a 2016 SSRS Instance that we occasionally get the following error

    Microsoft.ReportingServices.Portal.WebHost!reportserverwebapp!27!01/21/2020-09:42:11:: e ERROR: [2622k60v]: OData exception occurred: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.Net.WebException: The request failed with HTTP status 503: Server Too Busy.
       at Microsoft.SqlServer.ReportingServices2010.RSConnection2010.SetConnectionProtocol()
       at Microsoft.SqlServer.ReportingServices2010.RSConnection2010.SoapMethodWrapper`1.ExecuteMethod(Boolean setConnectionProtocol)
       at Microsoft.SqlServer.ReportingServices2010.RSConnection2010.SoapMethodWrapper`1.ExecuteMethod()
       at Microsoft.SqlServer.ReportingServices2010.RSConnection2010.GetItemParameters(String itemPath, String historyId, Boolean forRendering, ParameterValue[] values, DataSourceCredentials[] credentials)
       at Microsoft.ReportingServices.Portal.Services.SoapProxy.SoapRS2010Proxy.<>c__DisplayClassa.<GetItemParameters>b__9()
       at Microsoft.ReportingServices.Portal.Services.SoapProxy.SoapAuthenticationHelper.ExecuteWithWindowsAuth[TReturn](SoapHttpClientProtocol soapClient, IPrincipal userPrincipal, Func`1 func)
       at Microsoft.ReportingServices.Portal.Services.SoapProxy.SoapAuthenticationHelper.ExecuteWithCorrespondingAuthMechanism[TReturn](SoapHttpClientProtocol soapClient, IPrincipal userPrincipal, Func`1 func)
       at Microsoft.ReportingServices.Portal.Services.SoapProxy.SoapRS2010Proxy.GetItemParameters(IPrincipal userPrincipal, String itemPath, String historyId, Boolean forRendering, ParameterValue[] values, DataSourceCredentials[] credentials)
       at Microsoft.ReportingServices.Portal.Services.SoapProxy.SoapRS2010Proxy.GetParameterTypes(IPrincipal userPrincipal, String reportpath)
       at Microsoft.ReportingServices.Portal.Repositories.CatalogItemRepository.<>c__DisplayClass29.<GetSubscriptions>b__28(SubscriptionImpl x)
       at System.Linq.Enumerable.WhereSelectArrayIterator`2.MoveNext()
       at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
       at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
       at Microsoft.ReportingServices.Portal.Repositories.CatalogItemRepository.GetSubscriptions(IPrincipal userPrincipal, String itemPath)
       at Model.LinkedReportRepository.LoadSubscriptions()
       at Model.LinkedReport.get_Subscriptions()
       at lambda_method(Closure , LinkedReportRepository )
       --- End of inner exception stack trace ---

    We recently put in a server restart every week to get around this issue. The server was restarted this morning at 2am. We then got this error at 09:42. All reports stopped working with this error. To fix it I 

    There are no other error messages in the logs to investigate. Can you help with any configurations that may need changing?

    Thanks

    SG_87

    Tuesday, January 21, 2020 10:24 AM

All replies

  • Hi SG_87,

    SSRS would restart(recycle the appdomain) automatically by default each 12 hours, how have you set this server restart?

    Have you got other clue which may relate to or trigger this error?

    Did we get anything in event log of the server?

    Regards,

    Lukas 


    MSDN Community Support Please remember to click Mark as Answer; the responses that resolved your issue, and to click Unmark as Answer if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Wednesday, January 22, 2020 1:21 AM
  • Hi Lukas

    Thanks for the reply.

    I have a PowerShell script that restarts the servers (we have two servers in a scaled out deployment).

    No logs show anything I am afraid.

    We did not even get to 12 hours before we had this issue.

    Do we need to recycle it more often?

    Thanks

    SG_87

    Wednesday, January 22, 2020 9:24 AM
  • Hi SG_87,

    The recylcle often helps when the system gets too small RAM. If you get sufficient RAM then I don't think recycle will help.

    But you could try it, set the rsreportserver.config file, set the 720(min) to lower value.  Follow this lead :

    SSRS Reporting Server Recycle Time

    If this also not help. Maybe we could consider to escalate this issue by opening a ticket with microsoft support.

    Regards,

    Lukas


    MSDN Community Support Please remember to click Mark as Answer; the responses that resolved your issue, and to click Unmark as Answer if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.


    Friday, January 24, 2020 2:24 AM