search cancel

DB Stored Procedure job goes in Suberror and completes on resubmit


Article ID: 5913


Updated On:


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


DB Stored Procedure job goes in SUBERROR and completes on resubmit


CA Workload Automation Database Agent MS-SQL Server


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


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


(0 - disables DB connection pooling)


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