Job Failure with Upgraded Agent

Products

• CA Workload Automation AE - Business Agents (AutoSys)
• CA Workload Automation AE - System Agent (AutoSys)
• CA Workload Automation AE - Scheduler (AutoSys)
• 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, 12.0

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....