Error on SSRS Report execution query string size exceeded

 Error on SSRS Report execution

Excption information:

Exception type: HttpException

Exception message: The length of the query string for this request exceeds the configured maxQueryStringLength value.

at System.Web.HttpRequest.ValidateInputIfRequiredByConfig()

at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

Solution

Go to

C:\Program Files\Microsoft SQL Server\MSRSXX.<instance_name>\Reporting Services\ReportServer\

Open the web.config

Find the <httpRuntime> element.

<?xml version=”1.0" encoding=”utf-8">

<configuration>

    <system.web>

        ...

        <httpRuntime maxRequestLength="100000" executionTimeout="90000" requestValidationMode="2.0" >

        ...

    </sytem.web>

Add or modify the maxQueryStringLength attribute (DefaultValue is 2048).

<?xml version=”1.0" encoding=”utf-8">

<configuration>

    <system.web>

        ...

        <httpRuntime maxRequestLength="100000" executionTimeout="90000" requestValidationMode="2.0" maxQueryStringLength="4096">

        ...

    </sytem.web>

 Restart the IIS using iisreset commond on commond prompt