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

Openbravo Issue Tracking System - Retail Modules

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0041771

Retail Modules

Web POS

public

2019-09-02 14:27

2019-09-06 09:42

Reporter

joniturralde93

Assigned To

aferraz

Priority

urgent

Severity

major

Reproducibility

always

Status

closed

Resolution

fixed

Platform

OS Version

Product Version

RR19Q3

Target Version

RR19Q3.2

Fixed in Version

RR19Q3.1

Merge Request Status

Review Assigned To

marvintm

OBNetwork customer

OBPS

Support ticket

11523

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

Summary

0041771: 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.

Proposed Solution

Additional Information