DB Stored Procedure job goes in Suberror and completes on resubmit

Document ID : KB000005913
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

DB Stored Procedure job goes in SUBERROR and completes on resubmit

Environment:
CA Workload Automation Database Agent MS-SQL Server
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(). 

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