Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0048277Retail ModulesWeb POSpublic2021-12-17 17:302022-11-11 07:44
Reporteridiez 
Assigned Torqueralta 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in VersionRR22Q2 
Merge Request Status
Review Assigned Tomarvintm
OBNetwork customer
Support ticket
Regression level
Regression date2022-01-06
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0048277: Error duplicate an existing assortment with the existing function on the back office Open Bravo.
DescriptionError duplicate an existing assortment with the existing function on the back office Open Bravo.

The Error: duplicate key value violates unique constraint "obretco_productcategory_un" Detail: Key (ad_client_id, m_product_category_id, obretco_productlist_id) = (255610F4EA224E279210315249611061, 8A9316AC4EC2A17F4A9A3A9A7A368D1564D1564A364A9AC2D1564D1564A7A364A9A7A9A3A9A3A7A9A3A9A7A9A7A9A7D1564A7A
Steps To Reproduce1) Select the "Assortment" window

2) Click the Copy Recording button

3)Can see that it throws the following error
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files? bug.mp4 (1,482,503) 2021-12-17 17:30
https://issues.openbravo.com/file_download.php?file_id=16451&type=bug
Issue History
Date ModifiedUsernameFieldChange
2021-12-17 17:30idiezNew Issue
2021-12-17 17:30idiezAssigned To => Triage Finance
2021-12-17 17:30idiezFile Added: bug.mp4
2021-12-17 17:30idiezModules => Core
2021-12-17 17:30idiezRegression date => 2022-01-06
2021-12-17 17:30idiezTriggers an Emergency Pack => No
2021-12-23 13:33vmromanosAssigned ToTriage Finance => Retail
2022-01-10 12:06marvintmProjectOpenbravo ERP => Retail Modules
2022-01-10 12:06marvintmCategory02. Master data management => Web POS
2022-01-10 12:06marvintmversionPR20Q3 =>
2022-01-10 16:14rqueraltaAssigned ToRetail => rqueralta
2022-01-10 16:15rqueraltaStatusnew => scheduled
2022-01-14 14:51hgbotNote Added: 0134303
2022-01-18 04:21hgbotNote Added: 0134349
2022-01-18 13:11hgbotNote Added: 0134360
2022-01-21 16:20hgbotResolutionopen => fixed
2022-01-21 16:20hgbotStatusscheduled => closed
2022-01-21 16:20hgbotFixed in Version => RR22Q2
2022-01-21 16:20hgbotNote Added: 0134496
2022-01-21 16:20hgbotNote Added: 0134497
2022-10-19 17:39sofidossantStatusclosed => new
2022-10-24 08:39marvintmStatusnew => acknowledged
2022-10-24 08:39marvintmStatusacknowledged => scheduled
2022-10-24 08:39marvintmStatusscheduled => resolved
2022-10-24 08:40marvintmReview Assigned To => marvintm
2022-10-24 08:40marvintmStatusresolved => closed
2022-11-02 11:27hgbotNote Added: 0142796
2022-11-02 11:29hgbotNote Added: 0142797
2022-11-02 11:29hgbotNote Added: 0142798
2022-11-08 10:43hgbotNote Added: 0143231
2022-11-11 07:44hgbotNote Added: 0143449
2022-11-11 07:44hgbotNote Added: 0143450
2022-11-11 07:44hgbotNote Added: 0143451
2022-11-11 07:44hgbotNote Added: 0143452

Notes
(0134303)
hgbot   
2022-01-14 14:51   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal/-/merge_requests/688 [^]
(0134349)
hgbot   
2022-01-18 04:21   
Merge request closed: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal/-/merge_requests/688 [^]
(0134360)
hgbot   
2022-01-18 13:11   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.config/-/merge_requests/8 [^]
(0134496)
hgbot   
2022-01-21 16:20   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.config [^]
Changeset: fc86f4454a26d08fe19f143dd4076c94b26dbe31
Author: Rafael Queralta <rafaelcuba81@gmail.com>
Date: 18-01-2022 07:09:45
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.config/-/commit/fc86f4454a26d08fe19f143dd4076c94b26dbe31 [^]

Fixed BUG-48277: Cloned Product Category list before Product list to avoid errors in ProductListEventHandler because database is not refresh yet when this event handler run

---
M src/org/openbravo/retail/config/businesslogic/CloneProductListActionHandler.java
---
(0134497)
hgbot   
2022-01-21 16:20   
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.config/-/merge_requests/8 [^]
(0142796)
hgbot   
2022-11-02 11:27   
Merge Request created: https://gitlab.com/openbravo/ci/modules/org.openbravo.test.mobile.sampledata/-/merge_requests/44 [^]
(0142797)
hgbot   
2022-11-02 11:29   
Merge request closed: https://gitlab.com/openbravo/ci/modules/org.openbravo.test.mobile.sampledata/-/merge_requests/44 [^]
(0142798)
hgbot   
2022-11-02 11:29   
Merge Request created: https://gitlab.com/openbravo/ci/modules/org.openbravo.test.mobile.sampledata/-/merge_requests/45 [^]
(0143231)
hgbot   
2022-11-08 10:43   
Merge Request created: https://gitlab.com/openbravo/ci/mobile-test/-/merge_requests/244 [^]
(0143449)
hgbot   
2022-11-11 07:44   
Repository: https://gitlab.com/openbravo/ci/mobile-test [^]
Changeset: 768001cb672fcffcbd932c2290d912baf314cc7f
Author: Radhakrishnan Seeman <radhakrishnan@qualiantech.com>
Date: 08-11-2022 10:31:14
URL: https://gitlab.com/openbravo/ci/mobile-test/-/commit/768001cb672fcffcbd932c2290d912baf314cc7f [^]

Related to ISSUE-48277: Updated automated tests

---
M src-test/org/openbravo/test/mobile/retail/extmodules/selenium/TestIdExtModules.java
M src-test/org/openbravo/test/mobile/retail/extmodules/selenium/terminals/OTFHelper.java
M src-test/org/openbravo/test/mobile/retail/extmodules/selenium/terminals/WebPOSExtModulesTerminalHelper.java
M src-test/org/openbravo/test/mobile/retail/extmodules/selenium/tests/bestsellers/I32445_FilterByCharacteristicAndBestseller.java
M src-test/org/openbravo/test/mobile/retail/extmodules/selenium/tests/discounts_combo/I34594_VerifyComboListOnLoad.java
M src-test/org/openbravo/test/mobile/retail/extmodules/selenium/tests/fastbrowse/AddProductsAndPay.java
M src-test/org/openbravo/test/mobile/retail/extmodules/selenium/tests/fastbrowse/CheckDisplayConfigItems.java
M src-test/org/openbravo/test/mobile/retail/extmodules/selenium/tests/multiupc/CheckMultiupc.java
M src-test/org/openbravo/test/mobile/retail/extmodules/selenium/tests/pricecriteria/I32446_FilterByCharacteristicsAndPriceCriteria.java
M src-test/org/openbravo/test/mobile/retail/extmodules/selenium/tests/stockcriteria/I30410_CheckStockCriteria.java
M src-test/org/openbravo/test/mobile/retail/extmodules/selenium/tests/stockvalidation/I34569_AvoidAddingZeroStockProductOnClickOutSideTheControl.java
M src-test/org/openbravo/test/mobile/retail/pack/selenium/TestIdPack.java
---
(0143450)
hgbot   
2022-11-11 07:44   
Merge request merged: https://gitlab.com/openbravo/ci/mobile-test/-/merge_requests/244 [^]
(0143451)
hgbot   
2022-11-11 07:44   
Repository: https://gitlab.com/openbravo/ci/modules/org.openbravo.test.mobile.sampledata [^]
Changeset: b1ce8a74534e9beec2eb0ae6e611a23575e4e206
Author: Radhakrishnan Seeman <radhakrishnan@qualiantech.com>
Date: 08-11-2022 10:30:37
URL: https://gitlab.com/openbravo/ci/modules/org.openbravo.test.mobile.sampledata/-/commit/b1ce8a74534e9beec2eb0ae6e611a23575e4e206 [^]

Related to ISSUE-48277: Added missed product categories in assortment

---
M referencedata/sampledata/The_White_Valley_Group/OBRETCO_PRODUCTCATEGORY.xml
---
(0143452)
hgbot   
2022-11-11 07:44   
Merge request merged: https://gitlab.com/openbravo/ci/modules/org.openbravo.test.mobile.sampledata/-/merge_requests/45 [^]