The request failed with HTTP status 413: Request Entity Too Large. at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse

Marcel Ratnam 0 Reputation points
2023-01-13T00:05:45.1666667+00:00

Hi we're receiving this error attempting to execute a report on Reporting Services 2019. Our report is configured to use web service data sources. It appears a particular request exceeds to configured maximum request entity size when certain parameters are picked from the report manager parameter interface.

An error has occurred during report processing. (rsProcessingAborted) Query execution failed for dataset 'DataSetResults'. (rsErrorExecutingCommand) Failed to execute web request for the specified URL. Soap Fault: System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Net.WebException: The request failed with HTTP status 413: Request Entity Too Large. at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall) at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters) at ...

I have tried setting uploadReadAheadSize in the ReportServer and ReportManager web.configs but this has not fixed the issue

<system.webServer>
    <security>
      <requestFiltering>
        <requestLimits maxAllowedContentLength="104857600" />
      </requestFiltering>
    </security>
    <serverRuntime uploadReadAheadSize="104857600" />
  </system.webServer>

After applying that change, I had also used SSRS Config Manager to restart SSRS.

The web service being called for the datasource is also hosted in the local IIS instance.

Does anyone know what can be done to increase that request size?

Thanks!!!

Internet Information Services
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,797 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. AniyaTang-MSFT 12,311 Reputation points Microsoft Vendor
    2023-01-13T02:51:19.79+00:00

    Hi @Marcel Ratnam

    Are you running IIS and Reporting Services on the same computer?

    When I searched, I found that IIS also limits the size of file uploads. I don't know much about IIS, maybe you can refer to this link: [https://techcommunity.microsoft.com/t5/iis-support-blog/solution-for-request-entity-too-large-error/ba-p/501134.

    If it is related to IIS, you can also add the IIS tag, so that people who know IIS can check this problem.

    Best regards,

    Aniya