Submit a ticketCall us

WebinarUpcoming Webinar: Should I Move My Database to the Cloud?

So you’ve been running an on-premises SQL Server® for a while now. Maybe you’ve moved it from bare metal to a VM, and have seen some positive benefits. But, do you want to see more? If you said “YES!”, then this session is for you, as James Serra will review the many benefits that can be gained by moving your on-prem SQL Server to an Azure® VM (IaaS). He’ll also talk about the many hybrid approaches, so you can gradually move to the cloud. If you are interested in cost savings, additional features, ease of use, quick scaling, improved reliability, and ending the days of upgrading hardware, this is the session for you.

Register now.

Home > Success Center > Database Performance Analyzer (DPA) > DPA - Knowledgebase Articles > 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