DB Stored Procedure job goes in Suberror and completes on resubmit

book

Article ID: 5913

calendar_today

Updated On:

Products

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

Issue/Introduction

DB Stored Procedure job goes in SUBERROR and completes on resubmit

Cause

The Database Plugin attempts to check if the pooled connection is still valid using isValid() method specified by JDBC 4.0. 

It checks if the method exists and is not abstract. 

 

Initial jTDS driver did not support the isValid() method in which case agent detected that appropriately and never attempts to call the 'isValid()' method. However, in later version (1.3.0 and above), jTDS seem to have added the public method and simply throws AbstractMethodError(). 

Environment

CA Workload Automation Database Agent MS-SQL Server

Resolution

The following two steps will allow to run Stored Procedure jobs without going in to SUBERROR first.

 

1. Disable the connection pool.

Add the following parameter in agentparm.txt

db.connectionPool.maxSize=0

(0 - disables DB connection pooling)

 

2. Use an older version of jTDS driver version such as 1.2.6 and 1.2.8