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:
                  3 years, 15 weeks ago

                  Packages

                  Version Package