Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0024810Retail ModulesWeb POSpublic2013-09-23 11:022013-12-20 15:08
Reporterjecharri 
Assigned Tomalsasua 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionRMP28Fixed in VersionRMP28 
Merge Request Status
Review Assigned Toguilleaer
OBNetwork customerOBPS
Support ticket23175
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0024810: Performance problem during the cash up
DescriptionPerformance problem during the cash up.

If you are working with huge quantity of records in table c_orderline the cash up always is slow.

I have one database where method "groupOrders" it takes 25-30 seconds to do a cash up withour any order (the problem is the query that we are executing, it is really slow)
Steps To Reproduce-Login in web POS and try to execute a cash up
Proposed Solution
Additional Information
TagsPerformance
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2013-09-23 11:02jecharriNew Issue
2013-09-23 11:02jecharriAssigned To => marvintm
2013-09-23 11:02jecharriOBNetwork customer => Yes
2013-09-23 11:02jecharriSupport ticket => 23175
2013-09-23 11:02jecharriResolution time => 1382652000
2013-09-23 11:02jecharriTriggers an Emergency Pack => No
2013-09-23 11:02jecharriTag Attached: Performance
2013-09-25 12:30umartirenaAssigned Tomarvintm => umartirena
2013-10-02 12:50marvintmAssigned Toumartirena => malsasua
2013-10-07 11:13hgbotCheckin
2013-10-07 11:13hgbotNote Added: 0061563
2013-10-07 11:13hgbotStatusnew => resolved
2013-10-07 11:13hgbotResolutionopen => fixed
2013-10-07 11:13hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/5fb5f532e4f8b3a9475c03406e343adb0087bb3f [^]
2013-10-07 11:16malsasuaNote Added: 0061564
2013-10-07 17:44guilleaerReview Assigned To => guilleaer
2013-10-07 17:44guilleaerNote Added: 0061595
2013-10-07 17:44guilleaerStatusresolved => closed
2013-10-07 17:44guilleaerFixed in Version => RMP28
2013-10-08 11:42hgbotCheckin
2013-10-08 11:42hgbotNote Added: 0061606
2013-10-08 11:42hgbotStatusclosed => resolved
2013-10-08 11:42hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/5fb5f532e4f8b3a9475c03406e343adb0087bb3f [^] => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal-levelpricing/rev/5fb5f532e4f8b3a9475c03406e343adb0087bb3f [^]
2013-10-08 11:44guilleaerNote Added: 0061615
2013-10-08 11:44guilleaerStatusresolved => closed
2013-10-08 16:01ngarciaIssue Monitored: ngarcia
2013-10-15 18:34malsasuaRelationship addedrelated to 0024942
2013-10-16 10:19hgbotCheckin
2013-10-16 10:19hgbotNote Added: 0061689
2013-10-16 10:19hgbotStatusclosed => resolved
2013-10-16 10:19hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal-levelpricing/rev/5fb5f532e4f8b3a9475c03406e343adb0087bb3f [^] => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/4c11643ccb35ef2292507f1e44c37787e2ac2c1a [^]
2013-10-16 10:53malsasuaRelationship deletedrelated to 0024942
2013-10-16 13:38hgbotCheckin
2013-10-16 13:38hgbotNote Added: 0061700
2013-10-16 13:38hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/4c11643ccb35ef2292507f1e44c37787e2ac2c1a [^] => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal.cirque/rev/5fb5f532e4f8b3a9475c03406e343adb0087bb3f [^]
2013-10-16 13:41hgbotCheckin
2013-10-16 13:41hgbotNote Added: 0061715
2013-10-16 13:41hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal.cirque/rev/5fb5f532e4f8b3a9475c03406e343adb0087bb3f [^] => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal.cirque/rev/4c11643ccb35ef2292507f1e44c37787e2ac2c1a [^]
2013-10-17 18:32guilleaerNote Added: 0061788
2013-10-17 18:32guilleaerStatusresolved => closed
2013-11-18 06:54hgbotCheckin
2013-11-18 06:54hgbotNote Added: 0062157
2013-11-18 06:54hgbotStatusclosed => resolved
2013-11-18 06:54hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal.cirque/rev/4c11643ccb35ef2292507f1e44c37787e2ac2c1a [^] => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/1c23d8d19ad06951aafd1612eaa0c778ed27ee80 [^]
2013-11-18 06:54priyamStatusresolved => closed
2013-11-18 12:51hgbotCheckin
2013-11-18 12:51hgbotNote Added: 0062172
2013-11-18 12:51hgbotStatusclosed => resolved
2013-11-18 12:51hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/1c23d8d19ad06951aafd1612eaa0c778ed27ee80 [^] => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal-splitlines/rev/4c11643ccb35ef2292507f1e44c37787e2ac2c1a [^]
2013-11-18 12:56hgbotCheckin
2013-11-18 12:56hgbotNote Added: 0062206
2013-11-18 12:56hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal-splitlines/rev/4c11643ccb35ef2292507f1e44c37787e2ac2c1a [^] => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal-splitlines/rev/1c23d8d19ad06951aafd1612eaa0c778ed27ee80 [^]
2013-11-19 18:16marvintmStatusresolved => closed
2013-12-05 12:12hgbotCheckin
2013-12-05 12:12hgbotNote Added: 0062574
2013-12-05 12:12hgbotStatusclosed => resolved
2013-12-05 12:12hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal-splitlines/rev/1c23d8d19ad06951aafd1612eaa0c778ed27ee80 [^] => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal.cirque/rev/1c23d8d19ad06951aafd1612eaa0c778ed27ee80 [^]
2013-12-05 17:21guilleaerNote Added: 0062612
2013-12-05 17:21guilleaerStatusresolved => closed
2013-12-19 19:46hgbotCheckin
2013-12-19 19:46hgbotNote Added: 0062902
2013-12-19 19:46hgbotStatusclosed => resolved
2013-12-19 19:46hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal.cirque/rev/1c23d8d19ad06951aafd1612eaa0c778ed27ee80 [^] => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal.offline/rev/1c23d8d19ad06951aafd1612eaa0c778ed27ee80 [^]
2013-12-20 15:08guilleaerNote Added: 0063001
2013-12-20 15:08guilleaerStatusresolved => closed

Notes
(0061563)
hgbot   
2013-10-07 11:13   
Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: 5fb5f532e4f8b3a9475c03406e343adb0087bb3f
Author: Miguel A. Alsasua <miguel.alsasua <at> openbravo.com>
Date: Mon Oct 07 11:13:06 2013 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/5fb5f532e4f8b3a9475c03406e343adb0087bb3f [^]

Fixed issue 24810: Performance problem during the cash up

---
M src/org/openbravo/retail/posterminal/OrderGroupingProcessor.java
---
(0061564)
malsasua   
2013-10-07 11:16   
Deleted the query section about fin_payment_schedule_detail don't exist. When a SO is paid with an advanced payment, the invoice is created in that moment. Then, in the cashup process, this SO should be ignored
(0061595)
guilleaer   
2013-10-07 17:44   
verified
(0061606)
hgbot   
2013-10-08 11:42   
Repository: erp/pmods/org.openbravo.retail.posterminal-levelpricing
Changeset: 5fb5f532e4f8b3a9475c03406e343adb0087bb3f
Author: Miguel A. Alsasua <miguel.alsasua <at> openbravo.com>
Date: Mon Oct 07 11:13:06 2013 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal-levelpricing/rev/5fb5f532e4f8b3a9475c03406e343adb0087bb3f [^]

Fixed issue 24810: Performance problem during the cash up

---
M src/org/openbravo/retail/posterminal/OrderGroupingProcessor.java
---
(0061615)
guilleaer   
2013-10-08 11:44   
reclosing
(0061689)
hgbot   
2013-10-16 10:19   
Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: 4c11643ccb35ef2292507f1e44c37787e2ac2c1a
Author: Miguel A. Alsasua <miguel.alsasua <at> openbravo.com>
Date: Wed Oct 16 10:18:32 2013 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/4c11643ccb35ef2292507f1e44c37787e2ac2c1a [^]

Fixed issue 24810: Performance problem during the cash up

---
M src/org/openbravo/retail/posterminal/OrderGroupingProcessor.java
---
(0061700)
hgbot   
2013-10-16 13:38   
Repository: erp/pmods/org.openbravo.retail.posterminal.cirque
Changeset: 5fb5f532e4f8b3a9475c03406e343adb0087bb3f
Author: Miguel A. Alsasua <miguel.alsasua <at> openbravo.com>
Date: Mon Oct 07 11:13:06 2013 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal.cirque/rev/5fb5f532e4f8b3a9475c03406e343adb0087bb3f [^]

Fixed issue 24810: Performance problem during the cash up

---
M src/org/openbravo/retail/posterminal/OrderGroupingProcessor.java
---
(0061715)
hgbot   
2013-10-16 13:41   
Repository: erp/pmods/org.openbravo.retail.posterminal.cirque
Changeset: 4c11643ccb35ef2292507f1e44c37787e2ac2c1a
Author: Miguel A. Alsasua <miguel.alsasua <at> openbravo.com>
Date: Wed Oct 16 10:18:32 2013 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal.cirque/rev/4c11643ccb35ef2292507f1e44c37787e2ac2c1a [^]

Fixed issue 24810: Performance problem during the cash up

---
M src/org/openbravo/retail/posterminal/OrderGroupingProcessor.java
---
(0061788)
guilleaer   
2013-10-17 18:32   
reclosed
(0062157)
hgbot   
2013-11-18 06:54   
Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: 1c23d8d19ad06951aafd1612eaa0c778ed27ee80
Author: Priya Muthukumar <priya.muthukumar <at> openbravo.com>
Date: Fri Nov 08 12:30:34 2013 +0000
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/1c23d8d19ad06951aafd1612eaa0c778ed27ee80 [^]

Fixed issue 24810: Performance problem during the cash up. fixed issue 25081: Quotations lines are not invoiced when cash up is done

---
M src/org/openbravo/retail/posterminal/OrderGroupingProcessor.java
---
(0062172)
hgbot   
2013-11-18 12:51   
Repository: erp/pmods/org.openbravo.retail.posterminal-splitlines
Changeset: 4c11643ccb35ef2292507f1e44c37787e2ac2c1a
Author: Miguel A. Alsasua <miguel.alsasua <at> openbravo.com>
Date: Wed Oct 16 10:18:32 2013 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal-splitlines/rev/4c11643ccb35ef2292507f1e44c37787e2ac2c1a [^]

Fixed issue 24810: Performance problem during the cash up

---
M src/org/openbravo/retail/posterminal/OrderGroupingProcessor.java
---
(0062206)
hgbot   
2013-11-18 12:56   
Repository: erp/pmods/org.openbravo.retail.posterminal-splitlines
Changeset: 1c23d8d19ad06951aafd1612eaa0c778ed27ee80
Author: Priya Muthukumar <priya.muthukumar <at> openbravo.com>
Date: Fri Nov 08 12:30:34 2013 +0000
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal-splitlines/rev/1c23d8d19ad06951aafd1612eaa0c778ed27ee80 [^]

Fixed issue 24810: Performance problem during the cash up. fixed issue 25081: Quotations lines are not invoiced when cash up is done

---
M src/org/openbravo/retail/posterminal/OrderGroupingProcessor.java
---
(0062574)
hgbot   
2013-12-05 12:12   
Repository: erp/pmods/org.openbravo.retail.posterminal.cirque
Changeset: 1c23d8d19ad06951aafd1612eaa0c778ed27ee80
Author: Priya Muthukumar <priya.muthukumar <at> openbravo.com>
Date: Fri Nov 08 12:30:34 2013 +0000
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal.cirque/rev/1c23d8d19ad06951aafd1612eaa0c778ed27ee80 [^]

Fixed issue 24810: Performance problem during the cash up. fixed issue 25081: Quotations lines are not invoiced when cash up is done

---
M src/org/openbravo/retail/posterminal/OrderGroupingProcessor.java
---
(0062612)
guilleaer   
2013-12-05 17:21   
Reclosing
(0062902)
hgbot   
2013-12-19 19:46   
Repository: erp/pmods/org.openbravo.retail.posterminal.offline
Changeset: 1c23d8d19ad06951aafd1612eaa0c778ed27ee80
Author: Priya Muthukumar <priya.muthukumar <at> openbravo.com>
Date: Fri Nov 08 12:30:34 2013 +0000
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal.offline/rev/1c23d8d19ad06951aafd1612eaa0c778ed27ee80 [^]

Fixed issue 24810: Performance problem during the cash up. fixed issue 25081: Quotations lines are not invoiced when cash up is done

---
M src/org/openbravo/retail/posterminal/OrderGroupingProcessor.java
---
(0063001)
guilleaer   
2013-12-20 15:08   
reclosed