Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0038032
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Retail Modules] Web POSmajoralways2018-03-02 12:552018-03-08 08:43
ReporterumartirenaView Statuspublic 
Assigned Toranjith_qualiantech_com 
PriorityurgentResolutionfixedFixed in VersionRR18Q2
StatusclosedFix in branchFixed in SCM revision90605eac7c10
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Tomarvintm
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0038032: Product and Product Category Master Data load fails with big amount of discounts

DescriptionProduct and Product Category Master Data load fails with big amount of discounts. These are the exact numbers:
 * m_offer: 157364
 * m_product_category: 2482
 * m_product: 262409

Steps To Reproduce-
Proposed SolutionAdd the following indexes:

create index em_obpos_m_offer_active on m_offer using btree(isactive);

create index em_obpos_m_offer_offertype on m_offer using btree(m_offer_type_id);
TagsPerformance
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to feature request 0038744 newRetail Discount Filter Product Master Data fails with big amount of data in Discounts 

-  Notes
(0102968)
hgbot (developer)
2018-03-05 07:48

 Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: 90605eac7c1000cc69fb9a2964499132194bf8f1
Author: Ranjith S R <ranjith <at> qualiantech.com>
Date: Mon Mar 05 12:18:42 2018 +0530
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/90605eac7c1000cc69fb9a2964499132194bf8f1 [^]

Fixed issue 38032 : Added index for active and offertype column in m_offer table

---
A src-db/database/model/modifiedTables/M_OFFER.xml
---
(0103064)
hgbot (developer)
2018-03-07 14:49

 Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: 51a73b872aa1b4e6a17517df086de2eba18a01ca
Author: Unai Martirena <unai.martirena <at> openbravo.com>
Date: Wed Mar 07 14:49:05 2018 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/51a73b872aa1b4e6a17517df086de2eba18a01ca [^]

Related to issue 38032: Add new index in m_offer by ad_org_id

---
M src-db/database/model/modifiedTables/M_OFFER.xml
---

- Issue History
Date Modified Username Field Change
2018-03-02 12:55 umartirena New Issue
2018-03-02 12:55 umartirena Assigned To => Retail
2018-03-02 12:55 umartirena Triggers an Emergency Pack => No
2018-03-02 12:55 umartirena Resolution time => 1521759600
2018-03-02 12:55 umartirena Tag Attached: Performance
2018-03-02 15:09 umartirena Issue Monitored: umartirena
2018-03-03 07:43 ranjith_qualiantech_com Assigned To Retail => ranjith_qualiantech_com
2018-03-03 07:44 ranjith_qualiantech_com Status new => scheduled
2018-03-05 07:48 hgbot Checkin
2018-03-05 07:48 hgbot Note Added: 0102968
2018-03-05 07:48 hgbot Status scheduled => resolved
2018-03-05 07:48 hgbot Resolution open => fixed
2018-03-05 07:48 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/90605eac7c1000cc69fb9a2964499132194bf8f1 [^]
2018-03-07 14:49 hgbot Checkin
2018-03-07 14:49 hgbot Note Added: 0103064
2018-03-08 08:43 marvintm Review Assigned To => marvintm
2018-03-08 08:43 marvintm Status resolved => closed
2018-03-08 08:43 marvintm Fixed in Version => RR18Q2
2018-06-13 09:08 umartirena Relationship added related to 0038744

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker