Submit a ticketCall us

Quickly Address Software Vulnerabilities
Patch Manager is an intuitive patch management software which extends the capabilities of WSUS and SCCM to not only patch Windows® servers and workstations, and Microsoft® applications, but also other 3rd-party applications which are commonly exploited by hackers. Learn more about our patch management solution.

 

Home > Success Center > Network Configuration Manager (NCM) > Error: Could not alter datatype of NCM_RTNAudit.message to nvarchar(500)Alter failed Column 'Message'

Error: Could not alter datatype of NCM_RTNAudit.message to nvarchar(500)Alter failed Column 'Message'

Created by Daniel Polaske, last modified by Kevin Sperrazza on Sep 02, 2016

Views: 8 Votes: 3 Revisions: 8

Overview

This article describes the issue when the Configuration Wizard finishes, applying NPM 11.5. hotfix 6, you receive the following error:

 

Could not alter datatype of NCM_RTNAudit.message to nvarchar(500)Alter failed Column 'Message'

Environment

All versions of NCM

Cause 

This issue occurs when you have NCM_RTNAudit.message columns set to to nvarchar(MAX). A report might have been created due to some issue on RTN functionality and was provided with SQL query to increase the size of this column. And when re-running the Configuration Wizard, it tries to set it back to the original 500 characters and fails since it is not possible to decrease size of the column (data loss prevention). 

Resolution

Follow steps below to resolve the issue:

  1. Run text editor (i.e. Windows Notepad) as admin (right click and select Run As Administrator)
  2. Open below file for edition (default installation location)

    C:\Program Files (x86)\SolarWinds\Orion\NCM\ConfigMgmtEngine8.DBStructure

     
  3. Search for below phrase which starts section where table NCM_RTNAudit is defined

    Table Name="NCM_RTNAudit"

     
  4. Modify size of the Message column from default 500 to MAX

    [Message] [nvarchar] (max) NOT NULL,

     
  5. Save file.
  6. Re-run the Configuration Wizard.

 

Last modified
10:35, 2 Sep 2016

Tags

Classifications

Public