Network Management
Unable to edit or add nodes in the SolarWinds Platform due to an unexpected website error
Getting the following error message when editing or adding a node in the SolarWinds Platform web console. Unexpected Website Error Exception has been thrown by the target of an invocation.
First published date
Last published date
Overview
ERROR SolarWinds.NCM.Common.BusinessLayer.NcmErrorHandler - Exception caught in method ProvideFaultSystem.ArgumentOutOfRangeException: Unable to get record for key id: 2 Parameter name: id
After updating the Solarwinds-Orion certificate to use 2048 bits, the edit node properties page throws the above error. The following may also be seen in the OrionWeb log at C:\Programdata\Solarwinds\Logs\Orion:
ERROR ASP.global_asax - (null) Application_Error(25d7205df82745359ca7f746bc1dc6cc) 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. ProvideFault failed, check fault information.
Product section
Cause
Resolution
Resolution 1
- Ensure there is a recent backup of the database.
- Stop all SolarWinds Platform services on the primary server using the SolarWinds Platform Service Manager.
- Launch Database Manager from the SolarWinds Platform folder of the start menu.
- Select Add Orion Server, then expand the SQL server and database in bold.
- Right-click the SolarWinds Platform Database and select New Query.
- Paste and execute the following in the window on the right:
-- 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.
DELETE FROM NCM_NCMSettings
WHERE SettingName IN ('SCP User Name', 'SCP Password')
- Restart all SolarWinds Platform services in SolarWinds Platform Service Manager.
- Open the SolarWinds Platform Web Console and Navigate to Settings > All Settings > NCM Settings > SCP Server. You should still see the SCP credentials, click Submit to save it.
- Check the edit node properties page again. If the issue persists, proceed to the next resolution.
Resolution 2
Please note, this will wipe all NCM-related credentials and they will need to be re-entered manually.
- Ensure there is a recent backup of the database.
- Stop all SolarWinds Platform services on the primary server using the SolarWinds Platform Service Manager.
- Launch Database Manager from the SolarWinds Platform folder of the start menu.
- Select Add Orion Server, then expand the SQL server and database in bold.
- Right-click the SolarWinds Platform Database and select New Query.
- Paste and execute the following in the window on the right:
-- 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. 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=''
- Restart all SolarWinds Platform services in SolarWinds Platform Service Manager
- Open the SolarWinds Platform Web Console and navigate to a node
- Select Edit Node Properties - the page should now load as expected.