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:
                1 year, 27 weeks, 1 day ago

                  Packages

                  Version Package
                  7.3.0 CE GA1
                  7.3.10 DXP GA1
                  Master