DB Stored Procedure job goes in Suberror and completes on resubmit
Article ID: 5913
Updated On:
Products
Issue/Introduction
DB Stored Procedure job goes in SUBERROR and completes on resubmit
Environment
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
Feedback
