1. Home
  2. Portal
  3. RE: Column "mbmessage" does not exist on migration from liferay 7.2 to 7.3.

RE: Column "mbmessage" does not exist on migration from liferay 7.2 to 7.3.

Elena Stefanova, modified 5 Years ago.
Column "mbmessage" does not exist on migration from liferay 7.2 to 7.3.1
Junior Member Posts: 42 Join Date: 8/24/15 Recent Posts
Hi, there!
I'm tying to do a direct upgrade of my database from liferay 7.2.0 to 7.3.1, but unfortunately I get the following error in log:
ERROR [main][ReleaseManagerOSGiCommands:93] bundle com.liferay.portal.upgrade.impl:4.0.4 (975)[com.liferay.portal.upgrade.internal.release.osgi.commands.ReleaseManagerOSGiCommands(2531)] : The activate method has thrown an exception 
com.liferay.portal.kernel.upgrade.UpgradeException: org.postgresql.util.PSQLException: ERROR: column "mbmessage" of relation "mbmessage" does not exist_  Position: 22 [Sanitized]
    at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:104)
    at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:122)
...........
Caused by: org.postgresql.util.PSQLException: ERROR: column "mbmessage" of relation "mbmessage" does not exist_  Position: 22 [Sanitized]
    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2412)
    at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2125)[code]

Does anyone have an idea what could be wrong? By the way, the first time I was not able to do a successful upgrade from version 7.2 to 7.3.1, I run a "staged" upgrade from 7.2 to 7.3.0 which passed with no errors, but the later upgrade from 7.3.0 to 7.3.1 threw the same error.
Any help will be appreciated!
Thanks in advance,
Eli 
thumbnail
Alberto Chaparro Terleira, modified 5 Years ago.
RE: Column "mbmessage" does not exist on migration from liferay 7.2 to 7.3.
Liferay Master Posts: 560 Join Date: 4/25/11 Recent Posts
Hi Elena,
Can you share the upgrade.log file?
Thanks.
Elena Stefanova, modified 5 Years ago.
RE: Column "mbmessage" does not exist on migration from liferay 7.2 to 7.3.
Junior Member Posts: 42 Join Date: 8/24/15 Recent Posts
Hi, Alberto!
Yes, I'm sharing my update log file here.Thanks

Attachments:

Elena Stefanova, modified 5 Years ago.
RE: Column "mbmessage" does not exist on migration from liferay 7.2 to 7.3.
Junior Member Posts: 42 Join Date: 8/24/15 Recent Posts
I see that this issue has been already reported here https://issues.liferay.com/browse/LPS-109589 . So it seems that  I should wait for the next release emoticon
thumbnail
Alberto Chaparro Terleira, modified 5 Years ago.
RE: Column "mbmessage" does not exist on migration from liferay 7.2 to 7.3.
Liferay Master Posts: 560 Join Date: 4/25/11 Recent Posts
Hi Elena,
You are right, that's the issue. It has been already fixed so you will have available in a couple of weeks in the next GA.
If you can't wait, you can also overwrite the module message boards service with the changes to fix the upgrade process.
Cheers!