Network Management

Alert does not trigger or reset due to User account is disabled

This article describes the issue where alerts do not trigger or reset. You also get the following error in AlertServiceV2.log: Condition evaluation failed : User account is disabled.

First published date

10/23/2018 9:33 PM

Last published date

3/23/2023 11:36 PM

Overview

For verification purposes check AlertServiceV2.log: look for user account is disabled error as it shown here SolarWinds.Orion.Core.Alerting.Plugins.Conditions.Swql.ConditionEvaluatorSwql - Condition evaluation failed : User account is disabled.

Product section

Network Performance Monitor

Cause

This is due to a user account that created the alert being currently disabled.

Resolution

Resolution:
1. Open Database manager and open new query and run the following SQL statement:

1 update AlertConfigurations
2 set createdby=('select top 1 accountid from accounts') -- or any enabled account

2. Duplicate and Edit the Alert so that the current user will be the new creator of the copied alert.

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.