Stored procedure job fails with WA Agent

book

Article ID: 209829

calendar_today

Updated On:

Products

CA Workload Automation DE - Business Agents (dSeries) CA Workload Automation Agent CA Workload Automation AE - Business Agents (AutoSys) CA Workload Automation DE - System Agent (dSeries)

Issue/Introduction

A stored procedure job fails with this error.  The job completes on the database side.  The agent returns the following error.

  
java.sql.SQLException: Output parameters have not yet been processed. Call getMoreResults().

CLXXXX J123456, SQLException: Output parameters


Log shows these errors:

XX/XX/20201 00:00:12.345-0500 1 DatabasePlugin.Thread-8.DbprocJobHandler.run[:156] - java.sql.SQLException: Output parameters have not yet been processed. Call getMoreResults().

 

 

Cause

The WA Agent is using jTDS driver.

Environment

Release : 11.4

Component : CA WORKLOAD AUTOMATION DATABASE AGENT 

Resolution

Change the jTDS driver to MS SQL driver.

1. Stop the agent.

2. Download SQL JDBC driver from Microsoft 

3. Remove jTDS driver from <agen_install>/jars/ext.  E.g C:\CA\WA Agent\jars\ext\jtds-1.3.1.jar

Note: Remove the jar, do not rename.  If file is not in jars\ext then check jars.

4. Add the SQL JDBC jar to Agent jars\ext directory.  E.g. C:\CA\WA Agent\jars\ext\sqljdbc42.jar

Note: Files may not be removed in Windows unless the agent has been stopped.

5. Edit agentparm.txt to reflect the changes.  Change db.default.url property.  E.g.

jdbc:sqlserver://dbhost:1433;databaseName=corpDB

6. Restart agent.

 

For Linux/UNIX users, same above steps apply.  Change the agent install directory to appropriate location.  

E.g.

/opt/CA/WA_Agent

or

/opt/CA/WorkloadAutomationAE/SystemAgent/WA_Agent