DB Change does not change the connection object inside a SQL job.
search cancel

DB Change does not change the connection object inside a SQL job.

book

Article ID: 220375

calendar_today

Updated On:

Products

CA Automic One Automation CA Automic Workload Automation - Automation Engine

Issue/Introduction

DB Change does not change the connection object inside a SQL job. The following error message is shown:

20210722/221355.482 - U00021412 Input script:
20210722/221355.482 - U00021411 Line '001': 'REPLACE JOBS, JOBS.SQL.COMMUNITY, CONNECTION, "CONN.SQL.COMMUNITY.ORIGINAL", "CONN.SQL.COMMUNITY.CHANGE"'
20210722/221355.482 - U00021401 Syntax error in line '1'.
20210722/221355.482 - U00021406 Program UCYBchng aborted.

Environment

Release : 12.3

Component : AUTOMATION ENGINE

Cause

Defect.

Resolution

Update to a fix version listed below or a newer version if available.

Component: Automation Engine 21.0.3 - available

Component: Automation Engine 12.3.9