Alert not working after alert owner account is disabled

10/10/2018 3:31 PM

2/7/2022 2:58 PM

Alerts owned by an account user that has been deleted/disabled have stopped working.

The Alerting,Service.v2.log file located in C:\ProgramData\Solarwinds\Logs\Orion\ shows the following message:

Also encountered on Orion 2019.4.

WARN  SolarWinds.Orion.Core.Alerting.Plugins.Conditions.
Swql.ConditionEvaluatorSwql - Condition evaluation failed : User account is disabled.

Orion Platform

Reactivate the user account or change the ownership of the alerts:

Warning: Changing the ownership may return different results due to various user limitations.

1. Create a backup of the database.
2. Click Start > All Programs > SolarWinds Orion > Advanced Features > Database Manager.
3. Click Add Default Server and expand down to your SolarWinds database.
4. Double-click the Alert Configurations table.
5. Delete the default query and replace with the following: 
   1. If Old users are present:

      -- Scripts are not supported under any SolarWinds support program or service.
      -- Scripts are provided AS IS without warranty of any kind. SolarWinds further
      -- disclaims all warranties including, without limitation, any implied warranties
      -- of merchantability or of fitness for a particular purpose. The risk arising
      -- out of the use or performance of the scripts and documentation stays with you.
      -- In no event shall SolarWinds or anyone else involved in the creation,
      -- production, or delivery of the scripts be liable for any damages whatsoever
      -- (including, without limitation, damages for loss of business profits, business
      -- interruption, loss of business information, or other pecuniary loss) arising
      -- out of the use of or inability to use the scripts or documentation.
      
      UPDATE AlertConfigurations
      SET CreatedBy  = 'NewUser'
      WHERE CreatedBy = 'OldUser'

   2. If affected alerts have NULL:

      -- Scripts are not supported under any SolarWinds support program or service.
      -- Scripts are provided AS IS without warranty of any kind. SolarWinds further
      -- disclaims all warranties including, without limitation, any implied warranties
      -- of merchantability or of fitness for a particular purpose. The risk arising
      -- out of the use or performance of the scripts and documentation stays with you.
      -- In no event shall SolarWinds or anyone else involved in the creation,
      -- production, or delivery of the scripts be liable for any damages whatsoever
      -- (including, without limitation, damages for loss of business profits, business
      -- interruption, loss of business information, or other pecuniary loss) arising
      -- out of the use of or inability to use the scripts or documentation.
      
      UPDATE AlertConfigurations
      SET CreatedBy = 'NewUser'
      WHERE CreatedBy is NULL

6. Click Execute Query. 
   Notes:
   For a list of accounts, check the Accounts table.
   Pay attention to letter casing in account names.
7. After updating the DB, restart Alerting Service V2