When you delete a portal instance data is not deleted from DB

• Type: Bug
• Status: Closed
• Resolution: Fixed
• Affects Version/s: 6.2.X EE, Master
• Fix Version/s: 7.0.0 DXP FP85, 7.0.10.12 DXP SP12, 7.0.X, 7.1.10 DXP FP13, 7.1.X, 7.2.1 CE GA2, 7.2.X, 7.3.10 DXP GA1, Master
• Component/s: Portal Configuration > Portal Instances
• Labels:
  • 7.2-won't
  • ee-ts
  • liferay-dxp-70-sp12
  • liferay-fixpack-de-85-7010
  • liferay-fixpack-dxp-13-7110
• Branch Version/s:
  7.2.x, 7.1.x, 7.0.x
• Backported to Branch:
  Committed
• Fix Priority: 3
• Git Pull Request: https://github.com/brianchandotcom/liferay-portal/pull/73750

Description:
When you create a new portal instance and then delete it, data in some tables that are related to the company, will not get deleted.

Steps to reproduce:
1. Set up a new portal instance
2. Place a Dynamic Data List Display portlet on the page in the new instance
3. Add List and then create a new data definition for it (do not select any of the existing ones)
4. Create a new custom field for Documents Folder
5. Create a new folder under Content & Data / Documents and Media, enter some value to the newly created custom field
6. In order to have some data in the SystemEvent table, create a form and delete it (entries are added into the table when an asset is deleted)
7. Note down company id of newly created instance from company table
8. Verify data with the companyID exists in the following tables: systemevent, expandotable, expandocolumn
9. Delete newly created instance

Actual result:
Company is deleted from the company table, but if you check systemevent, expandotable, expandocolumn tables, you find data related to the deleted company ID.

Expected result: Data associated with the deleted company ID gets deleted.

LPS-52177 solves a similar issue for User Groups.