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

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

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.

Cause

To be filled

Environment

AE 12.1.1
SQL Agent v12.1.1

Resolution

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

AE-17356