-
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
-
Branch Version/s:7.0.x
-
Backported to Branch:Committed
-
Fix Priority:5
-
Git Pull Request:
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:
- 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
- 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
- is caused by
-
LPS-66133 Comment thread objects (MBDiscussion, MBThread and root MBMessage) are created during asset creation, but that it is not necessary as CommentManager also handle it
- Closed
- is related to
-
LPS-83160 Upgrade on Sybase failed caused by "Invalid column name"
- Closed
- relates
-
LPS-87370 Upgrade fails on Sybase "Invalid Column Name"
- Closed
- Testing discovered
-
LPS-68835 Sybase upgrade hangs on VerifyResourcePermissions
- Closed