Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0034710Retail ModulesMulti UPC/EAN for Productpublic2016-12-08 14:002016-12-09 00:40
Reporterguillermogil 
Assigned Toguillermogil 
PriorityurgentSeveritymajorReproducibilityrandom
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned Tomarvintm
OBNetwork customer
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0034710: Multi UPC query has no order by which is causing duplicated records
DescriptionMulti UPC query has no order by which is causing duplicated records.
This error is generating a lot (> 40000) errors in log client and WebPOS was trying to sync them all which was causing timeouts and finally it was not possible to login.
Steps To ReproduceSince this is random it has not been possible to find the steps.
It was an environment with 84000 MultiUPC records with postgres 9.2
Proposed SolutionAdd at the end of the query an "order by id"
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2016-12-08 14:00guillermogilNew Issue
2016-12-08 14:00guillermogilAssigned To => guillermogil
2016-12-08 14:00guillermogilResolution time => 1481756400
2016-12-08 14:00guillermogilTriggers an Emergency Pack => No
2016-12-08 14:17guillermogilReview Assigned To => marvintm
2016-12-08 14:19hgbotCheckin
2016-12-08 14:19hgbotNote Added: 0092213
2016-12-08 14:19hgbotStatusnew => resolved
2016-12-08 14:19hgbotResolutionopen => fixed
2016-12-08 14:19hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.multiupc/rev/394ead89bd74dfccb0509f44546253c98976a193 [^]
2016-12-08 14:20guillermogilSummaryMulti UPC query has no order by which is causing duplicated errors => Multi UPC query has no order by which is causing duplicated records
2016-12-08 14:20guillermogilDescription Updatedbug_revision_view_page.php?rev_id=13966#r13966
2016-12-09 00:39marvintmSeveritytrivial => major
2016-12-09 00:40marvintmStatusresolved => closed

Notes
(0092213)
hgbot   
2016-12-08 14:19   
Repository: erp/pmods/org.openbravo.retail.multiupc
Changeset: 394ead89bd74dfccb0509f44546253c98976a193
Author: Guillermo Gil <guillermo.gil <at> openbravo.com>
Date: Thu Dec 08 14:16:57 2016 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.multiupc/rev/394ead89bd74dfccb0509f44546253c98976a193 [^]

Fixed issue 34710: Multi UPC query has no order by

Added order by clause in order to do not send duplicated errors to WebPOS

---
M src/org/openbravo/retail/multiupc/MultiUPC.java
---