KBI 312138 Issue Addressed: SQL Query Rule Run by Service Fails Randomly but Rule Test Always Return Correct Result    

Version

Argent Omega 2.2A-2310-A or earlier

Date

Monday, 18 December 2023

Summary

SQL Query Rule in Argent Omega for SQL Server generates alerts randomly. Events might be automatically resolved in the next runs. However, when testing Rule interactively in Web UI, correct results are always returned.

The issue has been addressed in Argent Omega 2.2A-2401-A.

Technical Background

It is caused by a coding error. There can be a race condition when running multiple Rules concurrently using the same Argent Omega Executor pool, which generates unpredictable results.

Resolution

Upgrade to Argent Omega 2.2.2401-A or later.
For customers who cannot upgrade immediately, make sure to use option ‘Spawn New Task Executor Process’ for Relators that run SQL Query Rule. This can avoid the race condition though the option has some performance cost.

For further assistance, please contact Argent on Instant Help at
https://Instanthelp.Argent.com/