Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0038744Retail ModulesWeb POSpublic2018-06-13 09:082018-06-13 09:08
Reporterumartirena 
Assigned ToRetail 
PriorityurgentSeveritymajorReproducibilityalways
StatusnewResolutionopen 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0038744: Discount Filter Product Master Data fails with big amount of data in Discounts
DescriptionDiscount Filter Product Master Data fails with big amount of data in Discounts
Steps To Reproduce-
Proposed SolutionAdd the following indexes:

CREATE INDEX em_obpos_m_offer_prod_active
  ON public.m_offer_product
  USING btree
  (isactive COLLATE pg_catalog."default");
Additional Information
TagsPerformance
Relationships
related to defect 0038032 closed ranjith_qualiantech_com Product and Product Category Master Data load fails with big amount of discounts 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2018-06-13 09:08umartirenaNew Issue
2018-06-13 09:08umartirenaAssigned To => Retail
2018-06-13 09:08umartirenaResolution time => 1530655200
2018-06-13 09:08umartirenaTriggers an Emergency Pack => No
2018-06-13 09:08umartirenaTag Attached: Performance
2018-06-13 09:08umartirenaRelationship addedrelated to 0038032

There are no notes attached to this issue.