Details

    Description

      Steps to Reproduce

      1. Start 7.0 ga1 with sybase
      2. Upgrade from 7.0 to master
      3. You will see the error

      Expect Result
      Upgrade successfully.

      Actually Result
      Fail to upgrade with following error

      2019-11-27 14:52:23.255 INFO  [main][UpgradeProcess:107] Failed upgrade process com.liferay.portal.upgrade.PortalUpgradeProcess in 1148180 ms
      com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: com.sybase.jdbc4.jdbc.SybSQLException: Incorrect syntax near the keyword 'IF'.
              at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:101)
              at com.liferay.portal.kernel.upgrade.util.UpgradeProcessUtil._upgradeProcess(UpgradeProcessUtil.java:173)
              at com.liferay.portal.kernel.upgrade.util.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:140)
              at com.liferay.portal.kernel.upgrade.util.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:122)
              at com.liferay.portal.events.StartupHelperUtil.upgradeProcess(StartupHelperUtil.java:151)
              at com.liferay.portal.tools.DBUpgrader.upgrade(DBUpgrader.java:183)
              at com.liferay.portal.tools.DBUpgrader.main(DBUpgrader.java:109)
              at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
              at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
              at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
              at java.lang.reflect.Method.invoke(Method.java:498)
              at com.liferay.portal.tools.db.upgrade.client.DBUpgraderLauncher.main(DBUpgraderLauncher.java:55)
      Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: com.sybase.jdbc4.jdbc.SybSQLException: Incorrect syntax near the keyword 'IF'.
              at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:101)
              at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:123)
              at com.liferay.portal.upgrade.PortalUpgradeProcess.doUpgrade(PortalUpgradeProcess.java:129)
              at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:96)
              ... 11 more
      Caused by: com.sybase.jdbc4.jdbc.SybSQLException: Incorrect syntax near the keyword 'IF'.
              at com.sybase.jdbc4.tds.Tds.processEed(Tds.java:4131)
              at com.sybase.jdbc4.tds.Tds.nextResult(Tds.java:3247)
              at com.sybase.jdbc4.jdbc.ResultGetter.nextResult(ResultGetter.java:78)
              at com.sybase.jdbc4.jdbc.SybStatement.nextResult(SybStatement.java:294)
              at com.sybase.jdbc4.jdbc.SybStatement.nextResult(SybStatement.java:276)
              at com.sybase.jdbc4.jdbc.SybStatement.updateLoop(SybStatement.java:2749)
              at com.sybase.jdbc4.jdbc.SybStatement.executeUpdate(SybStatement.java:2733)
              at com.sybase.jdbc4.jdbc.SybStatement.executeUpdate(SybStatement.java:588)
              at com.zaxxer.hikari.pool.ProxyStatement.executeUpdate(ProxyStatement.java:117)
              at com.zaxxer.hikari.pool.HikariProxyStatement.executeUpdate(HikariProxyStatement.java)
              at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:349)
              at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:315)
              at com.liferay.portal.kernel.dao.db.BaseDBProcess.runSQL(BaseDBProcess.java:66)
              at com.liferay.portal.upgrade.v7_3_x.UpgradeLayout.doUpgrade(UpgradeLayout.java:51)
              at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:96)
              ... 14 more
      

      Attachments

        Issue Links

          Activity

            People

              sharry.shi Sharry Shi
              sharry.shi Sharry Shi
              Marta Elicegui Marta Elicegui
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:
                2 years, 50 weeks, 5 days ago

                Packages

                  Version Package
                  7.3.0 CE GA1
                  7.3.10 DXP GA1
                  Master