DB Change unable to alter the same Attribute more than once

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

Error Message :
N/A

If the script file executed by DB change contains several rules that affect the same attribute, only the last applied change will take effect.

Investigation

Example:

A transport file contains an object named 'MY_WINDOWS_JOB.WIN01.DEV' used in other objects, and the script contains the 2 rules below:

REPLACE_PART *, *, OBJECT_USE, '.DEV', '.PROD'
REPLACE_PART *, *, OBJECT_USE, '.WIN01.', '.WIN02.'

Results

Expected:  The 'OBJECT_USE' is affected twice, so:

• 'MY_WINDOWS_JOB.WIN01.DEV' should be changed to 'MY_WINDOWS_JOB.WIN01.PROD'
• then 'MY_WINDOWS_JOB.WIN01.PROD' should be changed to 'MY_WINDOWS_JOB.WIN02.PROD'

Actual:  Upon running DB change, the first rule changes correctly from  'MY_WINDOWS_JOB.WIN01.DEV' to 'MY_WINDOWS_JOB.WIN01.PROD', but  the 2nd rule is run instead of changing 'MY_WINDOWS_JOB.WIN01.PROD' to ''MY_WINDOWS_JOB.WIN02.PROD' it changes it as shown below to 'MY_WINDOWS_JOB.WIN02.DEV':

20170628/225858.302 - U00021555 ---------------------------------------------------------------------------------------
20170628/225858.302 - Old line:F003CMY_WINDOWS_JOB.WIN01.DEV
20170628/225858.302 - New line:F003CMY_WINDOWS_JOB.WIN01.PROD
20170628/225858.302 - U00021427 REPLACE_PART 'JOBS', 'MY_WINDOWS_JOB.WIN01.DEV', 'OBJECT_USE', '.DEV', '.PROD'
20170628/225858.302 - U00021555 ---------------------------------------------------------------------------------------
20170628/225858.302 - Old line:F003CMY_WINDOWS_JOB.WIN01.DEV
20170628/225858.302 - New line:F003CMY_WINDOWS_JOB.WIN02.DEV
20170628/225858.302 - U00021427 REPLACE_PART 'JOBS', 'MY_WINDOWS_JOB.WIN01.DEV', 'OBJECT_USE', '.WIN01.', '.WIN02.'
20170628/225858.302 - U00021555 ---------------------------------------------------------------

 

Environment

OS Version: N/A

Cause

Cause type:
Defect
Root Cause: The DB Change utility could not change the same OBJECT_USE attribute more than once.

Resolution

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

Fix Status: Released

Fix Version(s):
Component(s) : DB Change Utility

Automation Engine 12.1.0 - Available
Automation Engine 12.0.2 - Available
Automation Engine 11.2.5 - Available

Additional Information

Workaround :
If the script file executed by DB change contains several rules that affect the same attribute, run the DB change several times with different rules.