Anonymous | Login
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Retail Modules] Web POScriticalalways2020-06-30 13:252020-08-11 07:25
ReportermarvintmView Statuspublic 
Assigned Toprakashmurugesan88 
PrioritynormalResolutionopenFixed in Version
StatusscheduledFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo

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

DescriptionThe WebPOS loads the product category information by reading from the obretco_product_category table, which is updated using an EventHandler. This table is supposed to contain only non summary categories.

However, if a category is initially defined as non summary level and then it is changed to be summary, the record is not removed from OBRETCO_product_category, and this is not taken into account in the filter in the corresponding masterdata query, so the category ends up being loaded twice.

If the opposite happens, and the category is initially summary and changed to be non summary, then the record is not added, so the category is not loaded in the WebPOS.
Steps To ReproduceCreate a product category as non-summary level.
Verify that it is automatically added to the tab "Filter product categories" from the Assortments.
Change it to be summary.
Realise it is not removed from the Assortment.
Do a full refresh in the WebPOS. Check that the category is loaded twice in the request.
Proposed SolutionEither we change the eventhandler to take this case into account, or we change the masterdata queries to take it, to ensure that categories are always loaded when they need to be, and never twice.

See diff attached for the update on the m_product. it is still needed to create an eventhadler to ensure the case of isSummary from N to Y
TagsNo tags attached.
Attached Filesdiff file icon 44515.diff [^] (4,483 bytes) 2020-07-21 15:02 [Show Content]

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
guillermogil (manager)
2020-07-21 14:23

Updating severity as due to this error it can led to a continuous full refresh if the till was already logged.
It should never have categories set as isSummary on the obretco_productcategory
hgbot (developer)
2020-08-11 07:25

Merge Request created: [^]

- Issue History
Date Modified Username Field Change
2020-06-30 13:25 marvintm New Issue
2020-06-30 13:25 marvintm Assigned To => Retail
2020-06-30 13:25 marvintm Triggers an Emergency Pack => No
2020-07-21 14:23 guillermogil Note Added: 0121549
2020-07-21 14:23 guillermogil Severity major => critical
2020-07-21 15:02 guillermogil File Added: 44515.diff
2020-07-21 15:02 guillermogil Proposed Solution updated
2020-07-21 15:10 guillermogil Proposed Solution updated
2020-08-06 14:28 prakashmurugesan88 Assigned To Retail => prakashmurugesan88
2020-08-10 11:57 prakashmurugesan88 Status new => scheduled
2020-08-11 07:25 hgbot Note Added: 0121957

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker