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


  • 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'


  • Liferay DXP 7.3
  • Liferay DXP 7.4


  • 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
0 人中有 0 人觉得有帮助