java.sql.SQLDataException: A truncation error was encountered trying to shrink VARCHAR '*********************************' to length 32.

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • Incoming email configuration
    via by Unknown author,
  • If a service returns a large error message the ErrorDocumentService fails to store the error document in the database. This is probably due to the hibernate mapping not specifying a size for the message field so it defaults to 256 characters. {noformat} Exception in thread "net.sf.taverna.t2.workflowmodel.processor.dispatch.events.DispatchJobEvent@1733d8c" net.sf.taverna.t2.reference.ErrorDocumentServiceException: net.sf.taverna.t2.reference.DaoException: org.springframework.dao.DataIntegrityViolationException: could not insert: [net.sf.taverna.t2.reference.impl.ErrorDocumentImpl]; nested exception is org.hibernate.exception.DataException: could not insert: [net.sf.taverna.t2.reference.impl.ErrorDocumentImpl] at net.sf.taverna.t2.reference.impl.ErrorDocumentServiceImpl.registerError(ErrorDocumentServiceImpl.java:91) at net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.ErrorBounce.sendErrorOutput(ErrorBounce.java:138) at net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.ErrorBounce.receiveError(ErrorBounce.java:114) at net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.ErrorBounce.receiveError(ErrorBounce.java:70) at net.sf.taverna.t2.workflowmodel.processor.dispatch.impl.DispatchStackImpl.handleErrorEvent(DispatchStackImpl.java:450) at net.sf.taverna.t2.workflowmodel.processor.dispatch.impl.DispatchStackImpl.access$100(DispatchStackImpl.java:69) at net.sf.taverna.t2.workflowmodel.processor.dispatch.impl.DispatchStackImpl$1.sendError(DispatchStackImpl.java:210) at net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Failover.receiveError(Failover.java:87) at net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Failover.receiveError(Failover.java:55) at net.sf.taverna.t2.workflowmodel.processor.dispatch.impl.DispatchStackImpl.handleErrorEvent(DispatchStackImpl.java:450) at net.sf.taverna.t2.workflowmodel.processor.dispatch.impl.DispatchStackImpl.access$100(DispatchStackImpl.java:69) at net.sf.taverna.t2.workflowmodel.processor.dispatch.impl.DispatchStackImpl$1.sendError(DispatchStackImpl.java:210) at net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Retry.receiveError(Retry.java:83) at net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Retry.receiveError(Retry.java:55) at net.sf.taverna.t2.workflowmodel.processor.dispatch.impl.DispatchStackImpl.handleErrorEvent(DispatchStackImpl.java:450) at net.sf.taverna.t2.workflowmodel.processor.dispatch.impl.DispatchStackImpl.access$100(DispatchStackImpl.java:69) at net.sf.taverna.t2.workflowmodel.processor.dispatch.impl.DispatchStackImpl$1.sendError(DispatchStackImpl.java:210) at net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Invoke$InvokeCallBack.fail(Invoke.java:222) at net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Invoke$InvokeCallBack.fail(Invoke.java:207) at net.sf.taverna.t2.activities.biomoby.BiomobyActivity$1.run(BiomobyActivity.java:916) at java.lang.Thread.run(Thread.java:619) Caused by: net.sf.taverna.t2.reference.DaoException: org.springframework.dao.DataIntegrityViolationException: could not insert: [net.sf.taverna.t2.reference.impl.ErrorDocumentImpl]; nested exception is org.hibernate.exception.DataException: could not insert: [net.sf.taverna.t2.reference.impl.ErrorDocumentImpl] at net.sf.taverna.t2.reference.impl.HibernateErrorDocumentDao.store(HibernateErrorDocumentDao.java:98) at net.sf.taverna.t2.reference.impl.ErrorDocumentServiceImpl.registerError(ErrorDocumentServiceImpl.java:89) ... 20 more Caused by: org.springframework.dao.DataIntegrityViolationException: could not insert: [net.sf.taverna.t2.reference.impl.ErrorDocumentImpl]; nested exception is org.hibernate.exception.DataException: could not insert: [net.sf.taverna.t2.reference.impl.ErrorDocumentImpl] at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:639) at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412) at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:424) at org.springframework.orm.hibernate3.HibernateTemplate.executeWithNativeSession(HibernateTemplate.java:374) at org.springframework.orm.hibernate3.HibernateTemplate.save(HibernateTemplate.java:694) at net.sf.taverna.t2.reference.impl.HibernateErrorDocumentDao.store(HibernateErrorDocumentDao.java:96) ... 21 more Caused by: org.hibernate.exception.DataException: could not insert: [net.sf.taverna.t2.reference.impl.ErrorDocumentImpl] at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:77) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2267) at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2660) at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:56) at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:250) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:234) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:141) at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298) at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27) at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000) at org.springframework.orm.hibernate3.HibernateAccessor.flushIfNecessary(HibernateAccessor.java:390) at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:420) ... 24 more Caused by: java.sql.SQLDataException: A truncation error was encountered trying to shrink VARCHAR '===ERROR=== Fault details: [string: null] [HttpErrorCode:&' to length 255. at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source) at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source) at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source) at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source) at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown Source) at org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:23) at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2247) ... 34 more Caused by: java.sql.SQLException: A truncation error was encountered trying to shrink VARCHAR '===ERROR=== Fault details: [string: null] [HttpErrorCode:&' to length 255. at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source) ... 45 more Caused by: ERROR 22001: A truncation error was encountered trying to shrink VARCHAR '===ERROR=== Fault details: [string: null] [HttpErrorCode:&' to length 255. at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) at org.apache.derby.iapi.types.SQLChar.hasNonBlankChars(Unknown Source) at org.apache.derby.iapi.types.SQLVarchar.normalize(Unknown Source) at org.apache.derby.iapi.types.SQLVarchar.normalize(Unknown Source) at org.apache.derby.iapi.types.DataTypeDescriptor.normalize(Unknown Source) at org.apache.derby.impl.sql.execute.NormalizeResultSet.normalizeRow(Unknown Source) at org.apache.derby.impl.sql.execute.NormalizeResultSet.getNextRowCore(Unknown Source) at org.apache.derby.impl.sql.execute.DMLWriteResultSet.getNextRowCore(Unknown Source) at org.apache.derby.impl.sql.execute.InsertResultSet.open(Unknown Source) at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source) ... 39 more {noformat}
    via by David Withers,
  • A truncation error was encountered
    via by Jitendra Kharche,
  • A truncation error was encountered
    via by Jitendra Kharche,
  • A truncation error was encountered
    via by Jitendra Kharche,
  • java.sql.SQLException | ERROR 07000
    via by silverhair76,
  • GitHub comment 509#153419288
    via GitHub by dmatej
    ,
    • java.sql.SQLDataException: A truncation error was encountered trying to shrink VARCHAR '*********************************' to length 32. at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source) at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source) at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source) at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source) at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown Source) at com.bitmechanic.sql.PooledPreparedStatement.executeUpdate(Unknown Source) at com.sysaid.server.ServiceRequest.save(Unknown Source) at com.sysaid.server.cg.a(Unknown Source) at com.sysaid.server.cg.a(Unknown Source) at com.sysaid.server.l.b(Unknown Source) at com.sysaid.server.l.execute(Unknown Source) at org.quartz.core.JobRunShell.run(JobRunShell.java:203) at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520) Caused by: java.sql.SQLException: A truncation error was encountered trying to shrink VARCHAR '*********************************' to length 32. at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source) ... 17 more

    Users with the same issue

    jf-ast
    jf-ast1 times, last one,
    stigkj
    stigkj1 times, last one,
    andyglick
    andyglick1 times, last one,
    davidvanlaatum
    davidvanlaatum1 times, last one,
    muffinmannen
    muffinmannen81 times, last one,
    1 more bugmates