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

ConvertPermissionAlgorithm exception when upgrade user permission algorithm from 2 to 5

    Details

    • OS:
      Red Hat Enterprise 6
    • JDK:
      Oracle Sun JDK 6
    • Application Servers:
      Apache Tomcat 6.0
    • Databases:
      DB2 9.7

      Description

      Hi Liferay team and experts,

      I really need help in Liferay upgrade. There is a task to upgrade our Liferay EE version 6.0.11 to the latest one(or 6.2 GA5 CE).

      Since we are using user permission algorithm version 2, my first step is to set,
      permissions.user.check.algorithm=5
      permissions.view.dynamic.inheritance=false
      and restart Liferay.

      In control panel, click "convert legacy permission algorithm". However, hit an exception, the log says

      _27 Jan 2016 02:29:00,689 INFO [Table:432] Finished backup of ResourcePermissionView to /opt/demandtec/thirdparty/servers/tomcat/temp/temp-db-ResourcePermissionView-1453890540664 in 25 ms
      27 Jan 2016 02:29:00,692 INFO [Table:396] Starting backup of ResourcePermissionView to /opt/demandtec/thirdparty/servers/tomcat/temp/temp-db-ResourcePermissionView-1453890540692
      27 Jan 2016 02:29:00,716 INFO [Table:432] Finished backup of ResourcePermissionView to /opt/demandtec/thirdparty/servers/tomcat/temp/temp-db-ResourcePermissionView-1453890540692 in 24 ms
      27 Jan 2016 02:29:00,717 WARN [ConvertPermissionAlgorithm:405] Could not find resource action Password_WAR_Resetpasswordportlet#ADD_TO_PAGE
      27 Jan 2016 02:29:00,717 WARN [ConvertPermissionAlgorithm:405] Could not find resource action Password_WAR_Resetpasswordportlet#ADD_TO_PAGE
      27 Jan 2016 02:29:00,718 WARN [ConvertPermissionAlgorithm:405] Could not find resource action Password_WAR_Resetpasswordportlet#ADD_TO_PAGE
      27 Jan 2016 02:29:00,719 WARN [ConvertPermissionAlgorithm:405] Could not find resource action Password_WAR_Resetpasswordportlet#ADD_TO_PAGE
      27 Jan 2016 02:29:00,726 ERROR [JDBCExceptionReporter:234] DB2 SQL error: SQLCODE: -302, SQLSTATE: 22001, SQLERRMC: null
      27 Jan 2016 02:29:00,733 FATAL [ConvertProcessMessageListener:35] Unable to process message

      {destinationName=liferay/convert_process, response=null, responseDestinationName=null, responseId=null, payload=com.liferay.portal.convert.ConvertPermissionAlgorithm, values=null}

      com.liferay.portal.convert.ConvertException: com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.DataException: could not execute query
      at com.liferay.portal.convert.ConvertProcess.convert(ConvertProcess.java:53)
      at com.liferay.portal.convert.messaging.ConvertProcessMessageListener.doReceive(ConvertProcessMessageListener.java:47)
      at com.liferay.portal.convert.messaging.ConvertProcessMessageListener.receive(ConvertProcessMessageListener.java:32)
      at com.liferay.portal.kernel.messaging.InvokerMessageListener.receive(InvokerMessageListener.java:63)
      at com.liferay.portal.kernel.messaging.SerialDestination$1.run(SerialDestination.java:59)
      at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
      at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
      at java.lang.Thread.run(Thread.java:662)
      Caused by: com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.DataException: could not execute query
      at com.liferay.portal.service.persistence.impl.BasePersistenceImpl.processException(BasePersistenceImpl.java:190)
      at com.liferay.portal.service.persistence.ResourceActionPersistenceImpl.findByName(ResourceActionPersistenceImpl.java:536)
      at com.liferay.portal.service.persistence.ResourceActionPersistenceImpl.findByName(ResourceActionPersistenceImpl.java:436)
      at com.liferay.portal.service.impl.ResourceActionLocalServiceImpl.checkResourceActions(ResourceActionLocalServiceImpl.java:65)
      at sun.reflect.GeneratedMethodAccessor97.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:597)
      at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
      at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:86)
      at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:58)
      at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:58)
      at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:58)
      at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:58)
      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)
      at $Proxy67.checkResourceActions(Unknown Source)
      at com.liferay.portal.service.ResourceActionLocalServiceUtil.checkResourceActions(ResourceActionLocalServiceUtil.java:240)_

      Any help?

      Thanks,

      XingYi

        Attachments

          Activity

            People

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

              Dates

              • Created:
                Updated:
                Days since last comment:
                4 years, 2 weeks ago

                Packages

                Version Package