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

Article Id: 109476
Status: Published
Updated On: 21-02-2019 03:54
Products:
CA Automic Workload Automation - Automation Engine , AUTOMIC WORKLOAD AUTOMATION
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