Submit a ticketCall us

WebinarUpcoming Webinar: How Help Desk and Remote Support Pays for Itself

Learn how help desk software can simplify ticketing management, allow you to track hardware and software assets, and accelerate the speed of IT support and service delivery. Gain insights on how remote support tools allow your IT team to maximize their efficiency and ticket resolution by expediting desktop troubleshooting, ultimately helping keep end-users happy and productive.

Register here.

Home > Success Center > Network Configuration Manager (NCM) > Exception while configuring plugin SolarWinds NCM Integration Plugin component Orion Database Update. Bad Data

Exception while configuring plugin SolarWinds NCM Integration Plugin component Orion Database Update. Bad Data

Created by Norsolihati Selamat, last modified by Rodim Suarez_ret on Aug 26, 2016

Views: 834 Votes: 1 Revisions: 5

Overview

NCM 7.3.2 installation ends with the following error:

Exception while configuring plugin SolarWinds® NCM Integration Plugin component Orion Database Update. Bad Data.

Other modules are working and the following error appears when editing nodes:

There was an error retrieving data from SolarWinds Information Service"

 

Interesting error on the Configuration wizard logs:
ERROR SettingsDAL - Update NCM_NodeProperties Failed.
System.Security.Cryptography.CryptographicException: Bad Data.
ERROR ConfigurationProgressScene - Unable to update NCM database to FIPS compliant due to exception: System.Security.Cryptography.CryptographicException: Bad Data.
ERROR ConfigurationProgressScene - Exception while configuring plugin SolarWinds NCM Integration Plugin component Orion Database Update. System.Security.Cryptography.CryptographicException: Bad Data.

Environment

NCM 7.3.2

Cause 

 There is a broken certificate and the encrypted data needs to be reset.

Resolution

Note: The script provided will reset all encrypted NCM data such as usernames or passwords to your devices. Account credentials for accessing web console will not be reset.

  1. Run the following sql:
    UPDATE n
    SET
    n.Username = '',
    n.Password = '',
    n.EnablePassword = ''
    FROM [dbo].[NCM_NodeProperties] n


    UPDATE NCM_UserLevelLoginCredentials SET UserLevelName='', UserLevelPassword='', UserLevelEnablePassword=''

    UPDATE NCM_GlobalSettings SET SettingValue='' 
    WHERE SettingName='GlobalSNMPUsername' 
      OR SettingName='GlobalUsername'
      OR SettingName='GlobalPassword'
      OR SettingName='GlobalEnablePassword' 
      OR SettingName='GlobalSNMPAuthenticationPassword' 
      OR SettingName='GlobalSNMPEncryptionPassword'

    UPDATE NCM_NCMSettings SET SettingValue='' 
    WHERE SettingName='SMTP Auth Username' 
      OR SettingName='RTN UserName' 
      OR SettingName='RTN UserLevelName' 
      OR SettingName='RTN UserLevelName' 
      OR SettingName='SCP User Name'
      OR SettingName='RTN Password' 
      OR SettingName='Global SMTP Auth Password' 
      OR SettingName='SMTP Auth Password' 
      OR SettingName='RTN UserLevelPassword' 
      OR SettingName='RTN UserLevelEnablePassword' 
      OR SettingName='SCP Password'

    UPDATE NCM_ConnectionProfiles SET UserName='',Password='', EnablePassword=''
  2. Re-run the Configuration Wizard.

 

Last modified

Tags

Classifications

Public