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

Unable to move file from Repo to Home folder

    Details

    • Type: Regression Bug
    • Status: Closed
    • Resolution: Duplicate
    • Affects Version/s: 6.2.0 CE M3
    • Fix Version/s: 6.1.30 EE GA3, 6.2.0 CE M5
    • Component/s: DM
    • Labels:
      None
    • Environment:
      Tomcat 7.0 + MySQL 5. Portal 6.2.x GIT ID: b8b08350ea430cb0b6a601d1b88a3272436efaad.
    • Fix Priority:
      4

      Description

      Unable to move file from a Repository to Home Root folder.

      Steps to reproduce:

      1. Start Alfresco VM (You can also use a Nuxeo repo)
      2. Create user admin with password:admin with Administration role
      3. Add Alfresco Repository
      4. Add basic document to Alfresco Repository
      5. Click dropdown next to basic document and click move
      6. Select Home folder
      7. Click Move
        Results: Error in the document portal (see attached picture) and console error:
        17:43:05,898 ERROR [liferay/async_service-1][ParallelDestination:71] Unable to process message {destinationName=liferay/async_service, response=null, responseDestinationName=null, responseId=null, payload=com.liferay.portlet.social.service.SocialActivityLocalService.addActivity(com.liferay.portlet.s
        ocial.model.SocialActivity,com.liferay.portlet.social.model.SocialActivity)@com.liferay.portlet.social.service.impl.SocialActivityLocalServiceImpl, values={principalPassword=********, permissionChecker=com.liferay.portal.kernel.util.TransientValue@e3a7d65, principalName=10447, companyId=10152}}
        com.liferay.portal.kernel.messaging.MessageListenerException: java.lang.RuntimeException: org.springframework.dao.DataIntegrityViolationException: Could not execute JDBC batch update; SQL [insert into SocialActivity (groupId, companyId, userId, createDate, mirrorActivityId, classNameId, classPK, typ
        e_, extraData, receiverUserId, activityId) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; constraint [null]; nested exception is org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
                at com.liferay.portal.kernel.messaging.BaseMessageListener.receive(BaseMessageListener.java:31)
                at com.liferay.portal.kernel.messaging.InvokerMessageListener.receive(InvokerMessageListener.java:63)
                at com.liferay.portal.kernel.messaging.ParallelDestination$1.run(ParallelDestination.java:68)
                at com.liferay.portal.kernel.concurrent.ThreadPoolExecutor$WorkerTask._runTask(ThreadPoolExecutor.java:675)
                at com.liferay.portal.kernel.concurrent.ThreadPoolExecutor$WorkerTask.run(ThreadPoolExecutor.java:586)
                at java.lang.Thread.run(Thread.java:662)
        Caused by: java.lang.RuntimeException: org.springframework.dao.DataIntegrityViolationException: Could not execute JDBC batch update; SQL [insert into SocialActivity (groupId, companyId, userId, createDate, mirrorActivityId, classNameId, classPK, type_, extraData, receiverUserId, activityId) values (
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; constraint [null]; nested exception is org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
                at com.liferay.portal.messaging.async.AsyncAdvice$2.run(AsyncAdvice.java:79)
                at com.liferay.portal.messaging.async.AsyncMessageListener.doReceive(AsyncMessageListener.java:30)
                at com.liferay.portal.kernel.messaging.BaseMessageListener.receive(BaseMessageListener.java:25)
                ... 5 more
        Caused by: org.springframework.dao.DataIntegrityViolationException: Could not execute JDBC batch update; SQL [insert into SocialActivity (groupId, companyId, userId, createDate, mirrorActivityId, classNameId, classPK, type_, extraData, receiverUserId, activityId) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?
        , ?)]; constraint [null]; nested exception is org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
                at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:637)
                at org.springframework.orm.hibernate3.HibernateTransactionManager.convertHibernateAccessException(HibernateTransactionManager.java:793)
                at org.springframework.orm.hibernate3.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:664)
                at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:754)
                at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:723)
                at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:78)
                at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:118)
                at com.liferay.portal.messaging.async.AsyncAdvice$2.run(AsyncAdvice.java:76)
                ... 7 more
        Caused by: 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 org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:51)
                at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1216)
                at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:383)
                at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:133)
                at org.springframework.orm.hibernate3.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:656)
                ... 12 more
        

        Attachments

          Issue Links

            Activity

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Days since last comment:
                  6 years, 35 weeks, 1 day ago

                  Packages

                  Version Package
                  6.1.30 EE GA3
                  6.2.0 CE M5