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) > DPA server integration with Orion Platform fails

DPA server integration with Orion Platform fails

Updated November 30, 2016

Overview

When you try to integrate your DPA server with the Orion Platform, the integration fails at the Discovering node relationships step. This error is displayed in the GUI. 

Establishing Integration

Unexpected Error Occurred All changed reverted. Please try again later or contact support.

You can find this exception in the DPA.BusinessLayer.log file: 

ERROR SolarWinds.DPA.BusinessLayer.Integration.Commands.ConfigureIntegration.DiscoverNodeRelationshipsCommand - Discover Node relationships failed
System.NullReferenceException: Object reference not set to an instance of an object.
at SolarWinds.DPA.Data.Mapping.NodeExplorer.<>c.<getdiscoverednoderelationships>b__27_3(DatabaseInstance instance) in C:\Perforce\Dev\Main\Orion\DPA\Src\Lib\SolarWinds.DPA.Data\Mapping\NodeExplorer.cs:line 123
at System.Linq.Enumerable.WhereSelectListIterator`2.MoveNext()
at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
at SolarWinds.DPA.Data.Mapping.NodeExplorer.GetDiscoveredNodeRelationships() in C:\Perforce\Dev\Main\Orion\DPA\Src\Lib\SolarWinds.DPA.Data\Mapping\NodeExplorer.cs:line 119
at SolarWinds.DPA.Data.Mapping.NodeExplorer.Discover() in C:\Perforce\Dev\Main\Orion\DPA\Src\Lib\SolarWinds.DPA.Data\Mapping\NodeExplorer.cs:line 91
at SolarWinds.DPA.BusinessLayer.Integration.Commands.ConfigureIntegration.DiscoverNodeRelationshipsCommand.ExecuteInternal(ExecutionContext context) in C:\Perforce\Dev\Main\Orion\DPA\Src\Lib\SolarWinds.DPA.BusinessLayer\Integration\Commands\ConfigureIntegration\DiscoverNodeRelationshipsCommand.cs:line 55
</getdiscoverednoderelationships>

Environment

  • DPA in Orion 10.2 and later

Cause

This happens if you registered Oracle databases using the Transparent Network Substrate (TNS) Name or TNS Connect Descriptor. In this case, the database instance has an empty Host property In the DPA database.

If you register your Oracle database instance with TNS Name or TNS Connect Descriptor, DPA in Orion will not be able to find the correct relationship for that database instance.

Resolution

Recommended method

SolarWinds recommends changing the connection type to Direct Connect for each Oracle database instances registered using TNS Name or TNS Connect Descriptor.

  1. In DPA, click Options > Update Connection Info.
  2. Select the Oracle database instance, and click Next.
  3. Change the Connection Option, and complete the wizard.

Alternative method

The alternative method is to update the Host property to an empty string instead of null.

  1. Check if there is at least one database instance with an empty Host, and run the following SQL query on the DPA database:
    SELECT NAME, ID FROM [ignite].[COND] WHERE [CONN_HOST] IS NULL

    If the list if empty, there is a different issue. Submit a ticket with customer support in that case.

  2. If the list is not empty, run this script:
    UPDATE [ignite].[COND] SET [CONN_HOST] = '' WHERE [CONN_HOST] IS NULL
  3. Integrate your DPA server with the Orion Platform again.

 

Last modified
09:05, 2 Dec 2016

Tags

Classifications

Public