Applicable Versions: All

If, in the drill down window, you see an error message rather than the contents of the drill down, you may need to change a server setting.  The error may be caused by a restriction made by Internet Information Services (IIS) on the amount of data that can be sent in a request to the server.

On there machine where DataPA Enterprise is installed, open IIS Manager (by typing 'IIS' in the Start Menu or Start Screen).

Navigate to your 'DataPA' application in the Sites folder in the Connections pane on the left-hand-side of the IIS Manager window.

In the right-hand 'Home' pane, in the 'IIS' section, double click 'Request Filtering', then click 'Edit Feature Settings' under Actions on the right-hand-side.

Increase the values of Maximum URL length and Maximum query string.  If these values are the defaults of 4096 and 2048 respectively,try doubling these values at first, then if necessary, increase gradually until the error no longer occurs.

You should also change the ASP.Net limit, set in DataPA's web.config, found in the root of the web folder (by default, c:\inetpub\wwwroot\datapa).  Locate the element named 'httpRuntime', and add a properties named 'maxRequestLength', 'maxQueryStringLength' and 'maxUrlLength', setting these to the same value that you used above.  The element will look something like:

<httpRuntime targetFramework="4.6.2" maxRequestLength="102400" ... />

Beware that, if you have DataPA on a public web server (that is, available over the internet), you should not increase these values to any more than required, as large values increase the risk of a Denial of Service attack on your server.