Network Management

Failed to configure Database for Log and Event Monitoring due to errors when creating Log Source Definitions

Configuration Wizard throws fails with message "Failed to configure Database for Log and Event Monitoring due to errors when creating Log Source Definitions"

First published date

12/21/2019 4:36 PM

Last published date

3/2/2021 2:35 AM

Overview

Scenario 1: Error on Main Poller in Standalone installation or Performing an upgrade not installing the Log Analyzer

While adding Orion Log Analyzer(LA 2019.4) module to an existing installation or performing an upgrade not installing the Log Analyzer, you may see the following error during the Configuration Wizard run.

2020-06-14 12:09:18,210 [18] ERROR ConfigurePluginDatabaseComponents - Failed configuring component Log Analyzer (479) 1
SolarWinds.ConfigurationWizard.Plugin.Orion.ConfigurePluginComponents+ComponentConfigurationException: Aborting configuration ---> SolarWinds.ConfigurationWizard.Common.ConfigurationException: 	•  Failed to configure Database for Log and Event Monitoring due to errors when creating Log Source Definitions.

Scenario 2: The same error is also seen while adding/installing LA on Additional Polling Engine via Centralized Upgrade tool

Scenario 3: Error on APE not using Centralized Upgrade:

The Main Polling Engine with NPM + LA 2019.4 is already installed and up and running with Orion database pointing to SQL Server1
Brand new Additional Polling Engine deployed and installed LA 2019.4 and chose the option Scalability Engines > LA Free poller - Pointing to LA DB on SQL Server2
Runs the Configuration Wizard when prompted and see the error after 2-5 minutes
When we checked the Main Polling Engine database configuration, the LA database was pointing to SQL Server1 still

Scenario 4: Orion Log Viewer was not upgraded by the Centralized Upgrade but upgraded all the other modules to 2020.2

Product section

Network Performance Monitor

Cause

Main Polling Engine was not configured to point to the correct location of the LA database
Incomplete SQL permission role

Resolution

Scenario 1:

Verify the SQL permission role requirements on the Solarwinds Orion Platform for the LogManagerDB user
Re-run the Configuration Wizard select the correct LA 'database'.
The Configuration Wizard should finish without errors or issues.

Scenario 2:
If encountering this error while installing LA on Additional Polling Engine via Centralized Upgrade Tool in the Orion Web console.

Copy the OLM Basic msi from the main poller to the APE in the same path:

C:\ProgramData\SolarWinds\Installers\OLM-2019.4.0.14784-LogMgmtBasicInstaller.msi

Re-run the Configuration Wizard.

Scenario 3:
If encountering this error while installing LA 2019.4 on Additional Poller Engine.

Run the Configuration Wizard on Main Polling Engine first and select the correct LA 'database' that is on SQL Server2
Run the Configuration Wizard on Additional Polling Engine and select the correct Soalrwinds Orion database on SQL server1 and then Select the correct LA 'database' that is on SQL Server2

Scenario 4:
Orion Log Viewer was not upgraded by the Centralized Upgrade but upgraded all the other modules to 2020.2:

On the Main Polling Engine, go to the C:\ProgramData\SolarWinds\Installers folder and copy the file name similar to OLM-2020.2.0.17695-LogMgmtBasicInstaller.msi
On the Additional Polling Engine, go to the C:\ProgramData\SolarWinds\Installers folder and paste the copied file to the folder
Run the installer for Orion Log Viewer 2020, the name of the file is similar to OLM-2020.2.0.17695-LogMgmtBasicInstaller.msi
Run Configuration Wizard again, it should finish successfully without errors.

Disclaimer: Please note, any content posted herein is provided as a suggestion or recommendation to you for your internal use. This is not part of the SolarWinds software or documentation that you purchased from SolarWinds, and the information set forth herein may come from third parties. Your organization should internally review and assess to what extent, if any, such custom scripts or recommendations will be incorporated into your environment. You elect to use third-party content at your own risk, and you will be solely responsible for the incorporation of the same if any.