DB Change Utility "ucybchng" does not change contents of pre-process tab of JOB Script

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

Error Message :
N/A

The DB change utility, ucybchng, does not change the contents of the pre-process tab of a JOB Script.

Investigation

Script:

REPLACE_PART *, *ETL.DWMSSS*, SCRIPT, 'GAS1', 'GAS_PROD'
 

Before change:
:SET &USER# = GET_LOGIN(&LOGIN#,GAS1,GAS1,LOGIN_INFO) :SET &PASSWD# = GET_LOGIN(&LOGIN#,GAS1,GAS1,PASSWORD)

After change:
:SET &USER# = GET_LOGIN(&LOGIN#,GAS1,GAS1,LOGIN_INFO) :SET &PASSWD# = GET_LOGIN(&LOGIN#,GAS1,GAS1,PASSWORD)

The same script works on the process tab of a JOBI.

Environment

OS Version: N/A

Cause

Cause type:
Other
Root Cause: When using the DB change utility you must distinguish which tab the Automic script is on that you want to change in the transport case.

Resolution

When using the DB Change Utility, you need to distinguish which tab the Automic script is on that you want to change in the transport case. Only the Process tab script is changed when SCRIPT is used in the script statement below:   REPLACE_PART *, *ETL.DWMSSS*, SCRIPT, 'GAS1', 'GAS_PROD' To replace the script on the Pre-Process and Post-Process tabs, the PSCRIPT and OSCRIPT attributes must be used. So to make a change on the Pre-Process tab, you would use the following: REPLACE_PART *, *ETL.DWMSSS*, PSCRIPT, 'GAS1', 'GAS_PROD'

Fix Status: No Fix

Fix Version(s):
N/A

Additional Information

Workaround :
N/A