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

              • Assignee:
                sharry.shi Sharry Shi
                Reporter:
                sharry.shi Sharry Shi
                Participants of an Issue:
                Recent user:
                Jason Pince
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Days since last comment:
                  40 weeks, 4 days ago

                  Packages

                  Version Package
                  7.3.0 CE GA1
                  Master