Issue
- We are running an upgrade from Liferay 7.0 to 7.4 and observing the following error in the log:
WARN [main][BasePortletIdUpgradeProcess:511] null
com.liferay.portal.kernel.log.LogSanitizerException: org.postgresql.util.PSQLException:
ERROR: duplicate key value violates unique constraint "ix_cb778855"_ Detail: Key
(ownerid, ownertype, plid, portletid, ctcollectionid)=
(0, 3, 0, com_liferay_dynamic_data_mapping_form_web_portlet_DDMFormAdminPortlet, 0)
already exists. [Sanitized]
Environment
- DXP 7.0 > DXP 7.4
Resolution
- The upgrade is failing because it is trying to convert the older version of what DDM Forms replaced, Polls.
- Two queries can be run to resolve this.
Select * from PortletPreferences where portletid = 'com_liferay_polls_web_portlet_PollsPortlet'
If you can confirm that com_liferay_polls_web_portlet_PollsPortlet is present then run the next query:
Delete from PortletPreferences where portletid = 'com_liferay_polls_web_portlet_PollsPortlet'
Additional Information
- There is a ticket being worked on to patch this in a future update: LPS-187221