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

Upgrade from 6.1 to 7.0 throws java.sql.SQLSyntaxErrorException: ORA-00907

    Details

      Description

      Steps to reproduce:

      1. Execute an upgrade from 6.1 to 7.0 using staging_61305_oracle11gR2.zip

      Expected result: Portal upgrade successfully without NPE.
      Actual result: The java.sql.SQLSyntaxErrorException: ORA-00907 displayed in the console

      08:56:46,937 WARN  [main][UpgradeProcess:434] Fallback to recreating the table
      java.sql.SQLSyntaxErrorException: ORA-00907: missing right parenthesis_ [Sanitized]
      	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
      	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
      	at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1017)
      	at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:655)
      	at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:249)
      	at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:566)
      	at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:202)
      	at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:45)
      	at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:933)
      	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1075)
      	at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1640)
      	at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1603)
      	at oracle.jdbc.driver.OracleStatementWrapper.executeUpdate(OracleStatementWrapper.java:308)
      	at com.zaxxer.hikari.pool.ProxyStatement.executeUpdate(ProxyStatement.java:120)
      	at com.zaxxer.hikari.pool.HikariProxyStatement.executeUpdate(HikariProxyStatement.java)
      	at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:292)
      	at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:262)
      	at com.liferay.portal.kernel.dao.db.BaseDBProcess.runSQL(BaseDBProcess.java:66)
      	at com.liferay.portal.kernel.upgrade.UpgradeProcess.alter(UpgradeProcess.java:406)
      	at com.liferay.portal.upgrade.v6_2_0.UpgradeBlogs.updateEntries(UpgradeBlogs.java:47)
      	at com.liferay.portal.upgrade.v6_2_0.UpgradeBlogs.doUpgrade(UpgradeBlogs.java:37)
      	at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:90)
      	at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:117)
      	at com.liferay.portal.upgrade.UpgradeProcess_6_2_0.doUpgrade(UpgradeProcess_6_2_0.java:65)
      	at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:90)
      	at com.liferay.portal.upgrade.Pre7UpgradeProcess.upgrade(Pre7UpgradeProcess.java:42)
      	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)
      

        Attachments

          Activity

            People

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

              Dates

              • Created:
                Updated:
                Resolved:
                Days since last comment:
                3 years, 13 weeks ago

                Packages

                Version Package
                7.0.0 DXP FP22
                7.0.0 DXP SP4
                7.0.X EE
                7.0.4 CE GA5
                Master