Issue generating a document: java.io.EOFException

RLJB

So, we've had a process that generates a document and exports it... it uses a LIST function and has worked flawlessly for years... the document contents looks like this:

Co./Last Name,Invoice #,Date,Account #,Amount,Inc-Tax Amount,Salesperson Last Name,Salesperson First Name,Tax Code,Non-GST Amount,GST Amount,Journal Memo
<<LIST('MYOBReportSundrySales','
','MYOBExport','Commas')>>

Suddenly we are getting this error below... any suggestions would be greatly appreciated:

2017-12-11 13:00:12,471 ERROR Reply#41616#SFE#8bf3222222ceed524fc7aa844c1c9ef5 -Persistence exception thrown during commit Could not prepare execution context statement No operations allowed after connection closed.Connection was implicitly closed due to underlying exception/error:

** BEGIN NESTED EXCEPTION **

com.mysql.jdbc.CommunicationsException
MESSAGE: Communications link failure due to underlying exception:

** BEGIN NESTED EXCEPTION **

java.io.EOFException

STACKTRACE:

java.io.EOFException
at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1905)
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2351)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2862)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2988-)
at com.mysql.jdbc.Statement.executeUpdate(Statement.java:935)
at com.mysql.jdbc.Statement.executeUpdate(Statement.java:873)
at com.bas.basserver.persistence.EntityIdGenerator.generateId(Unknown Source)
at com.bas.basserver.persistence.EntityDBPersister.insertEntity(Unknown Source)
at com.bas.basserver.persistence.PersistenceManager.insertEntity(Unknown Source)
at com.bas.basserver.executionengine.A.H.A(Unknown Source)
at com.bas.basserver.executionengine.A.H.execute(Unknown Source)
at com.bas.basserver.executionengine.ExecutionEngine.A(Unknown Source)
at com.bas.basserver.executionengine.ExecutionEngine.startChildProcess(Unknown Source)
at com.bas.basserver.executionengine.ExecutionEngine.A(Unknown Source)
at com.bas.basserver.executionengine.ExecutionEngine.doCreateEntity(Unknown Source)
at com.bas.basserver.executionengine.ExecutionEngine.createEntityFromTemplate(Unknown Source)
at sun.reflect.GeneratedMethodAccessor32.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498-)
at com.bas.basserver.executionengine.rliproc.C.A(Unknown Source)
at com.bas.basserver.executionengine.rliproc.C.A(Unknown Source)
at com.bas.basserver.executionengine.rliproc.F.Y(Unknown Source)
at com.bas.basserver.executionengine.rliproc.F.Z(Unknown Source)
at com.bas.basserver.executionengine.rliproc.F.P(Unknown Source)
at com.bas.basserver.executionengine.rliproc.F.M(Unknown Source)
at com.bas.basserver.executionengine.rliproc.G.A(Unknown Source)
at com.bas.basserver.executionengine.rliproc.G.C(Unknown Source)
at com.bas.basserver.executionengine.rliproc.G.T(Unknown Source)
at com.bas.basserver.executionengine.rliproc.G.B(Unknown Source)
at com.bas.basserver.executionengine.rliproc.G.A(Unknown Source)
at com.bas.basserver.executionengine.rliproc.G.resume(Unknown Source)
at com.bas.basserver.executionengine.ExecutionEngine.A(Unknown Source)
at com.bas.basserver.executionengine.ExecutionEngine.handleServiceReplyNotification(Unknown Source)
at com.bas.basserver.bsmanager.E.A(Unknown Source)
at com.bas.basserver.bsmanager.E.A(Unknown Source)
at com.bas.basserver.iopipes.ComponentSink.processMessage(Unknown Source)
at org.openadaptor.adaptor.STPipelineController.processMessage(STPipelineController.java:68-)
at com.bas.openadaptor.NonTransactionalController.processMessage(NonTransactionalController.java:136)
at org.openadaptor.adaptor.AbstractSimplePipe.processMessage(AbstractSimplePipe.java:222)
at org.openadaptor.adaptor.STPipelineController.processMessage(STPipelineController.java:68-)
at com.bas.openadaptor.NonTransactionalController.processMessage(NonTransactionalController.java:136)
at org.openadaptor.adaptor.AbstractSimpleSource.processMessage(AbstractSimpleSource.java:403)
at org.openadaptor.adaptor.AbstractSimpleSource.sourceProcess(AbstractSimpleSource.java:1049)
at org.openadaptor.adaptor.AbstractSimpleSource.sourceProcess(AbstractSimpleSource.java:1012)
at com.bas.openadaptor.MTJMSListener$JMSMessageHandler.run(MTJMSListener.java:275)
at java.lang.Thread.run(Thread.java:745)

** END NESTED EXCEPTION **

Last packet sent to the server was 1 ms ago.

STACKTRACE:

com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception:

** BEGIN NESTED EXCEPTION **

java.io.EOFException

STACKTRACE:

** END NESTED EXCEPTION **

Last packet sent to the server was 1 ms ago.
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2563)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2862)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2988-)
at com.mysql.jdbc.Statement.executeUpdate(Statement.java:935)
at com.mysql.jdbc.Statement.executeUpdate(Statement.java:873)
at com.bas.basserver.persistence.EntityIdGenerator.generateId(Unknown Source)
at com.bas.basserver.persistence.EntityDBPersister.insertEntity(Unknown Source)
at com.bas.basserver.persistence.PersistenceManager.insertEntity(Unknown Source)
at com.bas.basserver.executionengine.A.H.A(Unknown Source)
at com.bas.basserver.executionengine.A.H.execute(Unknown Source)
at com.bas.basserver.executionengine.ExecutionEngine.A(Unknown Source)
at com.bas.basserver.executionengine.ExecutionEngine.startChildProcess(Unknown Source)
at com.bas.basserver.executionengine.ExecutionEngine.A(Unknown Source)
at com.bas.basserver.executionengine.ExecutionEngine.doCreateEntity(Unknown Source)
at com.bas.basserver.executionengine.ExecutionEngine.createEntityFromTemplate(Unknown Source)
at sun.reflect.GeneratedMethodAccessor32.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498-)
at com.bas.basserver.executionengine.rliproc.C.A(Unknown Source)
at com.bas.basserver.executionengine.rliproc.C.A(Unknown Source)
at com.bas.basserver.executionengine.rliproc.F.Y(Unknown Source)
at com.bas.basserver.executionengine.rliproc.F.Z(Unknown Source)
at com.bas.basserver.executionengine.rliproc.F.P(Unknown Source)
at com.bas.basserver.executionengine.rliproc.F.M(Unknown Source)
at com.bas.basserver.executionengine.rliproc.G.A(Unknown Source)
at com.bas.basserver.executionengine.rliproc.G.C(Unknown Source)
at com.bas.basserver.executionengine.rliproc.G.T(Unknown Source)
at com.bas.basserver.executionengine.rliproc.G.B(Unknown Source)
at com.bas.basserver.executionengine.rliproc.G.A(Unknown Source)
at com.bas.basserver.executionengine.rliproc.G.resume(Unknown Source)
at com.bas.basserver.executionengine.ExecutionEngine.A(Unknown Source)
at com.bas.basserver.executionengine.ExecutionEngine.handleServiceReplyNotification(Unknown Source)
at com.bas.basserver.bsmanager.E.A(Unknown Source)
at com.bas.basserver.bsmanager.E.A(Unknown Source)
at com.bas.basserver.iopipes.ComponentSink.processMessage(Unknown Source)
at org.openadaptor.adaptor.STPipelineController.processMessage(STPipelineController.java:68-)
at com.bas.openadaptor.NonTransactionalController.processMessage(NonTransactionalController.java:136)
at org.openadaptor.adaptor.AbstractSimplePipe.processMessage(AbstractSimplePipe.java:222)
at org.openadaptor.adaptor.STPipelineController.processMessage(STPipelineController.java:68-)
at com.bas.openadaptor.NonTransactionalController.processMessage(NonTransactionalController.java:136)
at org.openadaptor.adaptor.AbstractSimpleSource.processMessage(AbstractSimpleSource.java:403)
at org.openadaptor.adaptor.AbstractSimpleSource.sourceProcess(AbstractSimpleSource.java:1049)
at org.openadaptor.adaptor.AbstractSimpleSource.sourceProcess(AbstractSimpleSource.java:1012)
at com.bas.openadaptor.MTJMSListener$JMSMessageHandler.run(MTJMSListener.java:275)
at java.lang.Thread.run(Thread.java:745)

** END NESTED EXCEPTION **

aware_support

MySQL server went down for some reason. You need to restart it

RLJB

The rest of the app works, mysql is up and running, the error repeats every time we run the process/doc. If we restart mysql, and run process/doc the same happens again.

aware_support

No idea. Try Googling for this problem - maybe you need to change some MySQL settings...