Network Management

Error: Maximum request length exceeded in excel when generating NPM or NCM Reports

"The maximum number of rows in an Excel worksheet with the current format is: 65536" occurs when generating NPM or NCM reports.

First published date

10/10/2018 6:35 PM

Last published date

8/8/2022 6:57 AM

Overview

This article provides brief information on the following website error when creating a report:

maximum request length exceeded. 
Same limitation applies when you export it to excel file.

or

The maximum number of rows in an excel worksheet with the current format is: 65536

or when trying to select nodes in a NCM job you received the following error: 

"Unexpected Website Error
Maximum request length exceeded."

Product section

Network Performance Monitor

Cause

The limitation on NCM and NPM reports has been decreased to 65535 rows with the NCM 7.4 and NPM 12.

This will be a Feature Request, since developers will need to implement a check on the version of Excel used when exporting this to Excel.

Resolution

Please try the following steps to increase the Request Length when selecting nodes in a NCM job:

1) Go to C:\inetpub\SolarWinds\Orion\NCM folder.
2) Create a backup of Web.config .
3) Open the Web.config file, and add the following element in “<configuration>” section:

<location path="Resources/Jobs/ChooseNodes.aspx">
    <system.web>
      <httpRuntime maxRequestLength="8192"/>
    </system.web>
</location>