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

Description

Business 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 Reproduce

Add 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)
...

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

Notes
(0150449) hgbot (developer) 2023-05-30 05:03	Merge Request created: 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