Upgrade fails on Sybase "Invalid Column Name"

• Type: Regression Bug
• Status: Closed
• Resolution: Fixed
• Affects Version/s: 7.0.0 DXP FP3, 7.0.0 DXP FP4, 7.0.0 DXP SP1
• Fix Version/s: 7.0.0 DXP FP5, 7.0.0 DXP SP1, 7.0.3 CE GA4, Master
• Component/s: Environments, Environments > App Servers
• Labels:
  • QA-AUTOMATION
  • QA-M
  • liferay-digital-enterprise-70-sp1
  • liferay-fixpack-de-5-7010
• Branch Version/s:
  7.0.x
• Backported to Branch:
  Committed
• Fix Priority: 5
• Git Pull Request: https://github.com/brianchandotcom/liferay-portal-ee/pull/14432

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