When running the NFA console tool prior to upgrading RA 9.0.161 to NFA 9.1.X the Console Tool command line output shows "OutOfMemoryError: Java heap space error"
search cancel

When running the NFA console tool prior to upgrading RA 9.0.161 to NFA 9.1.X the Console Tool command line output shows "OutOfMemoryError: Java heap space error"


Article ID: 19542


Updated On:


CA Application Delivery Analysis MTP (NetQoS / ADA) CA Infrastructure Performance



When upgrading from RA 9.0.161 to NFA 9.1.3 it is highly recommended to not double click on the console tool executable.

It is recommended to open a command prompt from the directory the console tool is located and run in from command line using this command: "java -jar consoletool-exe.jar"

The reason we do this is there is a chance that an error may occur that the notepad output text file may not show.

This document will explain what to do if you run the console tool from command line and see this error in the command prompt. This error would not appear in the text file output.


10:50:14 AM - [ALWAYS  ] - Inserting 102836 rows into the console_interfaces table on Harvester at address 10.X.X.X
java.sql.SQLException: java.lang.OutOfMemoryError: Java heap space
       at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1075)
       at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:989)
       at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:984)
       at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:929)
       at com.mysql.jdbc.Util.handleNewInstance(Util.java:433)
       at com.mysql.jdbc.PreparedStatement.getInstance(PreparedStatement.java:874)
       at com.mysql.jdbc.ConnectionImpl.clientPrepareStatement(ConnectionImpl.java:1478)
       at com.mysql.jdbc.ConnectionImpl.prepareStatement(ConnectionImpl.java:4204)
       at com.mysql.jdbc.ConnectionImpl.prepareStatement(ConnectionImpl.java:4103)
Exception in thread "main" java.lang.OutOfMemoryError: Java heap space
       at java.util.Arrays.copyOf(Unknown Source)
       at java.util.Arrays.copyOf(Unknown Source)
       at java.util.ArrayList.ensureCapacity(Unknown Source)
       at java.util.ArrayList.add(Unknown Source)
       at com.mysql.jdbc.ConnectionImpl.closeAllOpenStatements(ConnectionImpl.java:1563)
       at com.mysql.jdbc.ConnectionImpl.realClose(ConnectionImpl.java:4315)
       at com.mysql.jdbc.ConnectionImpl.close(ConnectionImpl.java:1544)
       at com.ca.im.ra.MigrationTo912Tool.ConsoleInfoToPollerTool.createRemoteReporterDatabaseInHarvester(ConsoleInfoToPollerTool.java:666)
       at com.ca.im.ra.MigrationTo912Tool.ConsoleInfoToPollerTool.getAndPushTheDBInfo(ConsoleInfoToPollerTool.java:139)
       at com.ca.im.ra.MigrationTo912Tool.ConsoleInfoToPollerTool.main(ConsoleInfoToPollerTool.java:337)



Specify heap memory parameters in the command prompt:

java -jar -Xms1024m -Xmx1024m consoletool-exe.jar

If you get this error:
Exception in thread "main" java.lang.NoClassDefFoundError: ├╗jar
It is because you copied and pasted the command. Make sure to manually type the command in the prompt.


Release: RAIB1H99000-9.1-Network Flow Analysis-Interface Bundle-Hardware