KB Article #67964
Heap space Java error when executing a Map-Broker SQL
Problem
Resolution
-- 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