Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0052562
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Retail Modules] Retail APImajoralways2023-05-25 09:462023-07-14 11:45
ReporterngarciaView Statuspublic 
Assigned Toranjith_qualiantech_com 
PriorityurgentResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0052562: Business Partner update through JSON Based Import Process EDL process fails if the bp has two contacts with same name

DescriptionBusiness Partner update through JSON Based Import Process EDL process fails if the bp has two contacts with same name

It finishes with:

Error while importing an item: query did not return a unique result: 2

The property that identifies uniquely a contact is the first name:

select m.mapped_entity, m.mapping_entity, i.mapping_name
from OBEI_entity_mapping m, OBEI_Prop_Map_Instance i
where m.OBEI_entity_mapping_id = i.OBEI_entity_mapping_id
and m.mapping_entity = 'ADUser'
and i.identifies_univocally = 'Y';
mapped_entity | mapping_entity | mapping_name
---------------+----------------+--------------
ContactInfo | ADUser | firstName
User | ADUser | username
(2 rows)
Steps To ReproduceAdd two contacts with the same first name to a business partner

Try to import it through JSON Based Import Process EDL Process and check the EDL Request finishes with the following error:

Error while importing an item: query did not return a unique result: 2

The log shows:

Caused by: org.hibernate.NonUniqueResultException: query did not return a unique result: 2
    at org.hibernate.query.internal.AbstractProducedQuery.uniqueElement(AbstractProducedQuery.java:1684) ~[hibernate-core-5.6.0.Final.jar:5.6.0.Final]
    at org.hibernate.query.internal.AbstractProducedQuery.uniqueResult(AbstractProducedQuery.java:1659) ~[hibernate-core-5.6.0.Final.jar:5.6.0.Final]
    at org.openbravo.dal.service.OBQuery.uniqueResult(OBQuery.java:100) ~[classes/:?]
    at org.openbravo.service.external.integration.importer.DalSynchronizableBusinessObjectImporter.getBobFromUniqueProperties(DalSynchronizableBusinessObjectImporter.java:192)
...
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to defect 0052748 closedranjith_qualiantech_com Currently it is not possible to uniquely identify a contact of a business partner 

-  Notes
(0150449)
hgbot (developer)
2023-05-30 05:03

Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.api/-/merge_requests/150 [^]
(0150853)
hgbot (developer)
2023-06-07 10:56

Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.api [^]
Changeset: fdf68d43cb42319acffe29a737f34ed095375c1b
Author: Ranjith S R <ranjith@qualiantech.com>
Date: 06-06-2023 11:47:54
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.api/-/commit/fdf68d43cb42319acffe29a737f34ed095375c1b [^]

Fixed ISSUE-52562: Added LastName as unique identifier in ContactInfo
* When importing BusinessPartner, First Name and Last Name should be set
  as unique identifier in ContactInfo

---
M src-db/database/sourcedata/OBEI_PROP_MAP_INSTANCE.xml
---
(0150854)
hgbot (developer)
2023-06-07 10:56

Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.api/-/merge_requests/150 [^]

- Issue History
Date Modified Username Field Change
2023-05-25 09:46 ngarcia New Issue
2023-05-25 09:46 ngarcia Assigned To => Triage Platform Conn
2023-05-25 13:22 marvintm Assigned To Triage Platform Conn => Retail
2023-05-25 13:23 marvintm Project Modules => Retail Modules
2023-05-25 13:23 marvintm Triggers an Emergency Pack => No
2023-05-25 13:23 marvintm Category External Data Integration => Retail API
2023-05-29 11:09 ranjith_qualiantech_com Assigned To Retail => ranjith_qualiantech_com
2023-05-29 15:49 ranjith_qualiantech_com Status new => scheduled
2023-05-30 05:03 hgbot Note Added: 0150449
2023-06-07 10:56 hgbot Resolution open => fixed
2023-06-07 10:56 hgbot Status scheduled => closed
2023-06-07 10:56 hgbot Note Added: 0150853
2023-06-07 10:56 hgbot Note Added: 0150854
2023-06-15 09:46 ngarcia Relationship added related to 0052748
2023-07-14 11:39 ngarcia Relationship added related to 0052969
2023-07-14 11:45 ngarcia Relationship deleted related to 0052969


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker