SQL Jobs failed with "Error Processing request"

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

The following DBPROC job failed with <Error processing request>.

/* ----------------- BRZCRK_UAT_DBPRC_TEST ----------------- */

insert_job: BRZCRK_UAT_DBPRC_TEST   job_type: DBPROC
machine: <machine name>
owner: [email protected]
permission:
date_conditions: 0
days_of_week: all
start_mins: 00,03,06,09,12,15,18,21,24,27,30,33,36,39,42,45,48,51,54,57
alarm_if_fail: 1
alarm_if_terminated: 1
application: SQL
connect_string: "jdbc:sqlserver://<MSSQL Server Host>:15001:DatabaseName=<DB Name>"
sp_name: dbo.spb_sp_consulta_st_devolucao
sp_arg: argtype=IN,datatype=VARCHAR,ignore=0,name=nr_ctrl_if,value="STR20200804033000415"
sp_arg: argtype=OUT,datatype=VARCHAR,ignore=0,name=status

Environment

Release : 11.3.6

Component : CA Workload Automation AE (AutoSys)

Resolution

Only JDBC for JR8 will work with WA Agent (from 11.5 to R12.1).  Multiple JDBC jars must not be present in <Agent Install Directory>\jar\ext.  

E.g If mssql-jdbc-7.2.1.jre8.jar and mssql-jdbc-7.2.1.jre11.jar are present, then remove mssql-jdbc-7.2.1.jre11.jar (do not rename, physically remove or delete the file).