Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0030369Retail ModulesWeb POSpublic2015-07-15 16:352015-09-15 15:27
Reportermarvintm 
Assigned Tomarvintm 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in VersionRR15Q4 
Merge Request Status
Review Assigned ToOrekaria
OBNetwork customer
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0030369: The modulescript FixDataIssue27425 is extremely slow with a moderately big amount of data
DescriptionThis modulescript runs very slow if there is a moderately big amount of data. As the fix was only relevant for two specific old versions of the Web POS, the best solution here is to remove the script.
Steps To Reproduce- Run update.database with Retail installed, in a database with a big amount of invoices.
- Verify that the modulescript FixDataIssue27425 takes a very long time to execute.
Proposed Solution-Remove the modulescript.
Additional Information
TagsNo tags attached.
Relationships
depends on backport 0030370RR15Q3 closed marvintm The modulescript FixDataIssue27425 is extremely slow with a moderately big amount of data 
depends on backport 0030371RR15Q2.3 closed marvintm The modulescript FixDataIssue27425 is extremely slow with a moderately big amount of data 
has duplicate defect 0030411 closed Retail FixDataIssue27425 takes a very long time when the tables have more than 1.000.000 rows 
has duplicate defect 0029797 closed Retail update.database performance is degraded by module script for issue 27425 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2015-07-15 16:35marvintmNew Issue
2015-07-15 16:35marvintmAssigned To => marvintm
2015-07-15 16:35marvintmTriggers an Emergency Pack => No
2015-07-15 16:35marvintmStatusnew => scheduled
2015-07-15 16:36VictorVillarIssue Monitored: VictorVillar
2015-08-14 12:25hgbotCheckin
2015-08-14 12:25hgbotNote Added: 0079354
2015-08-14 12:25hgbotStatusscheduled => resolved
2015-08-14 12:25hgbotResolutionopen => fixed
2015-08-14 12:25hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/17579cfe592dc8b7590666700e326f1f1d7010a7 [^]
2015-08-14 12:25marvintmRelationship addedhas duplicate 0030411
2015-09-15 15:27OrekariaReview Assigned To => Orekaria
2015-09-15 15:27OrekariaStatusresolved => closed
2015-09-15 15:27OrekariaFixed in Version => RR15Q4
2016-03-08 20:38OrekariaRelationship addedhas duplicate 0029797

Notes
(0079354)
hgbot   
2015-08-14 12:25   
Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: 17579cfe592dc8b7590666700e326f1f1d7010a7
Author: Antonio Moreno <antonio.moreno <at> openbravo.com>
Date: Fri Aug 14 12:24:50 2015 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/17579cfe592dc8b7590666700e326f1f1d7010a7 [^]

Fixed issue 30369. Removed slow modulescript.

---
R build/classes/org/openbravo/retail/posterminal/modulescript/FixDataIssue27425.class
R build/classes/org/openbravo/retail/posterminal/modulescript/FixDataIssue27425Data.class
R src-util/modulescript/src/org/openbravo/retail/posterminal/modulescript/FixDataIssue27425.java
R src-util/modulescript/src/org/openbravo/retail/posterminal/modulescript/FixDataIssue27425_Data.xsql
---