WARN message related to DDMStructureLayout during upgrade on Oracle and DB2

• Type: Regression Bug
• Status: Closed
• Resolution: No Longer Reproducible
• Affects Version/s: 7.2.X, Master
• Fix Version/s: 7.2.X, Master
• Component/s: Dynamic Data Mapping
• Labels:
  • QA-AUTOMATION
• Fix Priority: 3
• Sprint: Forms_7.3_7
• QA Test Name:
  • LocalFile.PortalSmokeUpgrade#ViewPortalSmokeArchive6130
  • LocalFile.PortalSmokeUpgrade#ViewPortalSmokeArchive621015
  • LocalFile.PortalSmokeUpgrade#ViewPortalSmokeArchive621021
  • LocalFile.PortalSmokeUpgrade#ViewPortalSmokeArchive7010
  • LocalFile.PortalSmokeUpgrade#ViewPortalSmokeArchive70106
  • LocalFile.PortalSmokeUpgrade#ViewPortalSmokeArchive7110
• QA Test Score: 30

Steps to Reproduce:

1. Import the attached oracle dmp into oracle12.
2. Execute upgrade to master.

Expected Results:
No WARN message is thrown.

Actual Results:
WARN message is thrown.

2019-06-27 05:12:33.292 WARN  [main][BaseDB:117] ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found
: create unique index IX_14E638B0 on DDMStructureLayout (groupId, classNameId, structureLayoutKey);
WARN - ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found
: create unique index IX_14E638B0 on DDMStructureLayout (groupId, classNameId, structureLayoutKey);

Reproduced on:
Reproduced on:
Tomcat 9.0.10 + Oracle 12. Portal master GIT ID: 922583631dfb56005efbe978f85e70b1050d04e8.