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"

Document ID : KB000019542
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

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.

Problem:

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)

D:\CA\Installers\NFA9.1.3\DVD05123045M_NFA_Console_9.1.3>

Solution:

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.