Error Duplicate entry '0-3-925637128-com_liferay_site_navigation_menu_web_portlet_SiteN'

Issue

• The following error is being reported in the logs multiple times:

ERROR [http-nio2-8080-exec-143][JDBCExceptionReporter:234] Duplicate entry '0-3-925637128-com_liferay_site_navigation_menu_web_portlet_SiteN' for key 'IX_CB778855'

Environment

• Liferay DXP 7.3
• Liferay DXP 7.4

Resolution

• First, check if there is an duplicate entry by running the following query:

select * from Portlet p where portletId like '%site_navigation_menu_web_portlet_SiteN%';

• If there's indeed two entries, go to the portal and execute this following steps:
  1. Go to Control Panel
  2. Click on Server Administration
  3. Execute Clean Up Orphaned Page Revision Portlet Preferences
  4. Execute Clean Up Orphaned Theme Portlet Preferences