Duplicated categories can be generated at Live environment because category deletions are not published from Staging to Live

• Type: Bug
• Status: Closed
• Resolution: Fixed
• Affects Version/s: 6.2.X EE
• Fix Version/s: 6.2.4 CE GA5, 6.2.X EE
• Component/s: Staging, WCM, WCM > Categories
• Labels:
  • 6.2.x-only
  • ee-ts
  • liferay-fixpack-portal-56-6210
• Branch Version/s:
  6.2.x
• Backported to Branch:
  Committed
• Story Points: 12
• Fix Priority: 4
• Git Pull Request: https://github.com/brianchandotcom/liferay-portal-ee/pull/10221

Category and Vocabulary deletions are not published from Staging to Live:

1. Activate Local staging
2. Create a vocabulary voc_test
3. Create two categories cat_test1 and cat_test2 inside created vocabulary
4. Publish both vocabulary and categories from Staging to Live
5. Query database and check that vocabulary and category are created at both groupid (two database entries for each object):

   select * from assetcategory where name = 'cat_test1'
   select * from assetcategory where name = 'cat_test2'
   select * from assetvocabulary where name = 'voc_test'

6. Delete created category "cat_test1" at Staging
7. Publish again from Staging to Live
8. Check category at database

   select * from assetcategory where name = "voc_test'

   1. Expected behavior: category cat_test1 is deleted at both groupids
   2. Wrong behavior: category cat_test1 is not deleted at live groupid
9. Delete created vocabulary voc_test at Staging
10. Publish again from Staging to Live
11. Check category at database

    select * from assetvocabulary where name = 'cat_test2'

12. Check vocabulary at database

    select * from assetvocabulary where name = 'voc_test'

    1. Expected behavior: vocabulary voc_test is deleted at both groupids. Category cat_test2 is also deleted because is inside of that category
    2. Wrong behavior: vocabulary nor category are not deleted at live groupid

This can causes some duplication issues at Live environment when you delete and recreate a category with same name, see comment:

• https://issues.liferay.com/browse/LPS-53847?focusedCommentId=621259&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-621259