Uploaded image for project: 'PUBLIC - Liferay Portal Community Edition'
  1. PUBLIC - Liferay Portal Community Edition
  2. LPS-105593

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

    Details

      Description

      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.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              summer.zhang Summer Zhang
              Reporter:
              summer.zhang Summer Zhang
              Participants of an Issue:
              Recent user:
              Jason Pince
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Days since last comment:
                49 weeks ago

                  Packages

                  Version Package
                  7.3.0 CE GA1
                  7.3.10 DXP GA1
                  Master