DB Agent reports "Error processing request"

Products

• Autosys Workload Automation

Issue/Introduction

The job:

insert_job: powerbi_case-aging    job_type: sql
description: This job will pull the case aging information from DE reporting database and push it to shared folder "\\UNCShare\folder1234545\innerfolder";
machine: autosys-machine
owner: [email protected]
application: TestName
max_run_alarm: 0
alarm_if_fail: y
alarm_if_terminated: y
date_conditions: y
days_of_week: su,mo,tu,we,th,fr,sa
start_times: "08:00"
send_notification: n
connect_string: "jdbc:sqlserver://SQLServerHostname:1433;DatabaseName=AEDB"
sql_command: SELECT CASEID, CASEITEM FROM CASEITEMS WHERE DATEOPENED IS NOT NULL;
destination_file: //UNCShare/folder1234545/innerfolder/powerbi_aging-$${DATE_CCYYMMDD}.csv

WCC > Job Details > Agent Status:

Error processing request

Plugin_log_database reports:

08/23/2021 08:00:01.032-0400 1 DatabasePlugin.database Internal Thread.CybRMIExternalPluginBaseManager.processWob[:632] - java.lang.NoClassDefFoundError: Could not initialize class java.sql.DriverManager
                                                                                                                           at cybermation.plugins.database.DbConnection.connectToDb(DbConnection.java:171)
                                                                                                                           at cybermation.plugins.database.DbConnection.<init>(DbConnection.java:111)
                                                                                                                           at cybermation.plugins.database.DbConnectionPool.getConnection(DbConnectionPool.java:129)
                                                                                                                           at cybermation.plugins.database.sql.SqlJobHandler.<init>(SqlJobHandler.java:97)
                                                                                                                           at cybermation.plugins.database.wobhandler.CybWOBRunSqlHandler.processWob(CybWOBRunSqlHandler.java:66)
                                                                                                                           at cybermation.plugins.library.base.CybRMIExternalPluginBaseManager.processWob(CybRMIExternalPluginBaseManager.java:628)
                                                                                                                           at cybermation.plugins.library.base.CybRMIExternalPluginBaseManager.run(CybRMIExternalPluginBaseManager.java:461)
                                                                                                                           at java.lang.Thread.run(Thread.java:748)

Environment

Release : 11.3.6

Component : CA Workload Automation Database Agent

Resolution

Multiple versions of SQL DB driver were installed under the agent. Thus causing DB plugin to not function as exepcted.

java.class.path=.;jars/agent.jar;jars/database.jar;jars/installer.jar;jars/js.jar;jars/snmpagent.jar;jars/ext/auth;jars/ext/axis-ant.jar;jars/ext/axis-schema.jar;jars/ext/axis.jar;jars/ext/bcprov-ext-jdk15on.jar;jars/ext/commons-codec.jar;jars/ext/commons-discovery-0.2.jar;jars/ext/commons-discovery.jar;jars/ext/commons-httpclient.jar;jars/ext/commons-logging.jar;jars/ext/ireasoningsnmp.jar;jars/ext/jaxrpc.jar;jars/ext/mssql-jdbc-7.4.1.jre11-shaded.jar;jars/ext/mssql-jdbc-7.4.1.jre11.jar;jars/ext/mssql-jdbc-7.4.1.jre12-shaded.jar;jars/ext/mssql-jdbc-7.4.1.jre12.jar;jars/ext/mssql-jdbc-7.4.1.jre8-shaded.jar;jars/ext/mssql-jdbc-7.4.1.jre8.jar;jars/ext/ojdbc8.jar;jars/ext/saaj.jar;jars/ext/security;jars/ext/sinetfactory.jar;jars/ext/wsdl4j-1.5.1.jar;jars/ext/wsdl4j.jar;jars/ext/xa;

Remove all of the mssql-jdbc* drivers except for the mssql-jdbc-7.4.1.jre8.jar.