Legacy Knowledge Base
Published Sep. 10, 2025

"Constraint Violation in UpgradeListTypeType" error in upgrade

Written By

Jamilly Macedo

How To articles are not official guidelines or officially supported documentation. They are community-contributed content and may not always reflect the latest updates to Liferay DXP. We welcome your feedback to improve How To articles!

While we make every effort to ensure this Knowledge Base is accurate, it may not always reflect the most recent updates or official guidelines.We appreciate your understanding and encourage you to reach out with any feedback or concerns.

Legacy Article

You are viewing an article from our legacy "FastTrack" publication program, made available for informational purposes. Articles in this program were published without a requirement for independent editing or verification and are provided"as is" without guarantee.

Before using any information from this article, independently verify its suitability for your situation and project.

Issue

  • When attempting to upgrade, it has been observed an error when transitioning from a bundle prior to U100 to a bundle between U100 and U103.

  • Any attempt to upgrade beyond U103 results in a failure with the following error message:

ERROR [main][DBUpgrader:70] null
com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: java.sql.SQLIntegrityConstraintViolationException: Duplicate entry '20097-intranet-com.liferay.portal.kernel.model.Company.website' for key 'ListType.IX_B7F62EEC'
at com.liferay.portal.upgrade.PortalUpgradeProcess.upgrade(PortalUpgradeProcess.java:329) ~[portal-impl.jar:?]
at com.liferay.portal.kernel.upgrade.util.UpgradeProcessUtil._upgradeProcess(UpgradeProcessUtil.java:172) ~[portal-kernel.jar:?]
at com.liferay.portal.kernel.upgrade.util.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:148) ~[portal-kernel.jar:?]
at com.liferay.portal.events.StartupHelperUtil.upgradeProcess(StartupHelperUtil.java:160) ~[portal-impl.jar:?]
at com.liferay.portal.tools.DBUpgrader.upgradePortal(DBUpgrader.java:294) ~[portal-impl.jar:?]
at com.liferay.portal.tools.DBUpgrader.main(DBUpgrader.java:166) [portal-impl.jar:?]
at jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:?]
at jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:?]
at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?]
at java.lang.reflect.Method.invoke(Method.java:566) ~[?:?]
at com.liferay.portal.tools.db.upgrade.client.DBUpgraderLauncher.main(DBUpgraderLauncher.java:45) [com.liferay.portal.tools.db.upgrade.client.jar:?]
(...)

Environment

  • Liferay DXP 7.4 

Resolution

  • To resolve this behavior, open a help center ticket to request a hotfix containing LPS-205471.

Additional Information

Did this article resolve your issue ?

Legacy Knowledge Base