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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0041734
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Retail Modules] Web POSmajoralways2019-09-02 14:272019-09-06 08:08
Reporterjoniturralde93View Statuspublic 
Assigned Toaferraz 
PriorityurgentResolutionfixedFixed in VersionRR19Q4
StatusclosedFix in branchFixed in SCM revision94da0c7209b0
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionRR19Q3SCM revision 
Merge Request Status
Review Assigned Tomarvintm
OBNetwork customerOBPS
Support ticket11523
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0041734: Duplicated Product Category in Master data loading with cross store

DescriptionWhen a product category is included in more than one assortment from brother organizations (but not in the one you try to log in), product category data load fails.
Console log:
OB.Dal.insertData: model insert 'ProductCategory'; SQLError: code: 6, message: could not execute statement due to a constraint failure (19 UNIQUE constraint failed: m_product_category.m_product_category_id);


This is due to the cross store condition in Category.java:

    if (isCrossStore) {
      query.append(" and not exists (");
      query.append(" select 1");
      query.append(" from OBRETCO_Productcategory aCat2");
      query.append(" where aCat2.productCategory.id = pCat.id");
      query.append(" and aCat2.obretcoProductlist.id = :productListId");
      query.append(" )");
    }


This loads categories not present in current organization's assortment, but it doesn't check if those categories are duplicated in the rest of the brother cross store organizations' assortments
Steps To Reproduce1. Log into live builds pi retail backend
2. Go to Organization window and change Vall Blanca Store "Cross store organization" to White Valley Spain S.A, so now there are 3 stores with this configuration
3. Change also Vall Blanca Store assortment to 'VBS POS Terminal Type Product List', so all 3 of the stores have different assortments
4. Check that Vall Blanca store new assigned assortment has only "Backpacks & Travel' and 'Ski' in subtab 'Filter Product Categories', but the other two (Posets Products List and White Valley Group Product list) have categories not included there (for instance, Lighting & Electronics).
5. Log into VBS-1 with full refresh and reproduce the problem.
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
depends on backport 0041771RR19Q3.2 closedaferraz Duplicated Product Category in Master data loading with cross store 

-  Notes
(0114404)
hgbot (developer)
2019-09-05 08:18

 Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: 94da0c7209b0608cc97e76349e3f52b3d67cb11b
Author: Álvaro Ferraz <alvaro.ferraz <at> openbravo.com>
Date: Wed Sep 04 09:40:41 2019 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/94da0c7209b0608cc97e76349e3f52b3d67cb11b [^]

Fixes issue 41734: Avoid duplicated records in Category.getRegularProductCategoryHqlString() query

---
M src/org/openbravo/retail/posterminal/master/Category.java
---

- Issue History
Date Modified Username Field Change
2019-09-02 14:27 joniturralde93 New Issue
2019-09-02 14:27 joniturralde93 Assigned To => Retail
2019-09-02 14:27 joniturralde93 OBNetwork customer => OBPS
2019-09-02 14:27 joniturralde93 Support ticket => 11523
2019-09-02 14:27 joniturralde93 Resolution time => 1569189600
2019-09-02 14:27 joniturralde93 Triggers an Emergency Pack => No
2019-09-02 14:38 Practics Issue Monitored: Practics
2019-09-02 15:20 joniturralde93 version pi => RR19Q3
2019-09-02 15:20 joniturralde93 Target Version pi =>
2019-09-03 12:12 aferraz Assigned To Retail => aferraz
2019-09-05 07:54 aferraz Review Assigned To => marvintm
2019-09-05 08:18 hgbot Checkin
2019-09-05 08:18 hgbot Note Added: 0114404
2019-09-05 08:18 hgbot Status new => resolved
2019-09-05 08:18 hgbot Resolution open => fixed
2019-09-05 08:18 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/94da0c7209b0608cc97e76349e3f52b3d67cb11b [^]
2019-09-06 08:07 marvintm Status resolved => closed
2019-09-06 08:07 marvintm Fixed in Version => RR19Q4
2019-09-06 08:08 marvintm Status closed => new
2019-09-06 08:08 marvintm Resolution fixed => open
2019-09-06 08:08 marvintm Fixed in Version RR19Q4 =>
2019-09-06 08:08 marvintm Status new => scheduled
2019-09-06 08:08 marvintm Status scheduled => resolved
2019-09-06 08:08 marvintm Fixed in Version => RR19Q4
2019-09-06 08:08 marvintm Resolution open => fixed
2019-09-06 08:08 marvintm Status resolved => closed

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker