[ 
https://issues.apache.org/jira/browse/OFBIZ-11998?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17203978#comment-17203978 ] 
Schumann Ye commented on OFBIZ-11998:
-------------------------------------
Hi Jacques,
OK with thanks.
B.R.
Schumann
> 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: Improvement
>          Components: party
>    Affects Versions: 17.12.04
>         Environment: Win10, Java JDK1.8, MSSQL.
>            Reporter: Schumann Ye
>            Assignee: Jacques Le Roux
>            Priority: Minor
>              Labels: patch
>
> 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)