KB Article #67964

Heap space Java error when executing a Map-Broker SQL

Problem

-- During the execution of a "Insert" Map-Broker SQL, the below error is encountered if the numer of lines to insert is bigger than 5000.
ERROR  :date:time:procengine(procengine(hierchmsgenv)):[MON - 1018]: Error during JDBC MapBroker (name of MB) execution
DEBUG  :date:time:procengine(procengine(hierchmsgenv)):[JDX - 17021]: Add batch failed
ERROR  :date:time:procengine(procengine(hierchmsgenv)):[JDB - 18001]: Java heap space


Resolution

* Edit the file $CORE_LOCAL/config/java/jvm.cfg and add the line below:
UNIX:Append== -Xmx==512m
* Stop the tasks
* Restart the tasks