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.

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

book

Article ID: 88196

calendar_today

Updated On:

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.

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.

Environment

OS Version: N/A

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