Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0024844Retail ModulesWeb POSpublic2013-09-30 12:172013-10-17 18:27
Reporterguilleaer 
Assigned Toguilleaer 
PriorityimmediateSeveritycriticalReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionRMP27Fixed in VersionRMP27 
Merge Request Status
Review Assigned Tomarvintm
OBNetwork customerNo
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0024844: WEB POS get stucked with lot of products
DescriptionThe problems is happening with lot of products.

The cause of the problem is the new query added to product.java which retrieves generic products.

We need to create an index for the column "m_product_id" in the table "obretco_prol_product".
Steps To ReproduceCreate a huge qty of products (10000) and try to login in web pos.
Proposed Solutioncreate an index for the column "m_product_id" in the table "obretco_prol_product".
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2013-09-30 12:17guilleaerNew Issue
2013-09-30 12:17guilleaerAssigned To => guilleaer
2013-09-30 12:17guilleaerOBNetwork customer => No
2013-09-30 12:17guilleaerTriggers an Emergency Pack => No
2013-09-30 12:19hgbotCheckin
2013-09-30 12:19hgbotNote Added: 0061478
2013-09-30 12:19hgbotStatusnew => resolved
2013-09-30 12:19hgbotResolutionopen => fixed
2013-09-30 12:19hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.config/rev/a0cacbdc8f9fd5f73acec39088d6c15505725c24 [^]
2013-09-30 17:58marvintmReview Assigned To => marvintm
2013-09-30 17:58marvintmStatusresolved => closed
2013-09-30 17:58marvintmFixed in Version => RMP27
2013-10-02 10:45hgbotCheckin
2013-10-02 10:45hgbotNote Added: 0061518
2013-10-02 10:45hgbotStatusclosed => resolved
2013-10-02 10:45hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/pmods/org.openbravo.retail.config/rev/a0cacbdc8f9fd5f73acec39088d6c15505725c24 [^] => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/478bdb50bf5ad5080821ab993b2f3238023e3bd2 [^]
2013-10-04 09:28hgbotCheckin
2013-10-04 09:28hgbotNote Added: 0061535
2013-10-04 09:28hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/478bdb50bf5ad5080821ab993b2f3238023e3bd2 [^] => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal-levelpricing/rev/478bdb50bf5ad5080821ab993b2f3238023e3bd2 [^]
2013-10-04 09:30guilleaerNote Added: 0061539
2013-10-04 09:30guilleaerStatusresolved => closed
2013-10-16 13:38hgbotCheckin
2013-10-16 13:38hgbotNote Added: 0061696
2013-10-16 13:38hgbotStatusclosed => resolved
2013-10-16 13:38hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal-levelpricing/rev/478bdb50bf5ad5080821ab993b2f3238023e3bd2 [^] => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal.cirque/rev/478bdb50bf5ad5080821ab993b2f3238023e3bd2 [^]
2013-10-17 18:27guilleaerNote Added: 0061780
2013-10-17 18:27guilleaerStatusresolved => closed

Notes
(0061478)
hgbot   
2013-09-30 12:19   
Repository: erp/pmods/org.openbravo.retail.config
Changeset: a0cacbdc8f9fd5f73acec39088d6c15505725c24
Author: Guillermo Alvarez de Eulate <guillermo.alvarez <at> openbravo.com>
Date: Mon Sep 30 12:18:52 2013 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.config/rev/a0cacbdc8f9fd5f73acec39088d6c15505725c24 [^]

fixed issue 24844: An index has been created for the column m_product_id of table obretco_prol_product

---
M src-db/database/model/tables/OBRETCO_PROL_PRODUCT.xml
---
(0061518)
hgbot   
2013-10-02 10:45   
Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: 478bdb50bf5ad5080821ab993b2f3238023e3bd2
Author: Guillermo Alvarez de Eulate <guillermo.alvarez <at> openbravo.com>
Date: Tue Oct 01 18:49:40 2013 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/478bdb50bf5ad5080821ab993b2f3238023e3bd2 [^]

fixed issue 24844: the query to add generic products has been changed

---
M src/org/openbravo/retail/posterminal/master/Product.java
---
(0061535)
hgbot   
2013-10-04 09:28   
Repository: erp/pmods/org.openbravo.retail.posterminal-levelpricing
Changeset: 478bdb50bf5ad5080821ab993b2f3238023e3bd2
Author: Guillermo Alvarez de Eulate <guillermo.alvarez <at> openbravo.com>
Date: Tue Oct 01 18:49:40 2013 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal-levelpricing/rev/478bdb50bf5ad5080821ab993b2f3238023e3bd2 [^]

fixed issue 24844: the query to add generic products has been changed

---
M src/org/openbravo/retail/posterminal/master/Product.java
---
(0061539)
guilleaer   
2013-10-04 09:30   
reclosed
(0061696)
hgbot   
2013-10-16 13:38   
Repository: erp/pmods/org.openbravo.retail.posterminal.cirque
Changeset: 478bdb50bf5ad5080821ab993b2f3238023e3bd2
Author: Guillermo Alvarez de Eulate <guillermo.alvarez <at> openbravo.com>
Date: Tue Oct 01 18:49:40 2013 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal.cirque/rev/478bdb50bf5ad5080821ab993b2f3238023e3bd2 [^]

fixed issue 24844: the query to add generic products has been changed

---
M src/org/openbravo/retail/posterminal/master/Product.java
---
(0061780)
guilleaer   
2013-10-17 18:27   
reclosed