SQL Server 2008 Index size exceeded on update

• Type: Bug
• Status: Closed
• Resolution: Won't Fix
• Affects Version/s: 7.0.0 Beta 4
• Fix Version/s: 7.0.0 CE GA1
• Component/s: Environments, Environments > Databases
• Labels:
  • LR7UPGRADE
• Fix Priority: 5
• Databases:
  SQL Server 2008 R2
• Git Pull Request: https://github.com/brianchandotcom/liferay-portal/pull/35761

05:25:19,648 INFO  [main][UpgradeProcess:65] Completed upgrade process com.liferay.portal.upgrade.v7_0_0.UpgradeDocumentLibrary in 445710ms
05:25:19,649 INFO  [main][UpgradeProcess:65] Completed upgrade process com.liferay.portal.upgrade.UpgradeProcess_7_0_0 in 5146526ms
com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: java.sql.SQLException: Operation failed. The index entry of length 1356 bytes for the index 'IX_E9B6A85B' exceeds the maximum length of 900 bytes.
	at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:59)
	at com.liferay.portal.kernel.upgrade.util.UpgradeProcessUtil._upgradeProcess(UpgradeProcessUtil.java:184)
	at com.liferay.portal.kernel.upgrade.util.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:152)
	at com.liferay.portal.kernel.upgrade.util.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:134)
	at com.liferay.portal.events.StartupHelper.upgradeProcess(StartupHelper.java:164)
	at com.liferay.portal.events.StartupHelperUtil.upgradeProcess(StartupHelperUtil.java:81)
	at com.liferay.portal.tools.DBUpgrader.upgrade(DBUpgrader.java:145)
	at com.liferay.portal.tools.DBUpgrader.main(DBUpgrader.java:67)
Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: java.sql.SQLException: Operation failed. The index entry of length 1356 bytes for the index 'IX_E9B6A85B' exceeds the maximum length of 900 bytes.
	at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:59)
	at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:83)
	at com.liferay.portal.upgrade.UpgradeProcess_7_0_0.doUpgrade(UpgradeProcess_7_0_0.java:76)
	at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:56)
	... 7 more
Caused by: java.sql.SQLException: Operation failed. The index entry of length 1356 bytes for the index 'IX_E9B6A85B' exceeds the maximum length of 900 bytes.
	at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
	at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2820)
	at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2258)
	at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:632)
	at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:584)
	at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:546)
	at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeUpdate(JtdsPreparedStatement.java:504)
	at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:1449)
	at sun.reflect.GeneratedMethodAccessor54.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:606)
	at com.liferay.portal.kernel.upgrade.dao.orm.UpgradeOptimizedPreparedStatementHandler.invoke(UpgradeOptimizedPreparedStatementHandler.java:50)
	at com.sun.proxy.$Proxy317.executeUpdate(Unknown Source)
	at com.liferay.portal.upgrade.v7_0_0.UpgradeDocumentLibrary.updateFileEntryTypeNamesAndDescriptions(UpgradeDocumentLibrary.java:459)
	at com.liferay.portal.upgrade.v7_0_0.UpgradeDocumentLibrary.updateFileEntryTypeNamesAndDescriptions(UpgradeDocumentLibrary.java:429)
	at com.liferay.portal.upgrade.v7_0_0.UpgradeDocumentLibrary.updateFileEntryTypeNamesAndDescriptions(UpgradeDocumentLibrary.java:379)
	at com.liferay.portal.upgrade.v7_0_0.UpgradeDocumentLibrary.updateFileEntryTypeNamesAndDescriptions(UpgradeDocumentLibrary.java:339)
	at com.liferay.portal.upgrade.v7_0_0.UpgradeDocumentLibrary.updateFileEntryTypeNamesAndDescriptions(UpgradeDocumentLibrary.java:306)
	at com.liferay.portal.upgrade.v7_0_0.UpgradeDocumentLibrary.doUpgrade(UpgradeDocumentLibrary.java:93)
	at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:56)
	... 10 more