Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0041885Retail ModulesRetail Configurationpublic2019-09-25 11:342020-09-18 10:08
Reportersanti_lozano 
Assigned Toranjith_qualiantech_com 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned Toadrianromero
OBNetwork customerOBPS
Support ticket11889
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0041885: Include all products to assortment duplicate key value error
DescriptionIn assortment window when clicking on button Include All Products and then OK an error of duplicate key values appears. Which is related to product categories that it’s maybe trying to add more than once at the tab Filter Product Categories
Steps To Reproduce*go to Openbravo Livebuilds and enter to pgsql_pi Backend of Retail with Modules section
*go to window Assortment (with role The White Valley Group Admin), select any assortment
*click on button Include All Products, then OK
*an error is displayed (like “ERROR: duplicate key value violates unique constraint "obretco_productcategory_un" Detail: Key (ad_client_id, m_product_category_id, obretco_productlist_id)=(39363B0921BB4293B48383844325E84C, 0C20B3F7AB234915B2239FCD8BE10CD1, F113F16954CB48FAB6D20252C986872F) already exists.”)
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2019-09-25 11:34santi_lozanoNew Issue
2019-09-25 11:34santi_lozanoAssigned To => platform
2019-09-25 11:34santi_lozanoOBNetwork customer => OBPS
2019-09-25 11:34santi_lozanoModules => Core
2019-09-25 11:34santi_lozanoSupport ticket => 11889
2019-09-25 11:34santi_lozanoResolution time => 1476568800
2019-09-25 11:34santi_lozanoTriggers an Emergency Pack => No
2019-09-25 11:40santi_lozanoResolution time1476568800 => 1571176800
2019-09-25 11:42PracticsIssue Monitored: Practics
2019-09-26 16:27AugustoMauchAssigned Toplatform => Retail
2019-09-26 16:29marvintmProjectOpenbravo ERP => Retail Modules
2019-10-01 13:32ranjith_qualiantech_comAssigned ToRetail => ranjith_qualiantech_com
2019-10-01 13:33ranjith_qualiantech_comStatusnew => scheduled
2019-10-08 07:52hgbotCheckin
2019-10-08 07:52hgbotNote Added: 0114942
2019-10-08 07:52hgbotStatusscheduled => resolved
2019-10-08 07:52hgbotResolutionopen => fixed
2019-10-08 07:52hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.config/rev/49fd60970b9c776d2bc9b9f5c3130870a3ec6094 [^]
2019-10-16 14:11adrianromeroReview Assigned To => adrianromero
2019-10-16 14:11adrianromeroCategoryA. Platform => Aging Balance Report
2019-10-16 14:11adrianromeroNote Added: 0115113
2019-10-16 14:11adrianromeroStatusresolved => closed
2020-09-18 10:08ngarciaCategoryAging Balance Report => Retail Configuration

Notes
(0114942)
hgbot   
2019-10-08 07:52   
Repository: erp/pmods/org.openbravo.retail.config
Changeset: 49fd60970b9c776d2bc9b9f5c3130870a3ec6094
Author: Ranjith S R <ranjith <at> qualiantech.com>
Date: Tue Oct 08 11:21:44 2019 +0530
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.config/rev/49fd60970b9c776d2bc9b9f5c3130870a3ec6094 [^]

Fixed issue 41885 : Assortment Product should be saved when IncludeAllProduct process is called

* When Assortment Product is saved, Event Handler will be called to save the Assortment Category
  Due to flush() method is called after n times, Assortment Category exists() validation fails.
  So flush() method should be called for each Assortment Product

---
M src/org/openbravo/retail/config/process/IncludeAllProducts.java
---
(0115113)
adrianromero   
2019-10-16 14:11   
Verified and tested