Dynamic Data List records value from Parent Definition gone missing after upgrade from 6.2 to DXP

• Type: Bug
• Status: Closed
• Resolution: Fixed
• Affects Version/s: 6.2.X EE, Master
• Fix Version/s: 7.0.0 DXP FP5, 7.0.0 DXP SP1, 7.0.3 CE GA4, 7.1.X, Master
• Component/s: Dynamic Data Mapping, Dynamic Data Mapping > Upgrades
• Labels:
  • QA-AUTOMATION
  • backend_test
  • ee-ts
  • fw_test_integration
  • liferay-digital-enterprise-70-sp1
  • liferay-fixpack-de-5-7010
• Branch Version/s:
  7.0.x
• Backported to Branch:
  Committed
• Story Points: 1.25
• Sprint: Sprint 25: Sep, 05 - 16
• Git Pull Request: https://github.com/brianchandotcom/liferay-portal/pull/43088

Reproduction Steps:

1. Connect a clean Liferay 6.2 bundle with clean DB.
2. Boot up 6.2 and Navigate to Content -->Dynamic Data List, and create a Data Definition name "Parent1" add a text field to the definition
3. Create another Data Definition named "Child" using "Parent1" as its parent definition, and add field to the definition.
4. In the Dynamic Data List, create a list "Test List" using "Child" as the definition.
5. Add record under "Test List" and add value to the fields.
   Observed Behavior: The value you put for "Parent1" and "Child" definition is shown in the UI and in "ddmcontent" table the records show both value.
6. using upgrade tool from 7.0 and upgrade the DB from 6.2 to 7.0
7. Once complete the upgrade, boot up 7.0. then do a reindex
8. Navigate to Dynamic Data List and view the record under "Test List"
   Observed Behavior1: The record will show the field from Parent1 and Child. But the actual value you put in step 5 for Parent1 is not listed.
   Observed Behavior2: In DB ddmcontent table, the Parent1 fields are missing from Database.