Network Management

Unexpected Website Error when Editing a Node after Manual Insert of Records in NCM ConnectionProfiles table

This article is created to address the issue when the customer manually insert credential records on the NCM_ConnectionProfiles table and it affects adding\editing of node and network discovery

First published date

11/20/2020 1:27 AM

Last published date

11/20/2020 1:27 AM

Overview

When adding\editing a node or running a discovery wizard, below error message is prompted.

OrionWeb.log show below error messages.

System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.ServiceModel.FaultException`1[SolarWinds.InformationService.Contract2.InfoServiceFaultContract]: Cirrus.Nodes.GetAllConnectionProfiles failed, check fault information.
System.Security.Cryptography.CryptographicException --> Padding is invalid and cannot be removed.

Product section

Network Configuration Manager

Cause

The customer manually inserted a connection profile record directly on the database which SolarWinds can't read properly.

Resolution

Remove the records which are manually inserted on the NCM_ConnectionProfiles table using the Orion Database Manager or clear all the records on the NCM_ConnectionProfiles table by running the below query in the database.

-- Scripts are not supported under any SolarWinds support program or service. 
-- Scripts are provided AS IS without warranty of any kind. SolarWinds further 
-- disclaims all warranties including, without limitation, any implied warranties 
-- of merchantability or of fitness for a particular purpose. The risk arising 
-- out of the use or performance of the scripts and documentation stays with you. 
-- In no event shall SolarWinds or anyone else involved in the creation, 
-- production, or delivery of the scripts be liable for any damages whatsoever 
-- (including, without limitation, damages for loss of business profits, business 
-- interruption, loss of business information, or other pecuniary loss) arising 
-- out of the use of or inability to use the scripts or documentation.

TRUNCATE TABLE NCM_ConnectionProfiles

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.