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:
            Brian Wulbern
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:
              Days since last comment:
              2 years, 40 weeks, 1 day ago

                Packages

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