search cancel

DB Change Utility "ucybchng" deletes script lines if SCRIPT rule old & new values blank

book

Article ID: 85089

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine

Issue/Introduction

Error Message :
N/A

The DB Change Utility, ucybchng, deletes script lines contained in objects if the Change script contains a rule with blank values:
 
REPLACE_PART *, *, SCRIPT, '', ''

Investigation

Run a DB change script that contains this line:

 
REPLACE_PART *, *, SCRIPT, '', ''

Results

Expected: Objects that contain script in their 'Pre-process', 'Process', 'Post-process' tabs should be left untouched.

Actual: Script contained in the objects are deleted:

 
20170727/154012.074 - Old line:F004M000000012:PRINT "Hello"
20170727/154012.075 - New line:F004M000000000
20170727/154012.076 - U00021427 REPLACE_PART 'SCRI', 'SCRI.INC00136254', 'SCRIPT', '', ''
20170727/154012.078 - U00021555



 

Environment

OS Version: N/A

Cause

Cause type:
Defect
Root Cause: The Change utility crashes when old values are blank in the Change script.

Resolution

Upgrade the Automation Engine to one of the fixed version or the newest build version available in the Download Center.

Fix Status: Released

Fix Version(s):
Component: AE Server

Automation Engine 12.1 - Available
Automation Engine 12.0 - Available
Automation Engine 11.2 - Available

Additional Information

Workaround :
Do not use a DB Change Script that contains rules for which the source (old) value is blank.