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

Starting up Liferay with SQL Server 2012/2016 causes truncation issues at startup

    Details

      Description

      Steps to reproduce:

      1. Configure LR to use SQL Server version 2012 or 2016
        EG:
        jdbc.default.driverClassName=com.microsoft.sqlserver.jdbc.SQLServerDriver
        jdbc.default.url=jdbc:sqlserver://localhost;databaseName=lportal
        jdbc.default.username=liferay
        jdbc.default.password=liferay
        
      2. Startup Liferay
      3. You should see the message "String or binary data would be truncated." followed by stacktraces like those found in the attached log file.

      The portal otherwise appears to startup fine and seems to function as normal, though there may be other issues that aren't immediately apparent. Shutting down and re-starting the portal similarly results in the same issue.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              brian.lee Brian Lee
              Reporter:
              brian.greenwald Brian Greenwald
              Participants of an Issue:
              Recent user:
              Brian Wulbern
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Days since last comment:
                4 years, 15 weeks, 6 days ago

                  Packages

                  Version Package