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

sysaid.com | 3 months ago
  1. 0

    Incoming email configuration

    sysaid.com | 3 months ago
    java.sql.SQLDataException: A truncation error was encountered trying to shrink VARCHAR '*********************************' to length 32.
  2. 0

    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}

    JIRA | 8 years ago | David Withers
    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]
  3. 0

    I cannot publish the build info using TeamCtiy Artifactory Plugin-In. Here is the stacktrace in artifactory.log. The plugin should reduce the string length before publishing the build info {code} 2014-07-02 07:19:12,584 [ajp-bio-8019-exec-7272] [INFO ] (o.a.r.r.c.BuildResource:275) - Adding build 'Yellow Pages Group :: Systems & Process Integration :: Enterprise Service Bus :: EAI-Enterprise Application Integration :: PCC (Paid Content Capture) :: Merchant Content Management :: ypg.pcc.merchant.content.management.bw :: ypg.pcc.merchant.content.management.bw #1.0.0-SNAPSHOT (2)' 2014-07-02 07:19:16,857 [ajp-bio-8019-exec-7272] [ERROR] (o.a.r.c.e.GlobalExceptionMapper:46) - Could not insert build org.jfrog.build.api.Build@71b7b517 org.artifactory.storage.StorageException: Could not insert build org.jfrog.build.api.Build@71b7b517 at org.artifactory.storage.db.build.service.BuildStoreServiceImpl.addBuild(BuildStoreServiceImpl.java:135) ~[artifactory-storage-db-3.2.0.jar:na] at org.artifactory.build.BuildServiceImpl.addBuild(BuildServiceImpl.java:180) ~[artifactory-core-3.2.0.jar:na] at sun.reflect.GeneratedMethodAccessor369.invoke(Unknown Source) ~[na:na] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.7.0_55] at java.lang.reflect.Method.invoke(Method.java:606) ~[na:1.7.0_55] at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317) ~[spring-aop-4.0.2.RELEASE.jar:4.0.2.RELEASE] at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190) ~[spring-aop-4.0.2.RELEASE.jar:4.0.2.RELEASE] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) ~[spring-aop-4.0.2.RELEASE.jar:4.0.2.RELEASE] at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:98) ~[spring-tx-4.0.2.RELEASE.jar:4.0.2.RELEASE] at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:262) ~[spring-tx-4.0.2.RELEASE.jar:4.0.2.RELEASE] at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:95) ~[spring-tx-4.0.2.RELEASE.jar:4.0.2.RELEASE] at org.artifactory.storage.fs.lock.aop.LockingAdvice.invoke(LockingAdvice.java:64) ~[artifactory-storage-common-3.2.0.jar:na] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) ~[spring-aop-4.0.2.RELEASE.jar:4.0.2.RELEASE] at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207) ~[spring-aop-4.0.2.RELEASE.jar:4.0.2.RELEASE] at com.sun.proxy.$Proxy64.addBuild(Unknown Source) ~[na:na] at org.artifactory.rest.resource.ci.BuildResource.addBuild(BuildResource.java:281) ~[artifactory-rest-3.2.0.jar:na] at sun.reflect.GeneratedMethodAccessor367.invoke(Unknown Source) ~[na:na] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.7.0_55] at java.lang.reflect.Method.invoke(Method.java:606) ~[na:1.7.0_55] at com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:60) ~[jersey-server-1.12.jar:1.12] at com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$VoidOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:167) ~[jersey-server-1.12.jar:1.12] at com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:75) ~[jersey-server-1.12.jar:1.12] at com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:288) ~[jersey-server-1.12.jar:1.12] at com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept(ResourceClassRule.java:108) ~[jersey-server-1.12.jar:1.12] at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147) ~[jersey-server-1.12.jar:1.12] at com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept(RootResourceClassesRule.java:84) ~[jersey-server-1.12.jar:1.12] at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1483) [jersey-server-1.12.jar:1.12] at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1414) [jersey-server-1.12.jar:1.12] at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1363) [jersey-server-1.12.jar:1.12] at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1353) [jersey-server-1.12.jar:1.12] at com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:414) [jersey-servlet-1.12.jar:1.12] at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:537) [jersey-servlet-1.12.jar:1.12] at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:708) [jersey-servlet-1.12.jar:1.12] at javax.servlet.http.HttpServlet.service(HttpServlet.java:728) [servlet-api.jar:na] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) [catalina.jar:7.0.39] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) [catalina.jar:7.0.39] at org.artifactory.webapp.servlet.RepoFilter.execute(RepoFilter.java:182) [artifactory-web-application-3.2.0.jar:na] at org.artifactory.webapp.servlet.RepoFilter.doFilter(RepoFilter.java:88) [artifactory-web-application-3.2.0.jar:na] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) [catalina.jar:7.0.39] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) [catalina.jar:7.0.39] at org.artifactory.webapp.servlet.AccessFilter.useAuthentication(AccessFilter.java:314) [artifactory-web-application-3.2.0.jar:na] at org.artifactory.webapp.servlet.AccessFilter.authenticateAndExecute(AccessFilter.java:218) [artifactory-web-application-3.2.0.jar:na] at org.artifactory.webapp.servlet.AccessFilter.doFilterInternal(AccessFilter.java:184) [artifactory-web-application-3.2.0.jar:na] at org.artifactory.webapp.servlet.AccessFilter.doFilter(AccessFilter.java:152) [artifactory-web-application-3.2.0.jar:na] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) [catalina.jar:7.0.39] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) [catalina.jar:7.0.39] at org.artifactory.webapp.servlet.RequestFilter.doFilter(RequestFilter.java:61) [artifactory-web-application-3.2.0.jar:na] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) [catalina.jar:7.0.39] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) [catalina.jar:7.0.39] at org.artifactory.webapp.servlet.ArtifactoryFilter.doFilter(ArtifactoryFilter.java:92) [artifactory-web-application-3.2.0.jar:na] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) [catalina.jar:7.0.39] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) [catalina.jar:7.0.39] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222) [catalina.jar:7.0.39] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123) [catalina.jar:7.0.39] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171) [catalina.jar:7.0.39] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99) [catalina.jar:7.0.39] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) [catalina.jar:7.0.39] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408) [catalina.jar:7.0.39] at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:200) [tomcat-coyote.jar:7.0.39] at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589) [tomcat-coyote.jar:7.0.39] at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310) [tomcat-coyote.jar:7.0.39] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [na:1.7.0_55] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [na:1.7.0_55] at java.lang.Thread.run(Thread.java:745) [na:1.7.0_55] Caused by: java.sql.SQLDataException: A truncation error was encountered trying to shrink VARCHAR 'Yellow Pages Group :: Systems & Process Integration :: Enter&' to length 255. at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source) ~[derby-10.9.1.0.jar:na] at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) ~[derby-10.9.1.0.jar:na] at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source) ~[derby-10.9.1.0.jar:na] at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source) ~[derby-10.9.1.0.jar:na] at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) ~[derby-10.9.1.0.jar:na] at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source) ~[derby-10.9.1.0.jar:na] at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source) ~[derby-10.9.1.0.jar:na] at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source) ~[derby-10.9.1.0.jar:na] at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown Source) ~[derby-10.9.1.0.jar:na] at org.artifactory.storage.db.util.JdbcHelper.executeUpdate(JdbcHelper.java:131) ~[artifactory-storage-db-3.2.0.jar:na] at org.artifactory.storage.db.build.dao.BuildsDao.createBuild(BuildsDao.java:66) ~[artifactory-storage-db-3.2.0.jar:na] at org.artifactory.storage.db.build.service.BuildStoreServiceImpl.addBuild(BuildStoreServiceImpl.java:132) ~[artifactory-storage-db-3.2.0.jar:na] ... 63 common frames omitted Caused by: org.apache.derby.impl.jdbc.EmbedSQLException: A truncation error was encountered trying to shrink VARCHAR 'Yellow Pages Group :: Systems & Process Integration :: Enter&' to length 255. at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) ~[derby-10.9.1.0.jar:na] at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source) ~[derby-10.9.1.0.jar:na] ... 75 common frames omitted Caused by: org.apache.derby.iapi.error.StandardException: A truncation error was encountered trying to shrink VARCHAR 'Yellow Pages Group :: Systems & Process Integration :: Enter&' to length 255. at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) ~[derby-10.9.1.0.jar:na] at org.apache.derby.iapi.types.SQLChar.hasNonBlankChars(Unknown Source) ~[derby-10.9.1.0.jar:na] at org.apache.derby.iapi.types.SQLVarchar.normalize(Unknown Source) ~[derby-10.9.1.0.jar:na] at org.apache.derby.iapi.types.SQLVarchar.normalize(Unknown Source) ~[derby-10.9.1.0.jar:na] at org.apache.derby.iapi.types.DataTypeDescriptor.normalize(Unknown Source) ~[derby-10.9.1.0.jar:na] at org.apache.derby.impl.sql.execute.NormalizeResultSet.normalizeColumn(Unknown Source) ~[derby-10.9.1.0.jar:na] at org.apache.derby.impl.sql.execute.NormalizeResultSet.normalizeRow(Unknown Source) ~[derby-10.9.1.0.jar:na] at org.apache.derby.impl.sql.execute.NormalizeResultSet.getNextRowCore(Unknown Source) ~[derby-10.9.1.0.jar:na] at org.apache.derby.impl.sql.execute.DMLWriteResultSet.getNextRowCore(Unknown Source) ~[derby-10.9.1.0.jar:na] at org.apache.derby.impl.sql.execute.InsertResultSet.open(Unknown Source) ~[derby-10.9.1.0.jar:na] at org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown Source) ~[derby-10.9.1.0.jar:na] at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source) ~[derby-10.9.1.0.jar:na] ... 69 common frames omitted {code}

    JFrog JIRA | 2 years ago | Tat Chiu Leung
    org.artifactory.storage.StorageException: Could not insert build org.jfrog.build.api.Build@71b7b517
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    A truncation error was encountered

    ode-user | 2 years ago | Jitendra Kharche
    java.sql.SQLDataException: A truncation error was encountered trying to shrink BLOB '(Binary data value not displayed)' to length 1048576.
  6. 0

    I cannot publish the build info using TeamCtiy Artifactory Plugin-In. Here is the stacktrace in artifactory.log. The plugin should reduce the string length before publishing the build info {code} 2014-07-02 07:19:12,584 [ajp-bio-8019-exec-7272] [INFO ] (o.a.r.r.c.BuildResource:275) - Adding build 'Yellow Pages Group :: Systems & Process Integration :: Enterprise Service Bus :: EAI-Enterprise Application Integration :: PCC (Paid Content Capture) :: Merchant Content Management :: ypg.pcc.merchant.content.management.bw :: ypg.pcc.merchant.content.management.bw #1.0.0-SNAPSHOT (2)' 2014-07-02 07:19:16,857 [ajp-bio-8019-exec-7272] [ERROR] (o.a.r.c.e.GlobalExceptionMapper:46) - Could not insert build org.jfrog.build.api.Build@71b7b517 org.artifactory.storage.StorageException: Could not insert build org.jfrog.build.api.Build@71b7b517 at org.artifactory.storage.db.build.service.BuildStoreServiceImpl.addBuild(BuildStoreServiceImpl.java:135) ~[artifactory-storage-db-3.2.0.jar:na] at org.artifactory.build.BuildServiceImpl.addBuild(BuildServiceImpl.java:180) ~[artifactory-core-3.2.0.jar:na] at sun.reflect.GeneratedMethodAccessor369.invoke(Unknown Source) ~[na:na] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.7.0_55] at java.lang.reflect.Method.invoke(Method.java:606) ~[na:1.7.0_55] at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317) ~[spring-aop-4.0.2.RELEASE.jar:4.0.2.RELEASE] at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190) ~[spring-aop-4.0.2.RELEASE.jar:4.0.2.RELEASE] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) ~[spring-aop-4.0.2.RELEASE.jar:4.0.2.RELEASE] at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:98) ~[spring-tx-4.0.2.RELEASE.jar:4.0.2.RELEASE] at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:262) ~[spring-tx-4.0.2.RELEASE.jar:4.0.2.RELEASE] at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:95) ~[spring-tx-4.0.2.RELEASE.jar:4.0.2.RELEASE] at org.artifactory.storage.fs.lock.aop.LockingAdvice.invoke(LockingAdvice.java:64) ~[artifactory-storage-common-3.2.0.jar:na] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) ~[spring-aop-4.0.2.RELEASE.jar:4.0.2.RELEASE] at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207) ~[spring-aop-4.0.2.RELEASE.jar:4.0.2.RELEASE] at com.sun.proxy.$Proxy64.addBuild(Unknown Source) ~[na:na] at org.artifactory.rest.resource.ci.BuildResource.addBuild(BuildResource.java:281) ~[artifactory-rest-3.2.0.jar:na] at sun.reflect.GeneratedMethodAccessor367.invoke(Unknown Source) ~[na:na] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.7.0_55] at java.lang.reflect.Method.invoke(Method.java:606) ~[na:1.7.0_55] at com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:60) ~[jersey-server-1.12.jar:1.12] at com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$VoidOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:167) ~[jersey-server-1.12.jar:1.12] at com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:75) ~[jersey-server-1.12.jar:1.12] at com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:288) ~[jersey-server-1.12.jar:1.12] at com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept(ResourceClassRule.java:108) ~[jersey-server-1.12.jar:1.12] at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147) ~[jersey-server-1.12.jar:1.12] at com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept(RootResourceClassesRule.java:84) ~[jersey-server-1.12.jar:1.12] at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1483) [jersey-server-1.12.jar:1.12] at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1414) [jersey-server-1.12.jar:1.12] at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1363) [jersey-server-1.12.jar:1.12] at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1353) [jersey-server-1.12.jar:1.12] at com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:414) [jersey-servlet-1.12.jar:1.12] at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:537) [jersey-servlet-1.12.jar:1.12] at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:708) [jersey-servlet-1.12.jar:1.12] at javax.servlet.http.HttpServlet.service(HttpServlet.java:728) [servlet-api.jar:na] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) [catalina.jar:7.0.39] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) [catalina.jar:7.0.39] at org.artifactory.webapp.servlet.RepoFilter.execute(RepoFilter.java:182) [artifactory-web-application-3.2.0.jar:na] at org.artifactory.webapp.servlet.RepoFilter.doFilter(RepoFilter.java:88) [artifactory-web-application-3.2.0.jar:na] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) [catalina.jar:7.0.39] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) [catalina.jar:7.0.39] at org.artifactory.webapp.servlet.AccessFilter.useAuthentication(AccessFilter.java:314) [artifactory-web-application-3.2.0.jar:na] at org.artifactory.webapp.servlet.AccessFilter.authenticateAndExecute(AccessFilter.java:218) [artifactory-web-application-3.2.0.jar:na] at org.artifactory.webapp.servlet.AccessFilter.doFilterInternal(AccessFilter.java:184) [artifactory-web-application-3.2.0.jar:na] at org.artifactory.webapp.servlet.AccessFilter.doFilter(AccessFilter.java:152) [artifactory-web-application-3.2.0.jar:na] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) [catalina.jar:7.0.39] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) [catalina.jar:7.0.39] at org.artifactory.webapp.servlet.RequestFilter.doFilter(RequestFilter.java:61) [artifactory-web-application-3.2.0.jar:na] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) [catalina.jar:7.0.39] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) [catalina.jar:7.0.39] at org.artifactory.webapp.servlet.ArtifactoryFilter.doFilter(ArtifactoryFilter.java:92) [artifactory-web-application-3.2.0.jar:na] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) [catalina.jar:7.0.39] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) [catalina.jar:7.0.39] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222) [catalina.jar:7.0.39] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123) [catalina.jar:7.0.39] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171) [catalina.jar:7.0.39] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99) [catalina.jar:7.0.39] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) [catalina.jar:7.0.39] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408) [catalina.jar:7.0.39] at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:200) [tomcat-coyote.jar:7.0.39] at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589) [tomcat-coyote.jar:7.0.39] at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310) [tomcat-coyote.jar:7.0.39] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [na:1.7.0_55] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [na:1.7.0_55] at java.lang.Thread.run(Thread.java:745) [na:1.7.0_55] Caused by: java.sql.SQLDataException: A truncation error was encountered trying to shrink VARCHAR 'Yellow Pages Group :: Systems & Process Integration :: Enter&' to length 255. at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source) ~[derby-10.9.1.0.jar:na] at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) ~[derby-10.9.1.0.jar:na] at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source) ~[derby-10.9.1.0.jar:na] at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source) ~[derby-10.9.1.0.jar:na] at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) ~[derby-10.9.1.0.jar:na] at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source) ~[derby-10.9.1.0.jar:na] at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source) ~[derby-10.9.1.0.jar:na] at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source) ~[derby-10.9.1.0.jar:na] at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown Source) ~[derby-10.9.1.0.jar:na] at org.artifactory.storage.db.util.JdbcHelper.executeUpdate(JdbcHelper.java:131) ~[artifactory-storage-db-3.2.0.jar:na] at org.artifactory.storage.db.build.dao.BuildsDao.createBuild(BuildsDao.java:66) ~[artifactory-storage-db-3.2.0.jar:na] at org.artifactory.storage.db.build.service.BuildStoreServiceImpl.addBuild(BuildStoreServiceImpl.java:132) ~[artifactory-storage-db-3.2.0.jar:na] ... 63 common frames omitted Caused by: org.apache.derby.impl.jdbc.EmbedSQLException: A truncation error was encountered trying to shrink VARCHAR 'Yellow Pages Group :: Systems & Process Integration :: Enter&' to length 255. at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) ~[derby-10.9.1.0.jar:na] at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source) ~[derby-10.9.1.0.jar:na] ... 75 common frames omitted Caused by: org.apache.derby.iapi.error.StandardException: A truncation error was encountered trying to shrink VARCHAR 'Yellow Pages Group :: Systems & Process Integration :: Enter&' to length 255. at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) ~[derby-10.9.1.0.jar:na] at org.apache.derby.iapi.types.SQLChar.hasNonBlankChars(Unknown Source) ~[derby-10.9.1.0.jar:na] at org.apache.derby.iapi.types.SQLVarchar.normalize(Unknown Source) ~[derby-10.9.1.0.jar:na] at org.apache.derby.iapi.types.SQLVarchar.normalize(Unknown Source) ~[derby-10.9.1.0.jar:na] at org.apache.derby.iapi.types.DataTypeDescriptor.normalize(Unknown Source) ~[derby-10.9.1.0.jar:na] at org.apache.derby.impl.sql.execute.NormalizeResultSet.normalizeColumn(Unknown Source) ~[derby-10.9.1.0.jar:na] at org.apache.derby.impl.sql.execute.NormalizeResultSet.normalizeRow(Unknown Source) ~[derby-10.9.1.0.jar:na] at org.apache.derby.impl.sql.execute.NormalizeResultSet.getNextRowCore(Unknown Source) ~[derby-10.9.1.0.jar:na] at org.apache.derby.impl.sql.execute.DMLWriteResultSet.getNextRowCore(Unknown Source) ~[derby-10.9.1.0.jar:na] at org.apache.derby.impl.sql.execute.InsertResultSet.open(Unknown Source) ~[derby-10.9.1.0.jar:na] at org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown Source) ~[derby-10.9.1.0.jar:na] at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source) ~[derby-10.9.1.0.jar:na] ... 69 common frames omitted {code}

    JFrog JIRA | 2 years ago | Tat Chiu Leung
    org.artifactory.storage.StorageException: Could not insert build org.jfrog.build.api.Build@71b7b517

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.sql.SQLException

      A truncation error was encountered trying to shrink VARCHAR '*********************************' to length 32.

      at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException()
    2. Derby
      EmbedPreparedStatement.executeUpdate
      1. org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
      2. org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
      3. org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
      4. org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
      5. org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
      6. org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
      7. org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
      8. org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
      9. org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source)
      10. org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source)
      11. org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown Source)
      11 frames
    3. com.bitmechanic.sql
      PooledPreparedStatement.executeUpdate
      1. com.bitmechanic.sql.PooledPreparedStatement.executeUpdate(Unknown Source)
      1 frame
    4. com.sysaid.server
      l.execute
      1. com.sysaid.server.ServiceRequest.save(Unknown Source)
      2. com.sysaid.server.cg.a(Unknown Source)
      3. com.sysaid.server.cg.a(Unknown Source)
      4. com.sysaid.server.l.b(Unknown Source)
      5. com.sysaid.server.l.execute(Unknown Source)
      5 frames
    5. quartz
      SimpleThreadPool$WorkerThread.run
      1. org.quartz.core.JobRunShell.run(JobRunShell.java:203)
      2. org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520)
      2 frames