java.sql.SQLDataException: A truncation error was encountered trying to shrink VARCHAR 'output/us-rfbd.EP-MN486us-rfbd.EP-MN486us-rfbd.EP-MN486%20-%&' to length 255. Error Code: 20000 Call: INSERT INTO job_option_results (MEDIATYPE, OPTIONNAME, PATH, idx, job_id) VALUES (?, ?, ?, ?, ?) bind => [5 parameters bound] Query: InsertObjectQuery(org.daisy.pipeline.persistence.jobs.PersistentOptionResult@155c49f )

Google Groups | Pritchett, James | 3 years ago
  1. 0

    Bug report: error finishing job with long title

    Google Groups | 3 years ago | Pritchett, James
    java.sql.SQLDataException: A truncation error was encountered trying to shrink VARCHAR 'output/us-rfbd.EP-MN486us-rfbd.EP-MN486us-rfbd.EP-MN486%20-%&' to length 255. Error Code: 20000 Call: INSERT INTO job_option_results (MEDIATYPE, OPTIONNAME, PATH, idx, job_id) VALUES (?, ?, ?, ?, ?) bind => [5 parameters bound] Query: InsertObjectQuery(org.daisy.pipeline.persistence.jobs.PersistentOptionResult@155c49f )
  2. 0

    Soa database column (WORK_ITEM) too small for nested activities ?

    Oracle Community | 2 years ago | Clarec
    java.sql.SQLDataException: A truncation error was encountered trying to shrink VARCHAR 'default/Zzz_Wfxxxxxxxxxxxxxxxxxxxx!1.0*soa_d8cba580-ebc4-4cd&' to length 256. Error Code: 20000 Call: INSERT INTO WORK_ITEM (NODE_ID, CIKEY, SCOPE_ID, COUNT_ID, CLUSTER_NODE_ID, CLUSTER_NODE_KEY, COMMENTS, CREATION_DATE, CREATOR, CUSTOM_ID, DELAY, EXECUTION_TYPE, EXP_DATE, EXP_FLAG, EXT_INT1, EXT_STRING1, EXT_STRING2, FIRST_DELAY, IDEMPOTENT_FLAG, LABEL, MODIFIER, MODIFY_DATE, CI_PARTITION_DATE, PRIORITY, REFERENCE_ID, STATE, TRANSITION) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) bind => [Process_ACT11765174131137_RwSubprocess1_ACT11766550672060_ACT12198499959993, 340240, Process_ACT11765174131137_RwSubprocess1_ACT11766550672060_ACT11766550672060_try.26, 3, null, -1, null, 2015-02-11 15:07:06.985, null, default/Zzz_Wfxxxxxxxxxxxxxxxxxxxx!1.0*soa_d8cba580-ebc4-4cd7-a8e8-8586e3ad15d7/Process/340240-Process_ACT11765174131137_RwSubprocess1_ACT11766550672060_ACT12198499959993-Process_ACT11765174131137_RwSubprocess1_ACT11766550672060_ACT11766550672060_try.26-3, 0, 0, null, 0, 0, null, null, 0, 1, CPT:chRisp, null, 2015-02-11 15:07:07.2, 2015-02-11 15:07:05.662, 3, null, 3, 0] Query: InsertObjectQuery(340240-Process_ACT11765174131137_RwSubprocess1_ACT11766550672060_ACT12198499959993-Process_ACT11765174131137_RwSubprocess1_ACT11766550672060_ACT11766550672060_try.26-3)
  3. 0

    openjms / Mailing Lists

    sourceforge.net | 7 months ago
    java.sql.SQLDataException: A truncation error was encounter ed trying to shrink CHAR 'false' to length 1. at org.exolab.jms.messagemgr.DestinationManagerImpl.cleanup(DestinationM anagerImpl.java:784) at org.exolab.jms.messagemgr.DestinationManagerImpl.createPersistentDest ination(DestinationManagerImpl.java:623) at org.exolab.jms.messagemgr.DestinationManagerImpl.createDestination(De stinationManagerImpl.java:278) at org.exolab.jms.messagemgr.DestinationConfigurator.configureTopics(Des tinationConfigurator.java:149) at org.exolab.jms.messagemgr.DestinationConfigurator.doStart(Destination Configurator.java:129)
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Kohei Nozaki's blog

    nailedtothex.org | 8 months ago
    java.sql.SQLDataException: An attempt was made to get a data value of type 'BIGINT' from a data value of type 'entity.EmployeeName'. Error Code: 20000 Call: SELECT ID, FIRSTNAME, LASTNAME FROM EMPLOYEE WHERE (ID IN (?,?)) bind => [EmployeeName{firstName='Scott', lastName='Vogel'}, EmployeeName{firstName='Nick', lastName='Jett'}] Query: ReadAllQuery(referenceClass=Employee sql="SELECT ID, FIRSTNAME, LASTNAME FROM EMPLOYEE WHERE (ID IN ?)")
  6. 0

    Re: [eclipselink-users] Undetected problem mapping fields to columns

    eclipse.org | 6 months ago
    java.sql.SQLDataException: data exception: invalid character value for cast Error Code: -3438 Call: INSERT INTO ABSTRACTEVENT (ID, ATTRIB, EVENT_TYPE) VALUES (?, ?, ?) bind => [2, two, AnotherConcreteEvent] Query: InsertObjectQuery(problem.AnotherConcreteEvent@1f7cdc7) at org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:476) at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:754) at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:723) at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:393) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:120) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)

    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.SQLDataException

      A truncation error was encountered trying to shrink VARCHAR 'output/us-rfbd.EP-MN486us-rfbd.EP-MN486us-rfbd.EP-MN486%20-%&' to length 255. Error Code: 20000 Call: INSERT INTO job_option_results (MEDIATYPE, OPTIONNAME, PATH, idx, job_id) VALUES (?, ?, ?, ?, ?) bind => [5 parameters bound] Query: InsertObjectQuery(org.daisy.pipeline.persistence.jobs.PersistentOptionResult@155c49f )

      at org.eclipse.persistence.internal.jpa.transaction.EntityTransactionImpl.commitInternal()
    2. EclipseLink (non-OSGi)
      EntityTransactionImpl.commit
      1. org.eclipse.persistence.internal.jpa.transaction.EntityTransactionImpl.commitInternal(EntityTransactionImpl.java:102)[na:na]
      2. org.eclipse.persistence.internal.jpa.transaction.EntityTransactionImpl.commit(EntityTransactionImpl.java:63)[na:na]
      2 frames
    3. org.daisy.pipeline
      DefaultJobExecutionService$1.run
      1. org.daisy.pipeline.persistence.Database.updateObject(Database.java:44)[na:na]
      2. org.daisy.pipeline.persistence.jobs.PersistentJob.onStatusChanged(PersistentJob.java:149)[na:na]
      3. org.daisy.pipeline.job.Job.changeStatus(Job.java:164)[na:na]
      4. org.daisy.pipeline.job.Job.run(Job.java:197)[na:na]
      5. org.daisy.pipeline.job.DefaultJobExecutionService$1.run(DefaultJobExecutionService.java:65)[na:na]
      5 frames
    4. Java RT
      Thread.run
      1. java.lang.Thread.run(Unknown Source)[na:1.7.0_51]
      1 frame