Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0050197Retail ModulesDiscounts and Promotionspublic2022-09-07 18:242022-09-12 06:44
Reporterrtoledano 
Assigned Tortoledano 
PrioritynormalSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0050197: Error handling duplicated records for add organization, product and product categories in Discount and Promotion windows
DescriptionDuplicated records are not properly handled when we want to add products, products categories and organization from Discount and Promotions
Steps To ReproduceGot to https://livebuilds.openbravo.com/retail_modules_pgsql_pi [^] on Discount and Promotions window

 1- Select a discount of type Price adjustment
 2- Adding duplicated organizations:
      2.1- Select Button Add Organization
      2.2- Select "F&B US West Coast"
      2.3- Click on Done
      2.4- Select Button Add Organization
      2.5- Select fist "F&B US East Coast" and then select "F&B US West Coast"
      2.6- Click on Done.
      2.7- Check that loading popup do not finalize
 3- Adding duplicated Product categories:
      3.1- Select Button Add Product Categories
      3.2- Select "Alcoholic"
      3.3- Click on Done
      3.4- Select Button Add Product Categories
      3.5- Select fist "Bio" and then select "Alcoholic"
      3.6- Click on Done.
      3.7- Check that loading popup do not finalize
 4- Adding duplicated Products:
      4.1- Select Button Add Products
      4.2- Select "Cerveza Ale 0,5L"
      4.3- Click on Done
      4.4- Select Button Add Products
      4.5- Select fist "Cerveza Lager 0,5L" and then select "Cerveza Ale 0,5L"
      4.6- Click on Done.
      4.7- Check that loading popup do not finalize
Proposed Solution
Additional Information
TagsNOR
Relationships
related to feature request 0048297 closed psanjuan Discount filter enhancement : Filter by “summary level” product categories - NOE 5219 and 5351 - Jira RM-114 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2022-09-07 18:24rtoledanoNew Issue
2022-09-07 18:24rtoledanoAssigned To => rtoledano
2022-09-07 18:24rtoledanoTriggers an Emergency Pack => No
2022-09-07 21:46hgbotNote Added: 0140831
2022-09-08 00:04rtoledanoTag Attached: NOR
2022-09-08 09:21sebastien_lironIssue Monitored: sebastien_liron
2022-09-08 16:02rafarodaRelationship addedrelated to 0048297
2022-09-12 06:44hgbotResolutionopen => fixed
2022-09-12 06:44hgbotStatusnew => closed
2022-09-12 06:44hgbotFixed in Version => PR22Q4
2022-09-12 06:44hgbotNote Added: 0140987
2022-09-12 06:44hgbotNote Added: 0140988

Notes
(0140831)
hgbot   
2022-09-07 21:46   
Merge Request created: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/703 [^]
(0140987)
hgbot   
2022-09-12 06:44   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/openbravo [^]
Changeset: 124fb9ea67dd5feb52c748f4d7aec1c06feb3d1b
Author: Roberto Carlos Toledano Gómez <rctg82@gmail.com>
Date: 12-09-2022 04:44:21
URL: https://gitlab.com/openbravo/product/openbravo/-/commit/124fb9ea67dd5feb52c748f4d7aec1c06feb3d1b [^]

Fixed ISSUE-50197: Additional flush instruction is added for the remaining records. This way you avoid throwing an unhandled exception due to database constrainst.

---
M src/org/openbravo/common/actionhandler/OfferPickOrgActionHandler.java
M src/org/openbravo/common/actionhandler/OfferPickProductActionHandler.java
M src/org/openbravo/common/actionhandler/OfferPickProductCategoryActionHandler.java
---
(0140988)
hgbot   
2022-09-12 06:44   
Merge request merged: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/703 [^]