DB Change unable to alter the same Attribute more than once

Document ID : KB000084942
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
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.