Sap agent crash when downloading large spool size

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

Spool is downloaded and page break also working fine for small spool files but the agent crashes when downloading large spool.

 

Environment

Release : 12.3.3

Sap agent 12.3.5 /HP_UX 

Component : AUTOMATION ENGINE

Resolution

Can see below error message in agent logs

Java.lang.OutOfMemoryError: Java heap space at com.sap.conn.jco.rt.DefaultTable.initializeRow(DefaultTable.java:234)

From the heap it is clear that the available memory is not enough as the issue is not within Automic java part - > com.sap.conn.jco.rt < - the needed memory for the SAP (sapjco.jar) is not enough 

Following JCL caused the out of memory:

R3_GET_JOB_SPOOL FILE=,MAXLINES=9999999,SPOOLNR=0000493921
So look at this spool within SAP for the size - but the HEAP shows:
1181567 lines with 1024 byte => 1,13GB of memory the SAP part needs - now this data is converted to UNICODE by SAP - 

So  need now up to 2-4 times the size in memory depends on how many multiple byte characters are contained,...

1,13x2 = 2,26GB and this is much more than 1,92GB available!

20210222/151254.011 - U02000110 Maximum Heap Memory: '1963' MB

Must increase the memory for the SAP agent at least to 4-8GB - that such a big spool has enough memory within the SAPJCO interface.

The memory must be adjusted for the agent so big spools fit into memory in environment.