ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

The query will fail when you click on the Agent Name in the Form tab of the SQL job


Article ID: 109476


Updated On:


CA Automic Workload Automation - Automation Engine


Connection tests of SQL Jobs fail when database information (host and db name) is entered in the Job and a Login object is used.
The Job itself runs without errors, and the this issue does not occur when an SQL Connection object is used. Connection tests now run correctly.

Error message:

Connection test failed - 2018-05-02 20:26:20 - U02012031 The database driver returned the following error message:
2018-05-02 20:26:20 ORA-01017: invalid username/password; logon denied
2018-05-02 20:26:20 - U02004025 Job-script execution was aborted.


To be filled


AE 12.1.1
SQL Agent v12.1.1


Recognized as a bug and fixed in following releases:
  • Automation Engine 12.1.3
  • Automation Engine 12.2.1
  • Automation Engine 12.3.0 (planned release: 28th Jun 2019)

Additional Information