DM upgrade fails due to index violation

• Type: Bug
• Status: Closed
• Resolution: Fixed
• Affects Version/s: 7.0.0 Beta 8
• Fix Version/s: 7.0.0 CE GA1
• Component/s: Collaboration, DM > Upgrade, Documents & Media
• Labels:
  • LR7UPGRADE
• Fix Priority: 5
• Sprint: Dekalbite
• Git Pull Request: https://github.com/brianchandotcom/liferay-portal/pull/38386

Getting this exception upgrading from 6.1.30 to 7

21:04:37,142 INFO  [main][UpgradeProcess:97] Completed upgrade process com.liferay.portal.upgrade.v7_0_0.UpgradeDocumentLibrary in 332314ms
21:04:37,142 INFO  [main][UpgradeProcess:97] Completed upgrade process com.liferay.portal.upgrade.UpgradeProcess_7_0_0 in 2439906ms
com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: java.sql.BatchUpdateException: Cannot insert duplicate key row in object 'dbo.DLFileEntry' with unique index 'IX_ED5CA615'.
	at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:91)
	at com.liferay.portal.kernel.upgrade.util.UpgradeProcessUtil._upgradeProcess(UpgradeProcessUtil.java:175)
	at com.liferay.portal.kernel.upgrade.util.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:143)
	at com.liferay.portal.kernel.upgrade.util.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:125)
	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:158)
	at com.liferay.portal.tools.DBUpgrader.main(DBUpgrader.java:96)
Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: java.sql.BatchUpdateException: Cannot insert duplicate key row in object 'dbo.DLFileEntry' with unique index 'IX_ED5CA615'.
	at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:91)
	at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:115)
	at com.liferay.portal.upgrade.UpgradeProcess_7_0_0.doUpgrade(UpgradeProcess_7_0_0.java:75)
	at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:88)
	... 7 more
Caused by: java.sql.BatchUpdateException: Cannot insert duplicate key row in object 'dbo.DLFileEntry' with unique index 'IX_ED5CA615'.
	at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeBatch(SQLServerPreparedStatement.java:1178)
	at com.liferay.portal.upgrade.AutoBatchPreparedStatementUtil$ConcurrentBatchInvocationHandler$1.call(AutoBatchPreparedStatementUtil.java:216)
	at com.liferay.portal.upgrade.AutoBatchPreparedStatementUtil$ConcurrentBatchInvocationHandler$1.call(AutoBatchPreparedStatementUtil.java:211)
	at java.util.concurrent.FutureTask.run(FutureTask.java:262)
	at com.liferay.portal.kernel.concurrent.ThreadPoolExecutor$WorkerTask._runTask(ThreadPoolExecutor.java:756)
	at com.liferay.portal.kernel.concurrent.ThreadPoolExecutor$WorkerTask.run(ThreadPoolExecutor.java:667)
	at java.lang.Thread.run(Thread.java:745)
	Suppressed: java.sql.BatchUpdateException: Cannot insert duplicate key row in object 'dbo.DLFileEntry' with unique index 'IX_ED5CA615'.
		... 7 more