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

• Type: Bug
• Status: Closed
• Resolution: Duplicate
• Affects Version/s: 7.0.0 CE GA1, Master
• Fix Version/s: None
• Component/s: Environments, Environments > Databases
• Labels:
  • Bemis

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.