Unique constraint (LPORTAL_70X.IX_C803899D) violated_ upgrading from 6.2.10 to 7.0.x

• Type: Bug
• Status: Closed
• Resolution: No Longer Reproducible
• Affects Version/s: 7.0.0 Alpha 1
• Fix Version/s: 7.0.0 Alpha 1
• Component/s: DM > Upgrade, Documents & Media
• Labels: None
• Fix Priority: 4
• Git Pull Request: https://github.com/marcellustavares/liferay-portal/pull/756

Steps to reproduce:

1. Start a portal v. 6.2.10 sp12.
2. Once the data base is created, login in to the portal.
3. Stop the server
4. Configure current master for the upgrade using the same Data Base and adding the next property to the portal-ext.properties:

upgrade.processes.6210=${upgrade.processes.master}

5. Start the server.

Result: The server stops without success.

In logs:

12:11:21,796 INFO  [localhost-startStop-1][UpgradeProcess:163] Upgrading com.liferay.portal.upgrade.v7_0_0.UpgradeDocumentLibrary
12:11:22,304 ERROR [localhost-startStop-1][UpgradeDocumentLibrary:75] Unable to add dynamic data mapping structure link for file entry type 20308
12:11:22,306 INFO  [localhost-startStop-1][UpgradeProcess:173] Completed upgrade process com.liferay.portal.upgrade.v7_0_0.UpgradeDocumentLibrary in 510ms
12:11:22,306 INFO  [localhost-startStop-1][UpgradeProcess:173] Completed upgrade process com.liferay.portal.upgrade.UpgradeProcess_7_0_0 in 3424ms
12:11:22,334 ERROR [localhost-startStop-1][MainServlet:216] com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (LPORTAL_70X.IX_C803899D) violated_ [Sanitized]
com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (LPORTAL_70X.IX_C803899D) violated_ [Sanitized]
        at com.liferay.portal.events.StartupAction.run(StartupAction.java:78)
        at com.liferay.portal.servlet.MainServlet.processStartupEvents(MainServlet.java:1315)
        at com.liferay.portal.servlet.MainServlet.init(MainServlet.java:213)
        at javax.servlet.GenericServlet.init(GenericServlet.java:158)
        at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1284)
        at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1197)
        at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1087)
        at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:5266)
        at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5554)
        at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:652)
        at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:677)
        at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1912)
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
        at java.util.concurrent.FutureTask.run(FutureTask.java:262)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
        at java.lang.Thread.run(Thread.java:745)
Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (LPORTAL_70X.IX_C803899D) violated_ [Sanitized]
        at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:169)
        at com.liferay.portal.kernel.upgrade.util.UpgradeProcessUtil._upgradeProcess(UpgradeProcessUtil.java:179)
        at com.liferay.portal.kernel.upgrade.util.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:151)
        at com.liferay.portal.kernel.upgrade.util.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:133)
        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:142)
        at com.liferay.portal.events.StartupAction.doRun(StartupAction.java:138)
        at com.liferay.portal.events.StartupAction.run(StartupAction.java:72)
        ... 19 more
Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (LPORTAL_70X.IX_C803899D) violated_ [Sanitized]
        at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:169)
        at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:191)
        at com.liferay.portal.upgrade.UpgradeProcess_7_0_0.doUpgrade(UpgradeProcess_7_0_0.java:66)
        at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:166)
        ... 27 more
Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (LPORTAL_70X.IX_C803899D) violated_ [Sanitized]
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
        at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
        at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
        at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
        at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
        at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)
        at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1044)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1329)
        at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3584)
        at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3665)
        at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1352)
        at com.zaxxer.hikari.proxy.PreparedStatementProxy.executeUpdate(PreparedStatementProxy.java:61)
        at com.zaxxer.hikari.proxy.HikariPreparedStatementProxy.executeUpdate(HikariPreparedStatementProxy.java)
        at com.liferay.portal.upgrade.v7_0_0.UpgradeDocumentLibrary.addDDMStructureLink(UpgradeDocumentLibrary.java:72)
        at com.liferay.portal.upgrade.v7_0_0.UpgradeDocumentLibrary.updateFileEntryTypeDDMStructureLinks(UpgradeDocumentLibrary.java:294)
        at com.liferay.portal.upgrade.v7_0_0.UpgradeDocumentLibrary.doUpgrade(UpgradeDocumentLibrary.java:97)
        at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:166)
        ... 30 more
Stopping the server due to unexpected startup errors