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