DB change deletes Promptset default values

Document ID : KB000084624
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
Error Message :
N/A

After running DB change against a transport file and loading it, default values of Promptsets within the task's properties are lost.

Investigation
  • PRPT.ORI.TEST contains a text field - left blank in the original object
  • JOBP.ORI.CHILD uses PRPT.ORI.TEST
  • JOBP.ORI.CHILD is nested in JOBP.ORI.PARENT
  • Within the properties of JOBP.ORI.CHILD inside of JOBP.ORI.PARENT > Promptset and Variable tabs, content of text field is set to 'TEST'
  • Then the objects are exported with Transport case + DB Unload and modified with the script below:
REPLACE_PART *, *, TASK_NAME, '.ORI.', '.DEST.'
REPLACE_PART *, *, OBJECT_NAME, '.ORI.', '.DEST.'
REPLACE_PART *, *, OBJECT_USE, '.ORI.', '.DEST.'
  • After loading the modified transport file the text field is empty.
Environment:
OS Version: N/A
Cause:
Cause type:
Defect
Root Cause: Change Utility deletes default value of a promptset object.
This problem happens when the attribute OBJECT_USE is used in the DB Change script file: REPLACE_PART *, *, OBJECT_USE, 'SOME_OLD_TEXT', 'SOME_NEW_TEXT'
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.1 - Available
Automation Engine 12.0.4 - Available
Automation Engine 11.2.6 - Available
Additional Information:
Workaround :
N/A