DB_SERVICE agent crashes periodically with spacejava.lang.OutOfMemoryError error

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

Error Message :
java.lang.OutOfMemoryError: Java heap space at java.util.Arrays.copyOf(Unknown Source)

A problem has been fixed where the SQL Agent aborts due to running out of memory. This happens when parameter LOG_TO_DATABASE in variable UC_HOSTCHAR_DEFAULT is set to 'N'.

Periodically, the SQL Agent will crash showing:

java.lang.OutOfMemoryError: Java heap space

at java.util.Arrays.copyOf(Unknown Source)
at java.lang.AbstractStringBuilder.expandCapacity(Unknown Source)
at java.lang.AbstractStringBuilder.expandCapacity(Unknown Source) at java.lang.AbstractStringBuilder.append(Unknown Source)

at java.lang.StringBuilder.append(Unknown Source)
at java.lang.StringBuilder.append(Unknown Source)

Increasing the heap space available only lengthens the time between crashes. 

Environment

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

Cause

Cause type:
Defect
Root Cause: Refer to description

Resolution

This field was added on 30/03/2017. This article has not been updated yet. Refer to the "Description" or "Workaround" sections for solution information.

Fix Status: Released

Fix Version(s):
Agent SQL 11.2.2 of Automation Engine - Already Released
Agent SQL 11.1.3 of Automation Engine - Already Released
Agent SQL 10.0.8 of Automation Engine - Already Released

Additional Information

Workaround :
A,) Setup an Automatic Restart of Agentor B.) Set parameter LOG_TO_DATABASE in variable UC_HOSTCHAR_DEFAULT to 'Y'