Network Management

Error: Array dimensions exceeded supported range

This article discusses resolution steps when Job History Log does not open. Common cause is full Job Log.

First published date

11/28/2018 12:15 AM

Last published date

11/28/2018 12:15 AM

Overview

When you attempt to clear a job's history log, you might receive the following error:

Array dimensions exceeded supported range

For example, when you click the Job Log link, you receive a message that the log file is too large to display.

When you click the Clear Log button, the error message is displayed:

Product section

Network Configuration Manager

Cause

This issue is caused by architectural (internal) limitation of data structures used in software while data structures on the database side allow for a much larger size.

Resolution

Back up the database before you perform any further steps which involve direct changes to the table content. For more information, see the SQL Server documentation.
Open either the Orion Database Manager available on the Orion server or SQL Server Management Studio (Wikipedia®, available at en.wikipedia.org, obtained on November 27, 2018) from Microsoft.
Run the following query against the Orion database to delete history for all NCM Jobs:
```
UPDATE [NCM_NCMJobs]
SET [JobLog] = NULL
```
To verify, open the Jobs page and see if the logs are removed.

Disclaimer: Please note, any content posted herein is provided as a suggestion or recommendation to you for your internal use. This is not part of the SolarWinds software or documentation that you purchased from SolarWinds, and the information set forth herein may come from third parties. Your organization should internally review and assess to what extent, if any, such custom scripts or recommendations will be incorporated into your environment. You elect to use third party content at your own risk, and you will be solely responsible for the incorporation of the same, if any.

Disclaimer: Please note, any content posted herein is provided as a suggestion or recommendation to you for your internal use. This is not part of the SolarWinds software or documentation that you purchased from SolarWinds, and the information set forth herein may come from third parties. Your organization should internally review and assess to what extent, if any, such custom scripts or recommendations will be incorporated into your environment. You elect to use third-party content at your own risk, and you will be solely responsible for the incorporation of the same if any.