Network Management

System.ServiceModel.FaultException when migrating SolarWinds Platform products to a new server

When migrating your SolarWinds Platform products to a new server, the connection check fails with a System.ServiceModel.FaultException: Cannot insert a duplicate key row in object... To resolve the issue, truncate HA tables or upgrade to 2023.4 or later.

First published date

8/5/2020 12:32 PM

Last published date

2/26/2025 9:41 PM

Overview

When migrating your SolarWinds Platform product to a new server, you cannot pass the connection check step because of the following error:

System.ServiceModel.FaultException`1[System.ServiceModel.ExceptionDetail]: Cannot insert duplicate key row in object 'dbo.SWA_InstallationSession_OrionServer' with unique index 'UX_InstallationSession_Hostname'. The duplicate key value is (7, CNCPWSLWS1002).


This issue was addressed in SolarWinds Platform 2023.4. See Fixes in 2023.4 release notes.

Product section

Orion Platform

Cause

This issue is caused by the HA_Pools table.

Resolution

This issue was addressed in SolarWinds Platform 2023.4. See Fixes in 2023.4 release notes. To resolve the issue, upgrade to 2023.4. 


To resolve the issue on versions earlier than 2023.4, remove all High Availability (HA) entries from the database by running the following query.
  • Run the query even if you don't have High Availability deployed at the moment to make sure there are no remains of previous settings.
  • If you have deployed HA, stop the HA service on all polling engines before you run the query. If you had HA pools configured, you will have to re-create the pools after running the query.
-- 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 HA_FacilitiesInstances
truncate table HA_PoolMemberInterfacesInfo
truncate table HA_PoolMembers
truncate table HA_Pools
truncate table HA_ResourcesInstances

Complete the migration as described in Migrate SolarWinds Orion products to a new server with a new IP or hostname (Task 2, steps 9 and later).