search cancel

SQLJob and 'GENERICJDBC DB-Type Connection

book

Article ID: 243592

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine

Issue/Introduction

The database connection objects created using GENERICJDBC connection type to the Oracle RAC database. The jobs using the specific connection objects failed with the following message -

2022-06-08 10:21:59 - U02012000 Agent DB-Type 'ORACLE' doesn't match Connection DB-Type  'GENERICJDBC'.
The DB connection type ORACLE works fine. However, it does not support fully functional Oracle RAC connections.

The VARA objects using the same connection objects using GENERICJDBC run fine.

Environment

Release : 12.3, 21.0 and higher

Component :

Cause

The database agent can only take single database connection type at a time. The problem appears if the database connection objects created using different database type other than what agent is configured to accept.

Resolution

Login to the agent machine with an appropriate privileged account.

Stop the agent.

Go to agent install directory and open the agent configuration file (ucxjsqlx.ini) for edit.

Update the property "type=GENERICJDBC" and save the file.

Restart the agent 

Additional Information

Agent SQL -Structure of the INI File ucxjsqlx.ini

https://docs.automic.com/documentation/webhelp/english/ALL/components/DOCU/21.0.3/Automic%20Automation%20Guides/Content/AWA/Admin/inifiles/admin_ini_agent_sql.htm