SQL agent does not send any request to MySQL database

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

When running a SQL or database job against a MySQL database, the job remains Active for a while and then fails with Error 102, Status Distant=Waiting for Database.

The firewall does not show any request being sent across the network, but using a DBService agent to check connection object throws the error below:

U02022064 Communications link failure. The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.

Setting the job report to "Add agent log" checked also returns the above U02022064in the PLOG

Environment

Release : 12.3

Component :

Resolution

MySQL version in this case was 5.6.13

The last supported version of the MySQL Connector for this MySQL version is "mysql-connector-java-8.0.12.jar".  Once this was put into the agent's /jdbc directory, the agent and jobs worked as expected.

Always make sure the MySQL Connector (jdbc driver) is compatible with MySQL database.