Submit a ticketCall us

AnnouncementsAre You “Flying Blind?”

When it comes to your complex IT infrastructure, you want to ensure you have a good grasp of what’s going on to avoid any fire drills that result from guesswork. Read our white paper to learn how proactively monitoring your IT environment can help your organization while giving you peace of mind.

Get your free white paper.

Home > Success Center > Server & Application Monitor (SAM) > SAM - Knowledgebase Articles > Resolve "Database configuration failed" message that appears in Configuration Wizard after uninstalling SAM 6.7 and then reinstalling SAM with or without other Orion Platform products

Resolve "Database configuration failed" message that appears in Configuration Wizard after uninstalling SAM 6.7 and then reinstalling SAM with or without other Orion Platform products

Updated January 28, 2019

Overview

This article describes how to resolve a "Database configuration failed" message that may appear in the Configuration Wizard if you uninstall SAM 6.7 and then reinstall SAM either alone or with other Orion Platform products.

Additional messages displayed may include:

  • Failure importing sample map
  • Alerts Migration failed
  • Dependency Migration failed

Environment

  • SAM 6.7 or later
  • APM 1.0 or later

This issue impacts Orion Platform installations that include SAM 6.7 and the following products:

  • IPAM 4.7
  • NCM 7.8
  • NPM 12.3
  • NTA 4.4 and 4.5
  • Log Manager 1.1
  • SCM 1.0
  • UDT 3.3.1
  • VMAN 8.3
  • VNQM 4.5
  • WPM 2.2.2

 

Error

Core business layer:

2019-01-28 00:41:11,265 [Main] FATAL SolarWinds.Orion.Core.BusinessLayer.CoreBusinessLayerPlugin - (null)  Unhandled Exception caught in plugin startup.
System.ServiceModel.FaultException`1[SolarWinds.InformationService.Contract2.InfoServiceFaultContract]: RunQuery failed, check fault information.
Source entity [Orion.Package] not found in catalog (Fault Detail is equal to InfoServiceFaultContract [ SolarWinds.Data.Query.EntityNotFoundException: Source entity [Orion.Package] not found in catalog
   at SolarWinds.Data.Query.Processor.SemanticChecker.HandleSourceEntityExpression(SourceExpression sourceExpression)

 

Information Version 3

2019-01-28 00:49:35,769 [64] ERROR SolarWinds.InformationService.Core.InformationService - SolarWinds.ServiceHost.Process| Service-SolarWinds.Cortex.DataCollection| SolarWinds.Orion.Core.Common.IndicationMonitor.SwisSubscriptionDAL.SolarWinds.Orion.Core.Common.InformationService.ISubscriptionDAL.Read()|  (null)     Exception running query:
SELECT Uri FROM System.Subscription WHERE    EndpointAddress IN (@address) AND Query=@query    AND Version=@version RETURN XML RAW
2019-01-28 00:49:35,894 [92] ERROR SolarWinds.InformationService.Core.InformationService - SolarWinds.BusinessLayerHost| domain-SolarWinds.DPA.BusinessLayer.dll| SolarWinds.DPA.Common.DAL.SwisQueryCachedSettingDAL.QuerySwis()|  (null)     Exception running query:
SELECT TOP 1 m.Version
FROM(SELECT Version FROM Orion.InstalledModule WHERE Name = 'APM' UNION ALL (SELECT TOP 1 '' AS Version FROM Orion.InstalledModule)) AS m    
ORDER BY m.Version DESC RETURN XML RAW
2019-01-28 00:49:36,003 [86] ERROR SolarWinds.InformationService.Core.InformationService - SolarWinds.Collector.Service| domain-SWCollectorService-0| SolarWinds.Orion.Core.Dependencies.InformationService.SwisHelper.Query()|  (null)     Exception running query:
SELECT x.EntityName as EntityType, x.KeyName, EntityKeyNum FROM (
 SELECT p.EntityName, p1.EntityKeyNum, CASE WHEN p1.EntityKeyNum = 1 THEN p.Name ELSE '- multiple keys -' END as KeyName
 FROM Metadata.Property p
 JOIN (SELECT EntityName, COUNT(1) as EntityKeyNum FROM Metadata.Property WHERE IsKey=1 and Type='System.Int32' GROUP BY EntityName) p1  ON p.EntityName = p1.EntityName
 WHERE p.IsKey=1 and p.Type='System.Int32'
) x GROUP BY x.EntityName, x.KeyName, x.Entit

Cause 

When SAM 6.7 is installed, the Orion Installer adds a package related to SolarWinds APM — SAM.AppOptics to C:\ProgramData\Solarwinds\InformationService\v3.0 for later use if you integrate SAM with SolarWinds APM.

If you uninstall SAM, the MSI application launched via the Windows Control Panel does not remove the SAM.AppOptics package. When you run the Orion Installer again to reinstall SAM, a "Database configuration failed" message appears if the remaining APM package blocks the loading of required entities.

Resolution

  1. Log into the Orion Server with administrator privileges.
  2. In a text editor, open the Orion.Installer.Packaging.roots file stored in the C:\Program Files (x86)\SolarWinds\Orion\Packaging\Roots folder.
  3. Remove the following line (the version number will vary) and save the file:

<requires id="Orion.SAM.AppOptics" version="[1.0.0.867,]" /> 

  1. Run the Orion Configuration wizard to refresh files on the web server and check the database structure. 

 

Last modified

Tags

Classifications

Public