Script with DEFINE and FILL causes WPs to loop if array larger than 32767

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

The following script applied on a simple 2-line VARA, takes days to execute and DB reports numerous 'row lock contentions':

:SET &VARA_TABLE# = "VARA_ARRAY"
:DEFINE &ARRAY1#, string, 999999
:FILL &ARRAY1#[] = GET_VAR(&VARA_TABLE#,"1")

With the value 32767 (instead of 99999) this still works but with 327678 or higher it loops.

Observations:

•  After the starting script one WP starts to consume a lot of CPU.
• After a while second, then third etc. WP start to loop
• If you wait the AE becomes unusable and a Coldstart is necessary
• If you wait longer the entire VM becomes unusable
• You can cancel the script but it takes a while.
• Even after cancelling the WP keeps consuming a lot of CP

Environment

Release : 12.3.8

Cause

This is a defect

Resolution

The fix for this issue will be available in v21.0.9