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

Upgrading permissions algorithm in the Control Panel on 5.2.3 causes errors across multiple environments

    Details

    • Type: Bug
    • Status: Closed
    • Resolution: Won't Fix
    • Affects Version/s: 5.2.3
    • Fix Version/s: 6.0.12 EE
    • Labels:
      None
    • Environment:
    • Fix Priority:
      3

      Description

      When converting legacy permissions algorithm in 5.2.3 in the Control Panel in the environments listed, you get errors in the console.

      1. Navigate to Control Panel > Server Administration
      2. Click on the Data Migration tab
      3. Click 'Execute' to convert legacy permissions algorithm
      4. You get the following errors in the console

      DB2 9.7

      18:38:27,595 DEBUG [MaintenanceUtil:75] Generating ResourceAction and ResourcePermission data
      18:38:27,647 FATAL [ConvertPermissionAlgorithm:131] com.ibm.db2.jcc.a.nn: DB2 SQL Error: SQLCODE=-119, SQLSTATE=42803, SQLERRMC=CODEID, DRIVER=3.52.95
      com.ibm.db2.jcc.a.nn: DB2 SQL Error: SQLCODE=-119, SQLSTATE=42803, SQLERRMC=CODEID, DRIVER=3.52.95
              at com.ibm.db2.jcc.a.ad.a(ad.java:666)
              at com.ibm.db2.jcc.a.ad.a(ad.java:60)
              at com.ibm.db2.jcc.a.ad.a(ad.java:127)
              at com.ibm.db2.jcc.a.rl.c(rl.java:2424)
              at com.ibm.db2.jcc.a.rl.d(rl.java:2401)
              at com.ibm.db2.jcc.a.rl.a(rl.java:1902)
              at com.ibm.db2.jcc.t4.db.g(db.java:138)
              at com.ibm.db2.jcc.t4.db.a(db.java:38)
              at com.ibm.db2.jcc.t4.t.a(t.java:32)
              at com.ibm.db2.jcc.t4.sb.h(sb.java:141)
              at com.ibm.db2.jcc.a.rl.Y(rl.java:1873)
              at com.ibm.db2.jcc.a.sl.bc(sl.java:2526)
              at com.ibm.db2.jcc.a.sl.gc(sl.java:2632)
              at com.ibm.db2.jcc.a.sl.a(sl.java:443)
              at com.ibm.db2.jcc.a.ib.a(ib.java:2016)
              at com.ibm.db2.jcc.a.ib.prepareStatement(ib.java:639)
              at com.mchange.v2.c3p0.impl.NewProxyConnection.prepareStatement(NewProxyConnection.java:213)
              at sun.reflect.GeneratedMethodAccessor55.invoke(Unknown Source)
              at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
              at java.lang.reflect.Method.invoke(Method.java:585)
              at org.springframework.jdbc.datasource.LazyConnectionDataSourceProxy$LazyConnectionInvocationHandler.invoke(LazyConnectionDataSourceProxy.java:364)
              at $Proxy0.prepareStatement(Unknown Source)
              at com.liferay.portal.upgrade.util.Table.generateTempFile(Table.java:369)
              at com.liferay.portal.convert.ConvertPermissionAlgorithm._convertToBitwise(ConvertPermissionAlgorithm.java:157)
              at com.liferay.portal.convert.ConvertPermissionAlgorithm.doConvert(ConvertPermissionAlgorithm.java:124)
              at com.liferay.portal.convert.ConvertProcess.convert(ConvertProcess.java:41)
              at com.liferay.portal.convert.messaging.ConvertProcessMessageListener.doReceive(ConvertProcessMessageListener.java:59)
              at com.liferay.portal.convert.messaging.ConvertProcessMessageListener.receive(ConvertProcessMessageListener.java:44)
              at com.liferay.portal.kernel.messaging.InvokerMessageListener.receive(InvokerMessageListener.java:70)
              at com.liferay.portal.kernel.messaging.SerialDestination$1.run(SerialDestination.java:54)
              at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650)
              at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675)
              at java.lang.Thread.run(Thread.java:595)
      18:38:27,650 INFO  [ConvertProcess:43] Conversion complete

      Oracle 10.2

      20:25:19,058 DEBUG [MaintenanceUtil:75] Generating ResourceAction and ResourcePermission data
      20:25:19,064 FATAL [ConvertPermissionAlgorithm:131] java.sql.SQLException: ORA-00979: not a GROUP BY expression
      
      java.sql.SQLException: ORA-00979: not a GROUP BY expression
      
              at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
              at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
              at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)
              at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)
              at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
              at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)
              at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:205)
              at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:861)
              at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1145)
              at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1267)
              at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449)
              at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3493)
              at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1203)
              at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
              at com.liferay.portal.upgrade.util.Table.generateTempFile(Table.java:371)
              at com.liferay.portal.convert.ConvertPermissionAlgorithm._convertToBitwise(ConvertPermissionAlgorithm.java:157)
              at com.liferay.portal.convert.ConvertPermissionAlgorithm.doConvert(ConvertPermissionAlgorithm.java:124)
              at com.liferay.portal.convert.ConvertProcess.convert(ConvertProcess.java:41)
              at com.liferay.portal.convert.messaging.ConvertProcessMessageListener.doReceive(ConvertProcessMessageListener.java:59)
              at com.liferay.portal.convert.messaging.ConvertProcessMessageListener.receive(ConvertProcessMessageListener.java:44)
              at com.liferay.portal.kernel.messaging.InvokerMessageListener.receive(InvokerMessageListener.java:70)
              at com.liferay.portal.kernel.messaging.SerialDestination$1.run(SerialDestination.java:54)
              at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650)
              at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675)
              at java.lang.Thread.run(Thread.java:595)
      20:25:19,066 INFO  [ConvertProcess:43] Conversion complete

      PostgreSQL 9

      20:47:21,380 DEBUG [MaintenanceUtil:75] Generating ResourceAction and ResourcePermission data
      20:47:21,403 FATAL [ConvertPermissionAlgorithm:131] org.postgresql.util.PSQLException: ERROR: column "resourcecode.codeid" must appear in the GROUP BY clause or be used in an aggregate function
      org.postgresql.util.PSQLException: ERROR: column "resourcecode.codeid" must appear in the GROUP BY clause or be used in an aggregate function
              at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1608)
              at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1343)
              at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:194)
              at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451)
              at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:350)
              at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:254)
              at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
              at com.liferay.portal.upgrade.util.Table.generateTempFile(Table.java:371)
              at com.liferay.portal.convert.ConvertPermissionAlgorithm._convertToBitwise(ConvertPermissionAlgorithm.java:157)
              at com.liferay.portal.convert.ConvertPermissionAlgorithm.doConvert(ConvertPermissionAlgorithm.java:124)
              at com.liferay.portal.convert.ConvertProcess.convert(ConvertProcess.java:41)
              at com.liferay.portal.convert.messaging.ConvertProcessMessageListener.doReceive(ConvertProcessMessageListener.java:59)
              at com.liferay.portal.convert.messaging.ConvertProcessMessageListener.receive(ConvertProcessMessageListener.java:44)
              at com.liferay.portal.kernel.messaging.InvokerMessageListener.receive(InvokerMessageListener.java:70)
              at com.liferay.portal.kernel.messaging.SerialDestination$1.run(SerialDestination.java:54)
              at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650)
              at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675)
              at java.lang.Thread.run(Thread.java:595)
      20:47:21,407 INFO  [ConvertProcess:43] Conversion complete

      SQL Server 2008

      20:57:35,783 DEBUG [MaintenanceUtil:75] Generating ResourceAction and ResourcePermission data
      20:57:35,792 FATAL [ConvertPermissionAlgorithm:131] java.sql.SQLException: Column 'ResourceCode.codeId' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
      java.sql.SQLException: Column 'ResourceCode.codeId' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
              at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
              at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2820)
              at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2258)
              at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:632)
              at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:477)
              at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:776)
              at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
              at com.liferay.portal.upgrade.util.Table.generateTempFile(Table.java:371)
              at com.liferay.portal.convert.ConvertPermissionAlgorithm._convertToBitwise(ConvertPermissionAlgorithm.java:157)
              at com.liferay.portal.convert.ConvertPermissionAlgorithm.doConvert(ConvertPermissionAlgorithm.java:124)
              at com.liferay.portal.convert.ConvertProcess.convert(ConvertProcess.java:41)
              at com.liferay.portal.convert.messaging.ConvertProcessMessageListener.doReceive(ConvertProcessMessageListener.java:59)
              at com.liferay.portal.convert.messaging.ConvertProcessMessageListener.receive(ConvertProcessMessageListener.java:44)
              at com.liferay.portal.kernel.messaging.InvokerMessageListener.receive(InvokerMessageListener.java:70)
              at com.liferay.portal.kernel.messaging.SerialDestination$1.run(SerialDestination.java:54)
              at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650)
              at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675)
              at java.lang.Thread.run(Thread.java:595)
      20:57:35,794 INFO  [ConvertProcess:43] Conversion complete

      Sybase 15.02

      19:40:04,928 DEBUG [MaintenanceUtil:75] Generating ResourceAction and ResourcePermission data
      19:40:05,019 FATAL [ConvertPermissionAlgorithm:131] java.sql.SQLException: Invalid column name '100'.
      
      java.sql.SQLException: Invalid column name '100'.
      
              at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
              at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2820)
              at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2258)
              at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:632)
              at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:477)
              at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:776)
              at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
              at com.liferay.portal.upgrade.util.Table.generateTempFile(Table.java:371)
              at com.liferay.portal.convert.ConvertPermissionAlgorithm._convertResourcePermission(ConvertPermissionAlgorithm.java:365)
              at com.liferay.portal.convert.ConvertPermissionAlgorithm._convertToBitwise(ConvertPermissionAlgorithm.java:181)
              at com.liferay.portal.convert.ConvertPermissionAlgorithm.doConvert(ConvertPermissionAlgorithm.java:124)
              at com.liferay.portal.convert.ConvertProcess.convert(ConvertProcess.java:41)
              at com.liferay.portal.convert.messaging.ConvertProcessMessageListener.doReceive(ConvertProcessMessageListener.java:59)
              at com.liferay.portal.convert.messaging.ConvertProcessMessageListener.receive(ConvertProcessMessageListener.java:44)
              at com.liferay.portal.kernel.messaging.InvokerMessageListener.receive(InvokerMessageListener.java:70)
              at com.liferay.portal.kernel.messaging.SerialDestination$1.run(SerialDestination.java:54)
              at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650)
              at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675)
              at java.lang.Thread.run(Thread.java:595)
      19:40:05,021 INFO  [ConvertProcess:43] Conversion complete

        Attachments

          Activity

            People

            • Assignee:
              albert.lee Albert Lee
              Reporter:
              albert.lee Albert Lee
              Participants of an Issue:
              Recent user:
              Esther Sanz
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:
                Days since last comment:
                5 years, 49 weeks, 3 days ago

                Packages

                Version Package
                6.0.12 EE