Leftover data from Software Catalog in the ResourceAction table after using the Data Cleanup

• Type: Bug
• Status: Resolved
• Resolution: Fixed
• Affects Version/s: 7.4.13 DXP GA1, Master
• Fix Version/s: 7.4.3.7 CE GA7, 7.4.13 DXP U3, Master
• Component/s: Database Upgrade Framework, Util > Software Catalog
• Labels:
  • QA-AUTOMATION
  • liferay-update-dxp-3-7413
  • pt-upgrade-review
• Fix Priority: 3
• Git Pull Request: https://github.com/brianchandotcom/liferay-portal/pull/111740
• QA Test Name:
  • LocalFile.DataCleanup#RemoveSoftwareCatalogDataAfterUpgrade
• QA Test Score: 3

1. Use the attached data to perform the upgrade to master
2. Start the server with the upgraded database.
3. Go to Control Panel -> System Settings -> Upgrade -> Data Cleanup.
4. Select "Clean up software catalog module data." and Save
5. In the database, run this command:

   SELECT * FROM ResourceAction WHERE name LIKE '%com.liferay.portlet.softwarecatalog%'; 

 

Expected result:

No leftover from Software Catalog in the database after data cleanup.

Actual result:

There are leftovers from the Software Catalog after data cleanup. See the screenshot.