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