How to find duplicate cms component in Hybris

Sometimes during a hybris system update, an error may occur when duplicating CMS components. To fix this problem, we can run the following query to identify and remove the affected component from Hybris.

SELECT p_uid, p_catalogversion, COUNT(p_uid) FROM cmscomponent GROUP BY p_uid, p_catalogversion HAVING COUNT(p_uid) > 1

Leave a Comment

Your email address will not be published. Required fields are marked *