DB Job throws U02012000 Agent DB-Type 'TYPE' doesn't match Connection DB-Type 'TYPE'.

Products

• CA Automic Workload Automation - Automation Engine
• CA Automic One Automation

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.

 

Additionally, an error like: 

U02012000 Agent DB-Type 'MSSQL' doesn't match Connection DB-Type  'ORACLE'.

might show

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=" to the correct value 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/Automic%20Automation%20Guides/Content/AWA/Admin/inifiles/admin_ini_agent_sql.htm