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

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

    [ https://issues.apache.org/jira/browse/OFBIZ-11998?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17191586#comment-17191586 ] 

Schumann Ye commented on OFBIZ-11998:
-------------------------------------

Same for product-entitymodel.xml. It is suggested to change 

<index name="INVITEM_SOFID" {color:#FF0000}unique="true"{color}>
    <index-field name="softIdentifier"/>
 </index>

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

    <index-field name="activationNumber"/>

</index>

to

<index name="INVITEM_SOFID">
    <index-field name="softIdentifier"/>
 </index>

<index name="INVITEM_ACTNM">

    <index-field name="activationNumber"/>

</index>

because it goes against with \applications\accounting\data\StandardCostingDemoData.xml when inserting records for InventoryItem.

 

Same for party-entitymodel.xml. 

<index name="COMMEVT_MSG_ID"{color:#FF0000} unique="true"{color}> <index-field name="messageId"/> </index>

> 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
>            Priority: Minor
>              Labels: patch
>             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)