Job Failure with Upgraded Agent

book

Article ID: 193838

calendar_today

Updated On:

Products

CA Workload Automation AE - Business Agents (AutoSys) CA Workload Automation AE - System Agent (AutoSys) CA Workload Automation AE - Scheduler (AutoSys) CA Workload Automation Agent CA Workload Automation AE

Issue/Introduction

SQL Server job fails with the following information:

Agent Status Long: "Possible SQL injection detected in Table Validation UPDATE - PRD"
Agent Status:         "Failed to get PS job data."


Environment

Release : 11.5

Component : CA Workload Automation Agent for SQL Server

Resolution

Due to a code change designed to prevent SQL injection from occurring. Data that contains the following words corresponding to SQL keywords will be rejected: SELECT, INSERT, UPDATE, DROP, RENAME, CREATE, DELETE, GRANT, REVOKE, and WHERE.

Workaround:
When using these keywords in email subject with SQL jobs, shorten the keywords. Perhaps something like the following will suffice:

UPD for UPDATE
INS for INSERT
DR for DROP
REN for RENAME
CRE for CREATE
DEL for DELETE
GRA for GRANT
REV for REVOKE

etc....