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

[Nicolas Malin (Jira)]

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

Jacques Le Roux edited comment on OFBIZ-11998 at 9/8/20, 12:50 PM:
-------------------------------------------------------------------

Hi Schumann Ye,

This is a known issue with MsSQL since http://ofbiz.135035.n4.nabble.com/Unique-constraint-on-Person-cardId-breaks-ofbiz-on-SQL-Server-td4656840.html

This problem does not exist with Derby, nor with the mostly open source DBMS used with OFBiz: Postres, MySQL, MariaDB, etc.

So we will not change the current OOTB setting and I suggest you to simply change your own configuration.

You could perhaps provide an improvement patch to document this behaviour in entityengine.xml in the "localmssql" section. Else please close this Jira as "Information provided"

TIA


was (Author: jacques.le.roux):
Hi Schumann Ye,

This is a known issue with MsSQL since http://ofbiz.135035.n4.nabble.com/Unique-constraint-on-Person-cardId-breaks-ofbiz-on-SQL-Server-td4656840.html

This problem does not exist with Derby, nor with the mostly open source DBMS used with OBFiz: Postres, MySQL, MariaDB, etc.

So we will not change the current OOTB setting and I suggest your to simply change your own configuration.

You could perhaps provide an improvement patch to document this behaviour in entityengine.xml in the "localmssql" section. Else please close this Jira as "Information provided"

TIA

> 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
>            Assignee: Jacques Le Roux
>            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)