Version

Argent Advanced Technology 5.1A-2210-A and below

Date

Friday, 4 Nov 2022

Summary

A “Syntax error or access violation” error occurs at the Query Rule

Technical Background

Argent for SQL Server throws an error message “syntax error or access violation”, when running a stored procedure with parameter at SQL Query Rule

This was a coding error and has been addressed in Argent Advanced Technology 5.1A-2210-T2 version

In order to configure the Rule, specify the procedure name and parameter with a space between

For example, to execute a stored procedure named GET_ALERTS_FIRED that accepts a string parameter alert name ‘ALARM_DEMO’, configure SQL Query Rule as shown below:

Multiple parameters should be separated by comma

For example, if the stored procedure GET_ALERTS_FIRED accepts two parameters, such as alert name ‘ALARM_DEMO’ and machine name ‘MFC-SQL’, the SQL command should be:

GET_ALERTS_FIRED ‘ALARM_DEMO’,’MFC-SQL’

Resolution

Upgrade to Argent Advanced Technology 5.1A-2301-A or above