DB Change Utility fails to change Conditions of Workflows

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

DB Change Utility does not update Conditions of tasks nested in a Workflow in the following versions:
  • 11.2.4
  • 11.2.5
  • 12.0.1
  • 12.0.2

Investigation

'MY_WORKFLOW_1' contains a task whose [Pre/Post]conditions require the use of 'AGENT1':
0EMb0000001UyWk.png

This script line is used to replace 'AGENT1' with 'AGENT2' in task conditions:
 
"REPLACE_PART *, *, OBJECT_USE, 'AGENT1', 'AGENT2'"

Results

Expected: 'AGENT1' should be replaced with 'AGENT2' in 'MY_WORKFLOW_1':

 
20170721/113339.570 - U00021427 REPLACE_PART 'JOBP', 'MY_WORKFLOW_1', 'OBJECT_USE', 'AGENT1', 'AGENT2'
 
Actual: Nothing happens.
Environment:
OS Version: N/A
Cause:
Cause type:
Defect
Root Cause: Changes introduced in version 11.2.4 and 12.0.1 of the DB change utility (ucybchng) are preventing changes from being made in task conditions of a Workflow.
Resolution:
Update to a fix version listed below or a newer version if available.

A new attribute with name 'CONDITION_PARAMETER' was introduced in the fix versions, so that the Change Utility can also alter Conditions of tasks contained within a Workflow.

Example:

Script lines that use this new attribute:

 
REPLACE JOBP, *, CONDITION_PARAMETER, 'AGENT1', 'AGENT2'
REPLACE_PART JOBP, *, CONDITION_PARAMETER, 'AGENT1', 'AGENT2'

This new attribute 'CONDITION_PARAMETER' can only be used with Workflow objects.

Fix Status: Released

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

Automation Engine 12.1.0 - Available
Automation Engine 12.0.3 - Available
Automation Engine 11.2.6 - Available
Additional Information:
Workaround :
Use a version prior to affected versions:
  • 11.2.4
  • 11.2.5
  • 12.0.1
  • 12.0.2