[OFBIZ-11998] Demo Data in conflict with Entity Unique Index when loading data during creation

• Type: Improvement
• Status: Closed
• Priority: Minor
• Resolution: Information Provided
• Affects Version/s: 17.12.04
• Component/s: party
• Labels: patch

Environment

Win10, Java JDK1.8, MSSQL.

• Assignee: Jacques Le Roux
• Reporter: Schumann Ye
• Created: 07/Sep/20 08:37
• Updated: 11/Aug/21 15:09
• Resolved: 16/Sep/20 07:11

Description

In party-entitymodel.xml line nr. 2,814 the following is defined:

 <index name="CARD_ID_IDX" unique="true">

      <index-field name="cardId"/>

</index>

which goes against with the following code in applications\securityext\data\UserDemoData.xml.

<Person partyId="NA"/>.

This would cause inserting records into Entity Person failing because the field CARD_ID should not be identical in this case.

Therefore it's suggested to change the party-entitymodel.xml from :

 <index name="CARD_ID_IDX" unique="true">

      <index-field name="cardId"/>

</index>

to

 <index name="CARD_ID_IDX">

      <index-field name="cardId"/>

</index>