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

Upgrade: Duplicate entry '20155-Single Approver-1.0' for key 'IX_AE02DCC'

    Details

      Description

      Steps to reproduce upgrading from 6.2.10 to 7.1.10

      1. Create a secundary portal instance in 6.2.10
      2. Login in to the second instance and edit the Single Approver workflow, you do not need to do changes, only generate a new version.
      3. In the second instance, generate another version of the single approver, v3, also without changes.
      4. Configure the 7.1.10 for upgrading the same database.
      5. Launch the upgrade tool and you will get in logs the next error:
      2019-02-20 16:18:46.247 INFO  [main][VerifyProcess:80] Completed verification process com.liferay.portal.workflow.kaleo.designer.web.internal.verify.KaleoDesignerWebVerifyProcess in 85 ms
      INFO - Completed verification process com.liferay.portal.workflow.kaleo.designer.web.internal.verify.KaleoDesignerWebVerifyProcess in 85 ms
      2019-02-20 16:18:46.511 ERROR [main][JDBCExceptionReporter:234] Duplicate entry '20155-Single Approver-1.0' for key 'IX_AE02DCC'
      2019-02-20 16:18:46.520 ERROR [main][com_liferay_portal_workflow_kaleo_runtime_impl:97] bundle com.liferay.portal.workflow.kaleo.runtime.impl:4.0.0 (270)[com.liferay.portal.workflow.kaleo.runtime.internal.activator.KaleoActivator(873)] : The activate method has thrown an exception
      org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
      	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:96)
      	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
      	at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275)
      	at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:268)
      	at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:184)
      	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.commit(PortletTransactionManager.java:63)
      	at com.liferay.portal.spring.transaction.DefaultTransactionExecutor._commit(DefaultTransactionExecutor.java:89)
      	at com.liferay.portal.spring.transaction.DefaultTransactionExecutor._execute(DefaultTransactionExecutor.java:136)
      	at com.liferay.portal.spring.transaction.DefaultTransactionExecutor.execute(DefaultTransactionExecutor.java:51)
      	at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:59)
      	at com.liferay.portal.spring.aop.AopMethodInvocation.proceed(AopMethodInvocation.java:51)
      	at com.liferay.portal.service.ServiceContextAdvice.invoke(ServiceContextAdvice.java:46)
      	at com.liferay.portal.spring.aop.AopMethodInvocation.proceed(AopMethodInvocation.java:51)
      	at com.liferay.portal.spring.aop.AopInvocationHandler.invoke(AopInvocationHandler.java:44)
      	at com.sun.proxy.$Proxy443.addKaleoDefinition(Unknown Source)
      	at com.liferay.portal.workflow.kaleo.definition.internal.deployment.DefaultWorkflowDeployer._addOrUpdateKaleoDefinition(DefaultWorkflowDeployer.java:234)
      	at com.liferay.portal.workflow.kaleo.definition.internal.deployment.DefaultWorkflowDeployer.deploy(DefaultWorkflowDeployer.java:86)
      	at com.liferay.portal.workflow.kaleo.runtime.internal.DefaultWorkflowEngineImpl.deployWorkflowDefinition(DefaultWorkflowEngineImpl.java:159)
      	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
      	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      	at java.lang.reflect.Method.invoke(Method.java:498)
      	at com.liferay.portal.spring.aop.AopMethodInvocation.proceed(AopMethodInvocation.java:44)
      	at com.liferay.portal.spring.transaction.TransactionInterceptor.lambda$invoke$0(TransactionInterceptor.java:61)
      	at com.liferay.portal.spring.transaction.DefaultTransactionExecutor._execute(DefaultTransactionExecutor.java:128)
      	at com.liferay.portal.spring.transaction.DefaultTransactionExecutor.execute(DefaultTransactionExecutor.java:51)
      	at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:59)
      	at com.liferay.portal.spring.aop.AopMethodInvocation.proceed(AopMethodInvocation.java:51)
      	at com.liferay.portal.service.ServiceContextAdvice.invoke(ServiceContextAdvice.java:46)
      	at com.liferay.portal.spring.aop.AopMethodInvocation.proceed(AopMethodInvocation.java:51)
      	at com.liferay.portal.spring.aop.AopInvocationHandler.invoke(AopInvocationHandler.java:44)
      	at com.sun.proxy.$Proxy465.deployWorkflowDefinition(Unknown Source)
      	at com.liferay.portal.workflow.kaleo.runtime.integration.internal.WorkflowDefinitionManagerImpl.deployWorkflowDefinition(WorkflowDefinitionManagerImpl.java:89)
      	at com.liferay.portal.workflow.kaleo.runtime.internal.manager.DefaultPortalKaleoManager.deployDefaultDefinitions(DefaultPortalKaleoManager.java:174)
      	at com.liferay.portal.workflow.kaleo.runtime.internal.manager.DefaultPortalKaleoManager.deployDefaultDefinitions(DefaultPortalKaleoManager.java:129)
      	at com.liferay.portal.workflow.kaleo.runtime.internal.manager.DefaultPortalKaleoManager.deployKaleoDefaults(DefaultPortalKaleoManager.java:215)
      	at com.liferay.portal.workflow.kaleo.runtime.internal.activator.KaleoActivator.activate(KaleoActivator.java:35)

        Attachments

          Activity

            People

            • Assignee:
              joyce.wang Joyce Wang
              Reporter:
              jose.jimenez Jose Jimenez
              Participants of an Issue:
              Recent user:
              Clarissa Velazquez
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:
                Days since last comment:
                36 weeks, 5 days ago

                Packages

                Version Package
                7.1.10 DXP FP9
                7.1.10.2 SP2
                7.1.3 CE GA4
                7.1.X
                Master