Submit a ticketCall us

Have You Auto Renewed? If not, you're missing out.
The SolarWinds Renewal Program comes with a host of benefits including the most recent product updates, 24/7 technical support, virtual instructor-led training and more. Experience all of this with the convenience of Auto Renewal, and never worry about missing any of these great benefits. Learn More.

Home > Success Center > Database Performance Analyzer (DPA) > Remove integration with a DPA server manually

Remove integration with a DPA server manually

Updated September 19, 2017

Overview

You have DPA and the Orion Platform installed on the same computer, and the DPA integration to Orion is not working. 

There are several symptoms of this issue:

  • In the Alerts resource, there are no Active Alerts present or an error message is shown.
  • Users are unable to enable or disable alerts in the Manage Alerts view.
  • One of the following exceptions is shown in a log file:
    • System.ServiceModel.FaultException`1[SolarWinds.InformationService.Contract2.InfoServiceFaultContract]: BulkUpdate failed, check fault information.
    • System.ServiceModel.EndpointNotFoundException: There was no endpoint listening at https://<DPA-SERVER-ADDRESS>:8124/iwc/services/InformationService

Environment

  • DPA 10.1 and earlier
  • DPA 10.1.317
  • DPA 10.2 and later
  • Orion Platform 2016.1 and later

Resolution

For integrations with DPA 11.1 and later

Execute the following stored procedure to remove all DPA integrations from the Orion Platform.

  1. Execute the stored procedure and the queries in the sections below to remove integration data from the Orion database and the DPA repository database.
  2. Restart each instance of DPA:
    • On Windows, stop and restart the Ignite PI Server service.
    • On Linux or Unix, run the shutdown.sh and startup.sh commands from the DPA directory.
  3. Restart the SolarWinds Information V3 service and Module Engine service.

Orion database

In the SolarWinds Orion database, execute the stored procedure dpa_RemoveAllIntegrations, owner-qualified with dbo. For example:

EXEC [dbo].[dpa_RemoveAllIntegrations];

DPA database

Run the following queries on the DPA repository database:

-- remove DPA repository credentials
DELETE FROM ignite.CONUSER WHERE ID IN(SELECT SERVICE_USER_ID FROM ignite.CON_ORION_INTEGRATION)
DELETE FROM ignite.CONUSERPRIVS WHERE USERID IN(SELECT SERVICE_USER_ID FROM ignite.CON_ORION_INTEGRATION)

-- remove Orion server credentials
DELETE FROM ignite.CON_ORION_CREDENTIALS;

-- remove subscriptions
DELETE FROM ignite.CON_ORION_SUBSCRIPTIONS;

-- remove integration
DELETE FROM ignite.CON_ORION_INTEGRATION;

The ignite schema is the default when you install DPA. If these queries do not work, change ignite to your custom schema.

For integrations with DPA 11.0 and earlier

  1. Execute the queries in the sections below to remove integration data from the Orion database and the DPA repository database.
  2. Restart each instance of DPA:
    • On Windows, stop and restart the Ignite PI Server service.
    • On Linux or Unix, run the shutdown.sh and startup.sh commands from the DPA directory.
  3. Restart the SolarWinds Information V3 service and Module Engine service.

Orion database

Run the following queries on the Orion database through SQL Management Studio.

Note: These queries will not work in the SolarWinds Database Manager application.

-- clear url to jSWIS
IF (dbo.GetDPADbVersion() < 4)
BEGIN	
	DELETE FROM [dbo].[WebSettings] WHERE SettingName IN ('DPA.ServerUrl', 'DPA.DpaServiceUserAccountId');
END  

-- clear credentials for jSWIS
DELETE cp FROM [dbo].[CredentialProperty] cp
	INNER JOIN [dbo].[Credential] c ON cp.CredentialID = c.ID
	WHERE c.Name = '__DPA.Service.Account';
DELETE FROM [dbo].[Credential] WHERE Name = '__DPA.Service.Account';  

-- remove DPA service account
DELETE FROM [dbo].[Accounts] WHERE AccountID LIKE 'DPAServiceUser_%';

-- clear existing relationships
DELETE FROM [dbo].[DPA_DatabaseInstanceData];
DELETE FROM [dbo].[DPA_DatabaseInstanceApplicationRelationship];
DELETE FROM [dbo].[DeletedAutoDependencies] WHERE [ParentEntityType] = 'Orion.DPA.DatabaseInstance'
DELETE FROM [dbo].[Dependencies] WHERE [ParentEntityType] = 'Orion.DPA.DatabaseInstance'

-- clear SWIS FED tables
IF EXISTS(SELECT * FROM sys.columns 
    WHERE Name = N'InstanceSiteId'
      AND Object_ID = Object_ID(N'FED_RemoteInformationServices'))
BEGIN
	EXEC sp_executesql N'DELETE s FROM [dbo].[FED_Subscription] s  
	 INNER JOIN [dbo].[FED_RemoteInformationServices] ris ON s.InstanceSiteId = ris.InstanceSiteId WHERE ris.Tag = ''DPAO'';';
	EXEC sp_executesql N'DELETE ps FROM [dbo].[FED_ProviderSubscriptions] ps 
	 INNER JOIN [dbo].[FED_RemoteInformationServices] ris ON ps.InstanceSiteId = ris.InstanceSiteId WHERE ris.Tag = ''DPAO'';';
	EXEC sp_executesql N'DELETE FROM [dbo].[FED_RemoteInformationServices] WHERE Tag = ''DPAO'';';
END
ELSE
BEGIN 
	EXEC sp_executesql N'DELETE s FROM [dbo].[FED_Subscription] s 
	 INNER JOIN [dbo].[FED_RemoteInformationServices] ris ON s.ServerId = ris.ServerId WHERE ris.Tag = ''DPAO'';';
	EXEC sp_executesql N'DELETE FROM [dbo].[FED_RemoteInformationServices] WHERE Tag = ''DPAO'';';
END

-- clear SSO providers
IF (dbo.GetDPADbVersion() >= 4)
BEGIN
	
	DELETE ssop FROM [dbo].[SSO_Providers] ssop 
	  WHERE ssop.Name LIKE 'DPA%' 	
END 

-- clear DPA Servers  
IF EXISTS(SELECT * FROM sys.columns 
    WHERE Object_ID = Object_ID(N'DPA_DpaServer'))
BEGIN	
	EXEC sp_executesql N'DELETE FROM [dbo].[DPA_DpaServer];';
END

DPA database

Run the following queries on the DPA repository database:

-- remove DPA repository credentials
DELETE FROM ignite.CONUSER WHERE ID IN(SELECT SERVICE_USER_ID FROM ignite.CON_ORION_INTEGRATION)
DELETE FROM ignite.CONUSERPRIVS WHERE USERID IN(SELECT SERVICE_USER_ID FROM ignite.CON_ORION_INTEGRATION)

-- remove Orion server credentials
DELETE FROM ignite.CON_ORION_CREDENTIALS;

-- remove subscriptions
DELETE FROM ignite.CON_ORION_SUBSCRIPTIONS;

-- remove integration
DELETE FROM ignite.CON_ORION_INTEGRATION;

The ignite schema is the default when you install DPA. If these queries do not work, change ignite to your custom schema.

Last modified

Tags

Classifications

Public