GENERATE_SCRIPT_VARS with Variables names that are too long in Oracle crashes the System

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

When GENERATE_SCRIPT_VARS is used on VARA key field that exceeds 32 characters and the underlying AE database is Oracle, the WP crash.
:SET &RET# = GENERATE_SCRIPT_VARS("VARA.SCRIPT_VARS", APPEND_POUND_SIGN, UPDATE)

Restarting without a COLDSTART of the WPs also make them crash again.


The generated DUMP starts with :

===============================================================================

20210629/141514.564 - Signal 11 (SEGV) at 0x69 with code 1
20210629/141514.564 - U00009909 TRACE: (Parameter List)                            0x7ffdbe59b9f0 001296
                00000000 25255352 30310400 00000000 20202020 >%%SR01......  <
                00000010= 20202020 20202020 20202020 20202020 >        <
                00000400 20202020 20202020 20202020 00000100 >      ....<

===============================================================================

In the PWP log similar to this can be found :

==============================================================================

20210629/141516.099 - U00003407 Client connection '8(16)' from '[AUTOMIC_SERVER_IP]:52684' has logged off from the Server.
20210629/141516.139 - U00015006 System forced memory trace dump.
20210629/141516.140 - U00015006 System forced memory trace dump.
20210629/141516.141 -     Server     Typ C Host           Port      StartTime   LastUpdateTime
20210629/141516.141 -     -------------- --- - ----------------------- ----- ------------------- -------------------
20210629/141516.141 -     RO1232#CP001  JCP 1 [AUTOMIC_SERVER]      2417 2021-06-15 07:21:44 2021-06-29 14:15:12
.....
20210629/141516.141 -     RO1232#WP013  WP 1 [AUTOMIC_SERVER_FQDN]   0 2021-06-29 14:06:49 2021-06-29 14:15:27
20210629/141545.165 - U00003128 Server 'RO1232#WP009' is removed from server table (MQSRV). Reason 'dead/timeout(600 secs)'.
20210629/141622.378 - U00003406 Client connection '19(17)' from '[[AUTOMIC_SERVER_IP]]:44419' has logged on to the Server.
20210629/141622.383 - U00003489 Server 'RO1232#WP009' logged on (Client connection='19').
20210629/142555.726 - U00003128 Server 'RO1232#WP008' is removed from server table (MQSRV). Reason 'dead/timeout(600 secs)'

==============================================================================

In the Service Manager Log file:

==============================================================================

20210629/141516.095 - U00022012 Process 'UC4 WP4/UC4 WP-Server [RO1232#WP008] - 7 Connections' (ID '171214') ended.
20210629/141516.095 - U00022022 Process 'UC4 WP4/UC4 WP-Server [RO1232#WP008] - 7 Connections' ended, exit code='0(6)'.
20210629/141516.101 - U00022038 Service 'UC4 WP4' automatically starts in '60' seconds.
20210629/141616.267 - U00022004 Starting process 'UC4 WP4' ...
20210629/141616.267 - U00022005 ... with command line '/uc4/RO1232/ServiceManager/bin/../../AutomationEngine/bin/ucsrvwp -I/uc4/RO1232/ServiceManager/bin/../../AutomationEngine/bin/ucsrv.ini -svc0x10e4dd0ort'.

==============================================================================

With AE in Windows and DB in MSSQL server, the error does not happen and the script finishes OK.

 

Environment

Was detected in Release : 12.3.4  Component : AUTOMATION ENGINE with Oracle Database

Cause

This is a bug in the  GENERATE_SCRIPT_VARS script function that causes WP to crash if the variable name is too long and exceeds the maximum length of 32 bytes.

Resolution

Correction of this issue is available in versions:

AE 12.3.7

AE 21.0 

The product has been updated to include a message stating that the variable name exceeds the maximum length:

Message-Text (E): Runtime error in object '&01', line '&02'. The variable name: '&04' ('&05' character) exceeds the maximum length of 32 byte.