Project:
View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||||||
ID | ||||||||||||
0052562 | ||||||||||||
Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||||||
defect | [Retail Modules] Retail API | major | always | 2023-05-25 09:46 | 2023-05-30 05:03 | |||||||
Reporter | ngarcia | View Status | public | |||||||||
Assigned To | ranjith_qualiantech_com | |||||||||||
Priority | urgent | Resolution | open | Fixed in Version | ||||||||
Status | scheduled | Fix in branch | Fixed in SCM revision | |||||||||
Projection | none | ETA | none | Target Version | ||||||||
OS | Any | Database | Any | Java version | ||||||||
OS Version | Database version | Ant version | ||||||||||
Product Version | SCM revision | |||||||||||
Review Assigned To | ||||||||||||
Regression level | ||||||||||||
Regression date | ||||||||||||
Regression introduced in release | ||||||||||||
Regression introduced by commit | ||||||||||||
Triggers an Emergency Pack | No | |||||||||||
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) ... | |||||||||||
Tags | No tags attached. | |||||||||||
Attached Files | ||||||||||||
![]() |
|
![]() |
|
(0150449) hgbot (developer) 2023-05-30 05:03 |
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.api/-/merge_requests/150 [^] |
![]() |
|||
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 |
Copyright © 2000 - 2009 MantisBT Group |