Submit a ticketCall us

Looking to compare latest NPM features with previous versions of NPM?
The NPM new feature summary offers a comparison of new features and improvements offered with this release.

 

 

 

 

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

Remove integration with a DPA server manually

Updated November 28, 2016

Overview

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

Environment

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

Cause

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

Resolution

  1. Execute the queries in the Reference section below to remove integration data from the Orion database and the DPA repository database.
  2. Restart the Ignite PI Server service.
  3. Restart the SolarWinds Information V3 service and Module Engine service.

Reference

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
10:48, 17 Apr 2017

Tags

Classifications

Public