Upgrade for module com.liferay.message.boards.service failed with Sql Server 2017

• Type: Bug
• Status: Closed
• Resolution: Fixed
• Affects Version/s: Master
• Fix Version/s: 7.3.0 CE GA1, 7.3.10 DXP GA1, Master
• Component/s: Message Boards
• Labels:
  • pt-upgrade-review
• Fix Priority: 4
• Sprint: LIMA | #09 | Dec10-Dec20, LIMA | #10 | Dec20-Jan08
• Git Pull Request: https://github.com/brianchandotcom/liferay-portal/pull/82195

Steps to Reproduce:

1. Start 7.0.10.10 SP10 connect to Sql Server 2017.
2. Add 500 message board threads.
3. Upgrade to master.

Expected Results:
Upgrade should be successful without any error.

Actual Results:
Failed upgrade process for module com.liferay.message.boards.service with below error:

2019-12-10 10:33:23.891 ERROR [main][UpgradeStepRegistratorTracker:184] Failed upgrade process for module com.liferay.message.boards.service
com.liferay.portal.kernel.upgrade.UpgradeException: com.microsoft.sqlserver.jdbc.SQLServerException: Error converting data type varchar to bigint.

Reproduced on:
Upgrade 7.0.10.10 SP1.
Tomcat 9.0.17 + SQL Server 2017. Portal master DXP GIT ID: 7ce7ab20a3835fe3634c284e434a175a6dc0c95a.