Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.
Originally posted by: dhrobertsonhi all,
our client has created an SAP BAPI to return the contents of table RESB in SAP. the BAPI limits records from 01.01.2015 and the total number of records is around 2,500,000. I tested it in their test environment first and it worked perfectly. I have now got them to move it into Production. there is obviously more data in prod but 2.5 mill rows shouldn't be a problem. when I run the ERP connector in prod it runs for a minute or so and then falls over with
"Unexpected error occurred during processAll while running the node: Java heap space."
I dug around in the forum and found a post by Tim regarding adding a line to site.prop, which should increase the memory available for java nodes. I made it 4Gb
ls.brain.server.javaMaxHeapSize=4096M
it still falls over though with the same error. currently running the graph through the BRE so not sure if it picks up this site.prop file or not.
is there anything I can do to try and fix this error? why would it run ok in dev (granted it only pulled back 353 rows) but fail in prod?
thanks
douglas
ps. the java error is this:
javaExceptionDetail: java.lang.OutOfMemoryError: 'Java heap space';
stack trace:
com.sap.conn.rfc.driver.CpicDriver.rflush(CpicDriv er.java@325)
com.sap.conn.rfc.engine.RfcIoOpenCntl.ab_rfcflush( RfcIoOpenCntl.java@889)
com.sap.conn.rfc.engine.RfcIoOpenCntl.ab_rfcwrite( RfcIoOpenCntl.java@762)
com.sap.conn.rfc.engine.RfcPut.ab_rfcput(RfcPut.ja va@111)
com.sap.conn.rfc.engine.RfcCall.RfcCallNew(RfcCall .java@161)
com.sap.conn.rfc.engine.RfcCall.ab_rfccxt2(RfcCall .java@199)
com.sap.conn.rfc.engine.RfcIoOpenCntl.RfcCall(RfcI oOpenCntl.java@1956)
com.sap.conn.rfc.engine.RfcIoOpenCntl.RfcCallRecei ve(RfcIoOpenCntl.java@2120)
com.sap.conn.jco.rt.MiddlewareJavaRfc$JavaRfcClien t.reset(MiddlewareJavaRfc.java@1526)
com.sap.conn.jco.rt.ClientConnection.internalReset (ClientConnection.java@544)
com.sap.conn.jco.rt.PoolingFactory.releaseClient(P oolingFactory.java@682)
com.sap.conn.jco.rt.ConnectionManager.releaseClien t(ConnectionManager.java@234)
com.sap.conn.jco.rt.Context.endSequence(Context.ja va@490)
com.sap.conn.jco.rt.JCoRuntime.endSequence(JCoRunt ime.java@778)
com.sap.conn.jco.JCoContext.end(JCoContext.java@97 )
com.lavastorm.brain.node.erp.sapconnector.JCoAdapt er.executeFunction(JCoAdapter.java@226)
com.lavastorm.brain.node.erp.sapconnector.JCoAdapt er.executeFunction(JCoAdapter.java@154)
com.lavastorm.brain.node.erp.sapconnector.SapConne ctor.processFunction(SapConnector.java@779)
com.lavastorm.brain.node.erp.sapconnector.SapConne ctor.processSingle(SapConnector.java@136)
com.lavastorm.brain.node.erp.sapconnector.SapConne ctor.processAll(SapConnector.java@125)
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)