Unique Constraint Violated error seen when upgrading Liferay

Issue

• Unique Constraint Violated error is seen when upgrading major Liferay versions (such as 7.2 to 7.4), as follows:

ERROR [main][UpgradeStepRegistratorTracker:199] Failed upgrade process for module com.liferay.portal.configuration.persistence.impl
com.liferay.portal.kernel.log.LogSanitizerException: com.liferay.portal.kernel.upgrade.UpgradeException: java.sql.BatchUpdateException: ORA-00001: unique constraint (LIFERAY.SYS_C0070892) violated_ [Sanitized]

Environment

• DXP 7.4, DXP 7.3, DXP 7.2

Resolution

• This error can be seen when the osgi/configs file from the previous Liferay install is applied to the new install before running the database upgrade script.
• To resolve, clear out the osgi/configs folder, or remove the duplicates, before running the database upgrade script and apply the config files after the upgrade is complete.

Additional Information

• Liferay Upgrade Basics
• Liferay Migrating Configurations and Properties