Uploaded image for project: 'PUBLIC - Liferay Portal Community Edition'
  1. PUBLIC - Liferay Portal Community Edition
  2. LPS-108311

Data truncation error when adding a batch export task

    Details

      Description

      When adding a Batch import task programmatically the following exception shows in the log due to the default column length of 75 chars

      2020-02-07 18:18:47.254 ERROR [liferay/commerce/data_integration/executor-1][JDBCExceptionReporter:234] Data truncation: Data too long for column 'className' at row 12020-02-07 18:18:47.254 ERROR [liferay/commerce/data_integration/executor-1][JDBCExceptionReporter:234] Data truncation: Data too long for column 'className' at row 12020-02-07 18:18:47.293 ERROR [liferay/commerce/data_integration/executor-1][AbstractBatcher:73] Exception executing batch: org.hibernate.StaleStateException: Batch update returned unexpected row count from update [0]; actual row count: 0; expected: 1 at org.hibernate.jdbc.Expectations$BasicExpectation.checkBatched(Expectations.java:85) at org.hibernate.jdbc.Expectations$BasicExpectation.verifyOutcome(Expectations.java:70) at org.hibernate.jdbc.BatchingBatcher.checkRowCounts(BatchingBatcher.java:90) at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70) at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:268) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:185) at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321) at com.liferay.portal.dao.orm.hibernate.event.NestableFlushEventListener.onFlush(NestableFlushEventListener.java:61) at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1216) at com.liferay.portal.spring.hibernate.PortletTransactionManager$TransactionStatusWrapper.reset(PortletTransactionManager.java:260) at com.liferay.portal.spring.hibernate.PortletTransactionManager.rollback(PortletTransactionManager.java:145) at com.liferay.portal.spring.transaction.DefaultTransactionExecutor._rollback(DefaultTransactionExecutor.java:227) at com.liferay.portal.spring.transaction.DefaultTransactionExecutor._execute(DefaultTransactionExecutor.java:206) at com.liferay.portal.spring.transaction.DefaultTransactionExecutor.execute(DefaultTransactionExecutor.java:94) at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:110) at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:130) at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:55) at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:130) at com.liferay.portal.spring.aop.ServiceBeanAopProxy.invoke(ServiceBeanAopProxy.java:125) at com.sun.proxy.$Proxy499.addBatchEngineImportTask(Unknown Source) 

       

        Attachments

          Activity

            People

            Assignee:
            brian.chan Brian Chan
            Reporter:
            riccardo.ferrari Riccardo Ferrari
            Participants of an Issue:
            Recent user:
            Clarissa Velazquez
            Engineering Assignee:
            Riccardo Ferrari
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:
              Days since last comment:
              1 year, 32 weeks, 4 days ago

                Packages

                Version Package
                7.1.10 DXP FP17
                7.1.10.4 SP4
                7.1.X
                7.2.10 DXP FP5
                7.2.10.2 DXP SP2
                7.2.X