0041899: It is possible to have a summary product category with products

Description

Right now, if you have a product category with "Summary level" included in an assortment, this category is loaded in two different queries for category tree model, so following error is thrown:

OB.Dal.insertData: model insert 'ProductCategoryTree'; SQLError: code: 6, message: could not execute statement due to a constraint failure (19 UNIQUE constraint failed: m_product_category_tree.id);

This is caused because the first query is suposed to retrieve categories with product (with no summary level), and the second one retrieves the summary level categories, but in this case both queries return that category.

Steps To Reproduce

1. Log into https://livebuilds.openbravo.com/retail_pi_pgsql/ [^]
2. Go to Product Category window, to "Lighting & Electronics"
3. Check Summary Level
4. Do a login in POS
5. Master Data Loading Error (in console there is the error previously mentioned)

Proposed Solution

1. Not allowing to assign a summary level category to a product.
2. Not allowing to check a category with products as summary level.

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

duplicate of

defect

0044515

closed

prakashmurugesan88

Updating the "issummarylevel" property of a product category can lead to inconsistent data

Notes
There are no notes attached to this issue.

Issue History
Date Modified	Username	Field	Change
2019-09-30 10:10	joniturralde93	New Issue
2019-09-30 10:10	joniturralde93	Assigned To	=> Retail
2019-09-30 10:10	joniturralde93	Triggers an Emergency Pack	=> No
2019-09-30 11:18	Practics	Issue Monitored: Practics
2020-10-28 16:24	egoitz	Resolution time	=> 1605222000
2020-10-28 16:24	egoitz	Type	feature request => defect
2020-10-28 17:00	marvintm	Review Assigned To	=> marvintm
2020-10-28 17:00	marvintm	Relationship added	duplicate of 0044515
2020-10-28 17:00	marvintm	Status	new => closed
2020-10-28 17:00	marvintm	Resolution	open => duplicate
2020-10-28 17:00	marvintm	Fixed in Version	=> RR20Q4