[
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)
