DB_SERVICE agent crashes periodically with spacejava.lang.OutOfMemoryError error

Document ID : KB000088124
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
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. 
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'