Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0041885
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Retail Modules] Retail Configurationmajoralways2019-09-25 11:342020-09-18 10:08
Reportersanti_lozanoView Statuspublic 
Assigned Toranjith_qualiantech_com 
PriorityhighResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision49fd60970b9c
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
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
Summary

0041885: 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.”)
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]

-  Notes
(0114942)
hgbot (developer)
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 (viewer)
2019-10-16 14:11

 Verified and tested

- Issue History
Date Modified Username Field Change
2019-09-25 11:34 santi_lozano New Issue
2019-09-25 11:34 santi_lozano Assigned To => platform
2019-09-25 11:34 santi_lozano OBNetwork customer => OBPS
2019-09-25 11:34 santi_lozano Modules => Core
2019-09-25 11:34 santi_lozano Support ticket => 11889
2019-09-25 11:34 santi_lozano Resolution time => 1476568800
2019-09-25 11:34 santi_lozano Triggers an Emergency Pack => No
2019-09-25 11:40 santi_lozano Resolution time 1476568800 => 1571176800
2019-09-25 11:42 Practics Issue Monitored: Practics
2019-09-26 16:27 AugustoMauch Assigned To platform => Retail
2019-09-26 16:29 marvintm Project Openbravo ERP => Retail Modules
2019-10-01 13:32 ranjith_qualiantech_com Assigned To Retail => ranjith_qualiantech_com
2019-10-01 13:33 ranjith_qualiantech_com Status new => scheduled
2019-10-08 07:52 hgbot Checkin
2019-10-08 07:52 hgbot Note Added: 0114942
2019-10-08 07:52 hgbot Status scheduled => resolved
2019-10-08 07:52 hgbot Resolution open => fixed
2019-10-08 07:52 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.config/rev/49fd60970b9c776d2bc9b9f5c3130870a3ec6094 [^]
2019-10-16 14:11 adrianromero Review Assigned To => adrianromero
2019-10-16 14:11 adrianromero Category A. Platform => Aging Balance Report
2019-10-16 14:11 adrianromero Note Added: 0115113
2019-10-16 14:11 adrianromero Status resolved => closed
2020-09-18 10:08 ngarcia Category Aging Balance Report => Retail Configuration

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker