Anonymous | Login

Project:

News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ]

[ Issue History ] [ Print ]

ID

0041734

Type

Category

Severity

Reproducibility

Date Submitted

Last Update

defect

[Retail Modules] Web POS

major

always

2019-09-02 14:27

2019-09-06 08:08

Reporter

joniturralde93

View Status

public

Assigned To

aferraz

Priority

urgent

Resolution

fixed

Fixed in Version

RR19Q4

Status

closed

Fix in branch

Fixed in SCM revision

Projection

none

ETA

none

Target Version

OS

Any

Database

Any

Java version

OS Version

Database version

Ant version

Product Version

RR19Q3

SCM revision

Review Assigned To

marvintm

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

No

Summary

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

Description

When 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 Reproduce

1. 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.

Tags

No tags attached.

Relationships [ Relation Graph ] [ Dependency Graph ]

depends on

backport

RR19Q3.2

closed

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	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