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

DXP upgrade fails with MVCCVersion invalid identifier if there are multiple users in Oracle

    Details

      Description

      Description
      DXP upgrade fails with MVCCVersion invalid identifier if there are multiple users in Oracle

      Steps to reproduce/Testing done

      1. Create two users/databases in Oracle, lportal and lportal2
      2. Start Liferay 6.1 GA2 (latest fixpacks) connected to lportal and add a web content display portlet with a web content article
      3. Stop Liferay
      4. Start Liferay 6.1 GA2 (latest fixpacks)connected to lportal2 and add a web content display portlet with a web content article
      5. Stop Liferay
      6. Upgrade lportal to DXP (de-12)
        • Notice it completes normally
      7. Upgrade lportal2 to DXP (de-12)
      8. Notice the following errors which result in the upgrade process ending abruptly
        18:43:37,070 INFO  [main][UpgradeProcess:98] Completed upgrade process com.liferay.portal.upgrade.UpgradeProcess_7_0_0 in 3391ms
        com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: java.sql.SQLSyntaxErrorException: ORA-00904: "MVCCVERSION": invalid identifier
        
                at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:92)
                at com.liferay.portal.kernel.upgrade.util.UpgradeProcessUtil._upgradeProcess(UpgradeProcessUtil.java:175)
                at com.liferay.portal.kernel.upgrade.util.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:143)
                at com.liferay.portal.kernel.upgrade.util.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:125)
                at com.liferay.portal.events.StartupHelper.upgradeProcess(StartupHelper.java:164)
                at com.liferay.portal.events.StartupHelperUtil.upgradeProcess(StartupHelperUtil.java:81)
                at com.liferay.portal.tools.DBUpgrader.upgrade(DBUpgrader.java:153)
                at com.liferay.portal.tools.DBUpgrader.main(DBUpgrader.java:99)
        Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: java.sql.SQLSyntaxErrorException: ORA-00904: "MVCCVERSION": invalid identifier
        
                at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:92)
                at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:116)
                at com.liferay.portal.upgrade.UpgradeProcess_7_0_0.doUpgrade(UpgradeProcess_7_0_0.java:75)
                at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:89)
                ... 7 more
        Caused by: java.sql.SQLSyntaxErrorException: ORA-00904: "MVCCVERSION": invalid identifier
        
                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.executeForRows(T4CPreparedStatement.java:1008)
                at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1307)
                at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449)
                at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3530)
                at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1350)
                at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeUpdate(ProxyPreparedStatement.java:61)
                at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeUpdate(HikariProxyPreparedStatement.java)
                at com.liferay.portal.upgrade.v7_0_0.UpgradeDocumentLibrary.addClassName(UpgradeDocumentLibrary.java:65)
                at com.liferay.portal.upgrade.v7_0_0.UpgradeDocumentLibrary.updateRepositoryClassNameIds(UpgradeDocumentLibrary.java:499)
                at com.liferay.portal.upgrade.v7_0_0.UpgradeDocumentLibrary.doUpgrade(UpgradeDocumentLibrary.java:117)
                at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:89)
                ... 10 more
        

        Attachments

          Activity

            People

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

              Dates

              • Created:
                Updated:
                Resolved:
                Days since last comment:
                2 years, 30 weeks, 3 days ago

                Packages

                Version Package
                7.0.0 DXP FP14
                7.0.0 DXP SP3
                7.0.3 CE GA4
                7.0.X EE
                7.1.X
                Master