JWP Memory dumps

Products

• CA Automic Workload Automation - Automation Engine
• AUTOMIC WORKLOAD AUTOMATION

Issue/Introduction

On regular basis JWP memory dumps are created in the form of trace files in the "temp" directory of the AE.

The WP logs shows messages like:
U00009907 Memory dump '(BINDPAR: 1)' (Address='n/a', Length='000008') 
00000000 00000167 CDAD29E8 >...gͭ)輊20181220/231324.103 - 24 >2018-12-20 22:12:17.0< 
U00009907 Memory dump '(BINDPAR: 2)' (Address='n/a', Length='000008') 
00000000 00000167 CDAD29E8 >...gͭ)輊20181220/231324.105 - 24 >2018-12-20 22:12:17.0< 

Cause

This happens when 2 conditions are met:

1. UC_SYSTEM_SETTINGS > SERVER_OPTIONS is set to 'NNNNNNNNNNxNNNNN'. The number in the 11th position of SERVER_OPTIONS indicates that the bind parameter of all DB queries that are longer than x seconds will be logged
2. The following query take more than x seconds:

U00003525 UCUDB: ===> 'SELECT OH_Idnr, OH_Client, COALESCE(OH_Moddate, OH_CrDate) AS OH_ModDate, OH_OType from OH WHERE (OH_ModDate > ? OR OH_CrDate > ?) AND OH_DeleteFlag = 0' 

Environment

Release: AUTWAB99000-12.0-Automic Workload Automation-Base Edition
Component:

Resolution

Workaround:
Set the 11th position of UC_SYSTEM_SETTINGS > SERVER_OPTIONS to N

Solution:
Install v12.2 or higher.
In v12.2 an additional index has been added to reduce the duration of the query above