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-07-14 11:45 | |||
| Reporter | ngarcia | View Status | public | |||||
| Assigned To | ranjith_qualiantech_com | |||||||
| Priority | urgent | Resolution | fixed | Fixed in Version | ||||
| Status | closed | 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 | |||||||
| Merge Request Status | approved | |||||||
| Review Assigned To | ||||||||
| OBNetwork customer | OBPS | |||||||
| Support ticket | 65173 | |||||||
| 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 | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
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 [^] |
|
Notes |
|
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 09:46 | ngarcia | OBNetwork customer | => OBPS |
| 2023-05-25 09:46 | ngarcia | Support ticket | => 65173 |
| 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 | Merge Request Status | => open |
| 2023-05-30 05:03 | hgbot | Note Added: 0150449 | |
| 2023-06-07 10:56 | hgbot | Merge Request Status | open => approved |
| 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 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |