Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0046771 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Retail Modules] Retail API | major | always | 2021-05-21 08:24 | 2021-05-24 16:15 | |||
| Reporter | guillermogil | View Status | public | |||||
| Assigned To | ranjith_qualiantech_com | |||||||
| Priority | urgent | Resolution | fixed | Fixed in Version | RR21Q3 | |||
| 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 | Gold | |||||||
| Support ticket | ||||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0046771: Assortment Post Call fails due to eventHandler | |||||||
| Description | Assortment Post Call fails due to eventHandler 2021-05-20 17:43:32,291 [http-10] ERROR org.hibernate.engine.jdbc.spi.SqlExceptionHelper - ERROR: duplicate key value violates unique constraint "obretco_productcategory_un" Detail: Key (ad_client_id, m_product_category_id, obretco_productlist_id)=(83A757C2CEBB4EC5B4AF1A81AA91A10E, 53A088244F054F3DA5457559807E6245, 6CCE9577FD0442EEAAEB07E58845B5A9) already exists. If you send the Assortment call with no ProductCategoryAssortment it will fail with the above error. | |||||||
| Steps To Reproduce | On a clean Assortment with no product Category Do a call with multiple products with the same category | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0128496) marvintm (viewer) 2021-05-21 13:55 |
As a solution for this issue, we should integrate the preference implemented here: https://gitlab.com/obcustomers/NOR/org.openbravo.retail.posterminal/-/commit/5f35b196727929c35ef26a5fda799554985310dc [^] The idea is to disable the associated EventHandler so that it doesn't cause this problem, and then the customer should schedule the background process to generate the product category information automatically |
|
(0128555) hgbot (developer) 2021-05-24 12:37 |
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal/-/merge_requests/431 [^] |
|
(0128576) hgbot (developer) 2021-05-24 16:15 |
Directly closing issue as related merge request is already approved. Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal [^] Changeset: 63c2e1adfad2397052b4efe083469d39dd00c9ec Author: Ranjith S R <ranjith@qualiantech.com> Date: 2021-05-24T14:14:41+00:00 URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal/-/commit/63c2e1adfad2397052b4efe083469d39dd00c9ec [^] Fixed ISSUE-46771: Added preference to avoid to create product categories when the product is added in assortment --- M src-db/database/sourcedata/AD_PREFERENCE.xml M src-db/database/sourcedata/AD_REF_LIST.xml M src/org/openbravo/retail/posterminal/event/ProductListEventHandler.java --- |
|
(0128577) hgbot (developer) 2021-05-24 16:15 |
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal/-/merge_requests/431 [^] |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2021-05-21 08:24 | guillermogil | New Issue | |
| 2021-05-21 08:24 | guillermogil | Assigned To | => Retail |
| 2021-05-21 08:24 | guillermogil | OBNetwork customer | => Gold |
| 2021-05-21 08:24 | guillermogil | Resolution time | => 1622239200 |
| 2021-05-21 08:24 | guillermogil | Triggers an Emergency Pack | => No |
| 2021-05-21 09:58 | ranjith_qualiantech_com | Assigned To | Retail => ranjith_qualiantech_com |
| 2021-05-21 13:55 | marvintm | Note Added: 0128496 | |
| 2021-05-24 08:12 | ranjith_qualiantech_com | Status | new => scheduled |
| 2021-05-24 12:37 | hgbot | Merge Request Status | => open |
| 2021-05-24 12:37 | hgbot | Note Added: 0128555 | |
| 2021-05-24 16:14 | hgbot | Merge Request Status | open => approved |
| 2021-05-24 16:15 | hgbot | Resolution | open => fixed |
| 2021-05-24 16:15 | hgbot | Status | scheduled => closed |
| 2021-05-24 16:15 | hgbot | Fixed in Version | => RR21Q3 |
| 2021-05-24 16:15 | hgbot | Note Added: 0128576 | |
| 2021-05-24 16:15 | hgbot | Note Added: 0128577 | |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |