SQL Job failing with ClassNotFoundeException
Article ID: 193325
Updated On:
Products
CA Automic Workload Automation - Automation Engine
CA Automic One Automation
CA Automic Operations Manager
CA Automic Oracle
Issue/Introduction
The SQL job is failing with the below error message in the SQL agent's log.
2020-06-15 06:41:00 - U02000005 Job 'SQLJOBTEST' with RunID '79222153' started.
2020-06-15 06:41:00 - U02012031 The database driver returned the following error message:
2020-06-15 06:41:00 java.lang.ClassNotFoundException: com.sap.db.jdbc.Driver
2020-06-15 06:41:00 - U02004025 Job-script execution was aborted.
Cause
The jdbc driver is missing in the jdbc folder of the SQL agent.
Environment
Release : 12.x
Component : AUTOMATION ENGINE, SQL Agent
Resolution
Please check if the jdbc driver is present as explained in the documentation below. Also, make sure the user has proper permissions in the jdbc folder.
Feedback
Yes
No
Powered by
