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

["Schumann Ye (Jira)" <ji...@apache.org>]

Schumann Ye created OFBIZ-11998:
-----------------------------------

             Summary: Demo Data in conflict with Entity Unique Index when loading data during creation
                 Key: OFBIZ-11998
                 URL: https://issues.apache.org/jira/browse/OFBIZ-11998
             Project: OFBiz
          Issue Type: Bug
          Components: party
    Affects Versions: 17.12.04
         Environment: Win10, Java JDK1.8, MSSQL.
            Reporter: Schumann Ye
             Fix For: 18.12.01


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

 <index name="CARD_ID_IDX" {color:#FF0000}unique="true"{color}>

      <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" {color:#FF0000}unique="true"{color}>

      <index-field name="cardId"/>

</index>

to

 <index name="CARD_ID_IDX">

      <index-field name="cardId"/>

</index>



--
This message was sent by Atlassian Jira
(v8.3.4#803005)