LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: Nithya Priya

I am running a JDBC query node to query data in MS Access db. I get the error saying "Unexpected error occurred during processAll while running the node: GC overhead limit exceeded"
Error code: brain.unexpectedNodeErrorDuring

What does this error means?

javaExceptionDetail: java.lang.OutOfMemoryError: 'GC overhead limit exceeded';
stack trace:
org.hsqldb.result.Result.newBatchedExecuteResponse ()
org.hsqldb.Session.executeCompiledBatchStatement()
org.hsqldb.Session.execute()
org.hsqldb.jdbc.JDBCPreparedStatement.executeBatch ()
net.ucanaccess.converters.LoadJet$TablesLoader.loa dTableData(LoadJet.java@845)
net.ucanaccess.converters.LoadJet$TablesLoader.loa dTablesData(LoadJet.java@1003)
net.ucanaccess.converters.LoadJet$TablesLoader.loa dTables(LoadJet.java@1047)
net.ucanaccess.converters.LoadJet$TablesLoader.acc ess$3(LoadJet.java@1041)
net.ucanaccess.converters.LoadJet.loadDB(LoadJet.j ava@1556)
net.ucanaccess.jdbc.UcanaccessDriver.connect(Ucana ccessDriver.java@245)
java.sql.DriverManager.getConnection(DriverManager .java@571)
java.sql.DriverManager.getConnection(DriverManager .java@215)
com.lavastorm.brain.nodes.old.jdbc.JdbcNode.connec tToDB(JdbcNode.java@184)
com.lavastorm.brain.nodes.jdbc.old.JdbcExecute.pro cessAll(JdbcExecute.java@77)
com.lavastorm.brain.execution.java.node.NodeWrappe r.nodeProcess(NodeWrapper.java@553)
com.lavastorm.brain.execution.java.node.NodeWrappe r.run(NodeWrapper.java@797)
com.lavastorm.brain.execution.java.node.NodeWrappe r.main(NodeWrapper.java@1534)

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: awilliams1024

Hi,

Googling for UCanAccess java.lang.OutOfMemoryError: 'GC overhead limit exceeded' turns up quite a few hits that indicate it is an issue that relates to the Java Garbage Collection functionality. The consensus is that you should increase your java heap space. Changing the Java heap space is discussed in the LAE Server installation guide (page 29):

http://installers.lavastorm.com/Docu...on%20Guide.pdf

Regards,
Adrian

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: Nithya Priya

Thank you Andrian! .