Error after upgrade: Failed to inject parameters into text : Expression failed to evaluate. Column toDurationFromSec(LongRunningSQL.total_elapsed_time_sec) not found (4375486)

Error after upgrade: Failed to inject parameters into text : Expression failed to evaluate. Column toDurationFromSec(LongRunningSQL.total_elapsed_time_sec) not found

Customer report receiving errors after upgrading spotlight and importing the configuration from the old installation, via importsosse.bat. The error received reads as follows:

Information    Monitored Server - SQL Server Alarm Evaluation Failure    3/18/2024 5:00:48 PM        Alarm 'SQL - Long Running SQL' failed : Internal error : Failed to inject parameters into text : Expression failed to evaluate. Column toDurationFromSec(LongRunningSQL.total_elapsed_time_sec) not found : Traceback (innermost last):
  File 'longrunningsqlrule_ruleMessage', line 1, in ?
java.lang.AssertionError: Unknown data type. Column lookup failed for identifier 

This issue was caused due to the import of an old rule with a variable name (total_elapsed_time_sec) which is no longer valid, the currently valid variable name is (total_elapsed_time).

RESOLUTION:

1- Backed up the current installation by creating a zip of the agent folder:
C:\Program Files\Quest Software\Diagnostic Server\Agent
2- Follow the steps from the attached guide to find and remove all references to the deprecated variable name.
3- Restart the spotlight diagnostic server and remove any old alarms referencing this error.