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

Upgrade fails on Sybase "Invalid Column Name"

    Details

      Description

      Reproduced on:
      Sybase 16 + ee-7.0.x GIT ID: 80013dc8c6d2b166c0a9360ed6b99e7f86615289.
      Sybase 16 + DXP FP4
      Sybase 16 + DXP FP3

      Blocked from testing on DXP GA1 and DXP FP2 by LPS-67249.

      Steps to Reproduce:

      1. Import attached dump into Sybase 16
        Following should be set in Sybase:
        sp_configure "default character set id", 190
        sp_configure "default sortorder id", 50
        
      2. Run Upgrade

      Expected Result:
      Upgrade completes successfully.

      Actual Result:
      Upgrade stops due to error:

      21:08:00,276 INFO  [main][LoggingTimer:38] Completed com.liferay.portal.upgrade.v7_0_3.UpgradeMessageBoards#deleteEmptyMBDiscussion in 5 ms
      21:08:00,277 INFO  [main][UpgradeProcess:97] Completed upgrade process com.liferay.portal.upgrade.v7_0_3.UpgradeMessageBoards in 6ms
      21:08:00,277 INFO  [main][UpgradeProcess:97] Completed upgrade process com.liferay.portal.upgrade.UpgradeProcess_7_0_3 in 7ms
      com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: com.sybase.jdbc4.jdbc.SybSQLException: Invalid column name 'messagecount'.
      
             	at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:91)
             	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:157)
             	at com.liferay.portal.tools.DBUpgrader.main(DBUpgrader.java:103)
      Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: com.sybase.jdbc4.jdbc.SybSQLException: Invalid column name 'messagecount'.
      
             	at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:91)
             	at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:115)
             	at com.liferay.portal.upgrade.UpgradeProcess_7_0_3.doUpgrade(UpgradeProcess_7_0_3.java:33)
             	at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:88)
             	... 7 more
      Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: com.sybase.jdbc4.jdbc.SybSQLException: Invalid column name 'messagecount'.
      
             	at com.liferay.portal.upgrade.v7_0_3.UpgradeMessageBoards.deleteEmptyMBDiscussion(UpgradeMessageBoards.java:68)
             	at com.liferay.portal.upgrade.v7_0_3.UpgradeMessageBoards.doUpgrade(UpgradeMessageBoards.java:74)
             	at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:88)
             	... 10 more
      Caused by: com.sybase.jdbc4.jdbc.SybSQLException: Invalid column name 'messagecount'.
      
             	at com.sybase.jdbc4.tds.Tds.processEed(Tds.java:4003)
             	at com.sybase.jdbc4.tds.Tds.nextResult(Tds.java:3093)
             	at com.sybase.jdbc4.jdbc.ResultGetter.nextResult(ResultGetter.java:78)
             	at com.sybase.jdbc4.jdbc.SybStatement.nextResult(SybStatement.java:289)
             	at com.sybase.jdbc4.jdbc.SybStatement.nextResult(SybStatement.java:271)
             	at com.sybase.jdbc4.jdbc.SybStatement.updateLoop(SybStatement.java:2514)
             	at com.sybase.jdbc4.jdbc.SybStatement.executeUpdate(SybStatement.java:2498)
             	at com.sybase.jdbc4.jdbc.SybStatement.executeUpdate(SybStatement.java:576)
             	at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:291)
             	at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:261)
             	at com.liferay.portal.kernel.dao.db.BaseDBProcess.runSQL(BaseDBProcess.java:52)
             	at com.liferay.portal.upgrade.v7_0_3.UpgradeMessageBoards.deleteEmptyMBDiscussion(UpgradeMessageBoards.java:48)
             	... 12 more
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                victor.ware Victor Ware
                Reporter:
                victor.ware Victor Ware
                Participants of an Issue:
                Recent user:
                Csaba Turcsan
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Days since last comment:
                  2 years, 42 weeks, 6 days ago

                  Packages

                  Version Package
                  7.0.0 DXP FP5
                  7.0.0 DXP SP1
                  7.0.3 CE GA4
                  Master