2021-04-20 11:57:26,376 ERROR (kied4mxq-dataloader-1) [org.jumpmind.symmetric.service.impl.ManageIncomingBatchListener] Failed to record status of batch home-14155297 org.jumpmind.db.sql.SqlException: An IOException was thrown when reading a 'java.lang.String' from an InputStream. at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:313) ~[symmetric-db-3.12.6.jar:3.12.6] at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:302) ~[symmetric-db-3.12.6.jar:3.12.6] at org.jumpmind.db.sql.JdbcSqlTransaction.executeCallback(JdbcSqlTransaction.java:398) ~[symmetric-jdbc-3.12.6.jar:3.12.6] at org.jumpmind.db.sql.JdbcSqlTransaction.prepareAndExecute(JdbcSqlTransaction.java:328) ~[symmetric-jdbc-3.12.6.jar:3.12.6] at org.jumpmind.symmetric.service.impl.DataLoaderService.insertIncomingError(DataLoaderService.java:916) ~[symmetric-core-3.12.6.jar:3.12.6] at org.jumpmind.symmetric.service.impl.ManageIncomingBatchListener.batchInError(ManageIncomingBatchListener.java:322) [symmetric-core-3.12.6.jar:3.12.6] at org.jumpmind.symmetric.io.data.DataProcessor.process(DataProcessor.java:152) [symmetric-io-3.12.6.jar:3.12.6] at org.jumpmind.symmetric.service.impl.DataLoaderService$LoadIntoDatabaseOnArrivalListener$2.call(DataLoaderService.java:1085) [symmetric-core-3.12.6.jar:3.12.6] at org.jumpmind.symmetric.service.impl.DataLoaderService$LoadIntoDatabaseOnArrivalListener$2.call(DataLoaderService.java:1061) [symmetric-core-3.12.6.jar:3.12.6] at java.util.concurrent.FutureTask.run(FutureTask.java:266) [?:1.8.0_271] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_271] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_271] at java.lang.Thread.run(Thread.java:748) [?:1.8.0_271] Caused by: java.sql.SQLException: An IOException was thrown when reading a 'java.lang.String' from an InputStream. at org.apache.derby.client.am.SQLExceptionFactory.getSQLException(Unknown Source) ~[derbyclient-10.14.2.0.jar:?] at org.apache.derby.client.am.SqlException.getSQLException(Unknown Source) ~[derbyclient-10.14.2.0.jar:?] at org.apache.derby.client.am.ClientPreparedStatement.executeUpdate(Unknown Source) ~[derbyclient-10.14.2.0.jar:?] at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) ~[commons-dbcp-1.4.jar:1.4] at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) ~[commons-dbcp-1.4.jar:1.4] at org.jumpmind.db.sql.JdbcSqlTransaction.executePreparedUpdate(JdbcSqlTransaction.java:485) ~[symmetric-jdbc-3.12.6.jar:3.12.6] at org.jumpmind.db.sql.JdbcSqlTransaction$4.execute(JdbcSqlTransaction.java:335) ~[symmetric-jdbc-3.12.6.jar:3.12.6] at org.jumpmind.db.sql.JdbcSqlTransaction$4.execute(JdbcSqlTransaction.java:328) ~[symmetric-jdbc-3.12.6.jar:3.12.6] at org.jumpmind.db.sql.JdbcSqlTransaction.executeCallback(JdbcSqlTransaction.java:396) ~[symmetric-jdbc-3.12.6.jar:3.12.6] ... 10 more Caused by: org.apache.derby.client.am.SqlException: An IOException was thrown when reading a 'java.lang.String' from an InputStream. at org.apache.derby.client.am.ClientStatement.completeExecute(Unknown Source) ~[derbyclient-10.14.2.0.jar:?] at org.apache.derby.client.net.NetStatementReply.parseEXCSQLSTTreply(Unknown Source) ~[derbyclient-10.14.2.0.jar:?] at org.apache.derby.client.net.NetStatementReply.readExecute(Unknown Source) ~[derbyclient-10.14.2.0.jar:?] at org.apache.derby.client.net.StatementReply.readExecute(Unknown Source) ~[derbyclient-10.14.2.0.jar:?] at org.apache.derby.client.net.NetPreparedStatement.readExecute_(Unknown Source) ~[derbyclient-10.14.2.0.jar:?] at org.apache.derby.client.am.ClientPreparedStatement.readExecute(Unknown Source) ~[derbyclient-10.14.2.0.jar:?] at org.apache.derby.client.am.ClientPreparedStatement.flowExecute(Unknown Source) ~[derbyclient-10.14.2.0.jar:?] at org.apache.derby.client.am.ClientPreparedStatement.executeUpdateX(Unknown Source) ~[derbyclient-10.14.2.0.jar:?] at org.apache.derby.client.am.ClientPreparedStatement.executeUpdate(Unknown Source) ~[derbyclient-10.14.2.0.jar:?] at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) ~[commons-dbcp-1.4.jar:1.4] at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) ~[commons-dbcp-1.4.jar:1.4] at org.jumpmind.db.sql.JdbcSqlTransaction.executePreparedUpdate(JdbcSqlTransaction.java:485) ~[symmetric-jdbc-3.12.6.jar:3.12.6] at org.jumpmind.db.sql.JdbcSqlTransaction$4.execute(JdbcSqlTransaction.java:335) ~[symmetric-jdbc-3.12.6.jar:3.12.6] at org.jumpmind.db.sql.JdbcSqlTransaction$4.execute(JdbcSqlTransaction.java:328) ~[symmetric-jdbc-3.12.6.jar:3.12.6] at org.jumpmind.db.sql.JdbcSqlTransaction.executeCallback(JdbcSqlTransaction.java:396) ~[symmetric-jdbc-3.12.6.jar:3.12.6] ... 10 more Caused by: org.apache.derby.client.am.SqlException: Java exception: 'A truncation error was encountered trying to shrink LONG VARCHAR '' to length 32700.: org.apache.derby.iapi.services.io.DerbyIOException'. at org.apache.derby.client.am.ClientStatement.completeExecute(Unknown Source) ~[derbyclient-10.14.2.0.jar:?] at org.apache.derby.client.net.NetStatementReply.parseEXCSQLSTTreply(Unknown Source) ~[derbyclient-10.14.2.0.jar:?] at org.apache.derby.client.net.NetStatementReply.readExecute(Unknown Source) ~[derbyclient-10.14.2.0.jar:?] at org.apache.derby.client.net.StatementReply.readExecute(Unknown Source) ~[derbyclient-10.14.2.0.jar:?] at org.apache.derby.client.net.NetPreparedStatement.readExecute_(Unknown Source) ~[derbyclient-10.14.2.0.jar:?] at org.apache.derby.client.am.ClientPreparedStatement.readExecute(Unknown Source) ~[derbyclient-10.14.2.0.jar:?] at org.apache.derby.client.am.ClientPreparedStatement.flowExecute(Unknown Source) ~[derbyclient-10.14.2.0.jar:?] at org.apache.derby.client.am.ClientPreparedStatement.executeUpdateX(Unknown Source) ~[derbyclient-10.14.2.0.jar:?] at org.apache.derby.client.am.ClientPreparedStatement.executeUpdate(Unknown Source) ~[derbyclient-10.14.2.0.jar:?] at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) ~[commons-dbcp-1.4.jar:1.4] at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) ~[commons-dbcp-1.4.jar:1.4] at org.jumpmind.db.sql.JdbcSqlTransaction.executePreparedUpdate(JdbcSqlTransaction.java:485) ~[symmetric-jdbc-3.12.6.jar:3.12.6] at org.jumpmind.db.sql.JdbcSqlTransaction$4.execute(JdbcSqlTransaction.java:335) ~[symmetric-jdbc-3.12.6.jar:3.12.6] at org.jumpmind.db.sql.JdbcSqlTransaction$4.execute(JdbcSqlTransaction.java:328) ~[symmetric-jdbc-3.12.6.jar:3.12.6] at org.jumpmind.db.sql.JdbcSqlTransaction.executeCallback(JdbcSqlTransaction.java:396) ~[symmetric-jdbc-3.12.6.jar:3.12.6] ... 10 more