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

Openbravo Issue Tracking System - Retail Modules

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0052562

Retail Modules

Retail API

public

2023-05-25 09:46

2023-07-14 11:45

Reporter

ngarcia

Assigned To

ranjith_qualiantech_com

Priority

urgent

Severity

major

Reproducibility

always

Status

closed

Resolution

fixed

Platform

OS Version

Product Version

Target Version

Fixed in Version

Merge Request Status

Review Assigned To

OBNetwork customer

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

Summary

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

Proposed Solution

Additional Information