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 ]

related to

defect

0052748

closed

ranjith_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