Ask Questions and Find Answers
Important:
Ask is now read-only. You can review any existing questions and answers, but not add anything new.
But - don't panic! While ask is no more, we've replaced it with discuss - the new Liferay Discussion Forum! Read more here here or just visit the site here:
discuss.liferay.com
RE: Missing tables and column - database upgrade 6.2 to 7.2
Upgrade: Liferay 6.2 CE GA6 to Liferay 7.2 GA1
The database upgrade failed. Upgrade log, listed below, states many tables do not exist and invalid column name ‘mvccVersion’. Upgrade log is below.
2019-06-18 21:03:08.648 INFO [main][UpgradeProcess:93] Upgrading com.liferay.portal.upgrade.UpgradeProcess_7_0_0
2019-06-18 21:03:09.133 INFO [main][UpgradeProcess:93] Upgrading com.liferay.portal.kernel.upgrade.UpgradeMVCCVersion
2019-06-18 21:03:09.133 INFO [main][LoggingTimer:83] Starting com.liferay.portal.kernel.upgrade.UpgradeMVCCVersion#upgradeClassElementMVCCVersions
2019-06-18 21:03:09.398 ERROR [main][UpgradeMVCCVersion:57] Table Account_ does not exist
2019-06-18 21:03:09.414 ERROR [main][UpgradeMVCCVersion:57] Table Address does not exist
***OTHER TABLES THAT DO NOT EXIST LISTED HERE***
2019-06-18 21:03:10.429 ERROR [main][UpgradeMVCCVersion:57] Table Lock_ does not exist
2019-06-18 21:03:44.695 INFO [main][UpgradeProcess:107] Failed upgrade process com.liferay.portal.upgrade.UpgradeProcess_7_0_0 in 36047 ms
com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'mvccVersion'.
The database upgrade failed. Upgrade log, listed below, states many tables do not exist and invalid column name ‘mvccVersion’. Upgrade log is below.
2019-06-18 21:03:08.648 INFO [main][UpgradeProcess:93] Upgrading com.liferay.portal.upgrade.UpgradeProcess_7_0_0
2019-06-18 21:03:09.133 INFO [main][UpgradeProcess:93] Upgrading com.liferay.portal.kernel.upgrade.UpgradeMVCCVersion
2019-06-18 21:03:09.133 INFO [main][LoggingTimer:83] Starting com.liferay.portal.kernel.upgrade.UpgradeMVCCVersion#upgradeClassElementMVCCVersions
2019-06-18 21:03:09.398 ERROR [main][UpgradeMVCCVersion:57] Table Account_ does not exist
2019-06-18 21:03:09.414 ERROR [main][UpgradeMVCCVersion:57] Table Address does not exist
***OTHER TABLES THAT DO NOT EXIST LISTED HERE***
2019-06-18 21:03:10.429 ERROR [main][UpgradeMVCCVersion:57] Table Lock_ does not exist
2019-06-18 21:03:44.695 INFO [main][UpgradeProcess:107] Failed upgrade process com.liferay.portal.upgrade.UpgradeProcess_7_0_0 in 36047 ms
com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'mvccVersion'.
Hi Brody,That error usually happens when the DB user has access to different database schemas, could you check it? Please, use a user with permission to access only to the Liferay schema.
Thanks.
Thanks.
You are correct. Once I changed the default schema to [dbo] for user, the Liferay core upgrade completed successfully after 7 minutes.
Great Brody! Thanks for sharing the results
Copyright © 2025 Liferay, Inc
• Privacy Policy
Powered by Liferay™