When a variable is used in a SQL, variable intersects message issue

Article Id: 196131

Status: Published

Updated On: 24-08-2020 07:14

Products:

CA Automic Workload Automation - Automation Engine , CA Automic One Automation , CA Automic Operations Manager , CA Automic Oracle

Issue/Introduction:

When a variable is used in a SQL, the variable intersects the message issue.

Steps to reproduce the issue

The problem happens only when we use the variable '&$CLIENT#' in the following SQL statement.

select count(*) from dbo.eh where eh_Client=&$CLIENT# and eh_status=1820 and eh_name='.FRM.RETCODE_ERROR.SCRI'

If you replace the variable '&$CLIENT#' with the actual client number (eg. 100) in the SQLI variable, it works fine.

Select count(*)
from uc4.eh
where eh_Client=100
and eh_status=1820
and eh_name='.FRM.RETCODE_ERROR.SCRI'

Environment:

Automic Engine 12.3.x

Resolution:

This is a bug and it will be fixed in a future release