Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0026919Retail ModulesOffline Modepublic2014-06-23 16:092018-06-26 14:45
Reportershuehner 
Assigned ToOrekaria 
PrioritynormalSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in VersionRR14Q4 
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
Summary0026919: Stabilization: SQLTransaction errors shown on login
DescriptionOn every login to webpos when the data synchronization happens some SQLTransaction errors are logged to the console.

According to AMO probably related to wrong data in WV sampledata

See attached screenshots for details
Steps To ReproduceClear local storage
Go to webpos login page
Open developer tools console
Login (demouser/openbravo)
Notce errors related to SQLTransactions.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
duplicate of defect 0026891RR14Q3 closed malsasua Three SQL errors are being fired repeatedly 
depends on defect 0026890RR14Q3 closed malsasua The console log shows too much info and with wrong levels of detail 
blocks feature request 0027329 new Retail Stabilization: Overhaul the loading process (since the url is entered until the webpos has loaded) 
blocks feature request 0027409RR14Q4 closed Orekaria Stabilization: Add more and better log to help developers and support 
Attached Filespng Selection_011.png (81,691) 2014-06-23 16:09
https://issues.openbravo.com/file_download.php?file_id=7015&type=bug
png
Issue History
Date ModifiedUsernameFieldChange
2014-06-23 16:09shuehnerNew Issue
2014-06-23 16:09shuehnerAssigned To => marvintm
2014-06-23 16:09shuehnerTriggers an Emergency Pack => No
2014-06-23 16:09shuehnerFile Added: Selection_011.png
2014-06-23 19:12shuehnerRelationship addedduplicate of 0026891
2014-06-23 19:12shuehnerStatusnew => closed
2014-06-23 19:12shuehnerResolutionopen => duplicate
2014-07-29 09:44OrekariaNote Added: 0068951
2014-07-29 09:44OrekariaStatusclosed => new
2014-07-29 09:44OrekariaResolutionduplicate => open
2014-08-21 23:15OrekariaTarget VersionRR14Q3 => RR14Q4
2014-08-21 23:17OrekariaRelationship addedblocks 0027329
2014-08-21 23:17OrekariaSummarySQLTransaction errors shown on login => Stabilization: SQLTransaction errors shown on login
2014-08-22 02:40OrekariaRelationship addeddepends on 0026890
2014-08-22 02:47OrekariaRelationship addedblocks 0027409
2014-09-04 19:02OrekariaStatusnew => acknowledged
2014-09-04 19:03hgbotCheckin
2014-09-04 19:03hgbotNote Added: 0069971
2014-09-22 16:21mtaalTarget VersionRR14Q4 =>
2014-09-25 20:04OrekariaStatusacknowledged => scheduled
2014-09-25 20:04OrekariaAssigned Tomarvintm => Orekaria
2014-09-25 20:04Orekariafix_in_branch => pi
2014-09-25 20:05OrekariaStatusscheduled => resolved
2014-09-25 20:05OrekariaResolutionopen => fixed
2014-09-25 20:05OrekariaStatusresolved => new
2014-09-25 20:05OrekariaResolutionfixed => open
2014-09-25 20:05OrekariaStatusnew => acknowledged
2014-09-25 20:06OrekariaStatusacknowledged => scheduled
2014-09-25 20:06OrekariaStatusscheduled => resolved
2014-09-25 20:06OrekariaFixed in Version => RR14Q4
2014-09-25 20:06OrekariaResolutionopen => fixed
2014-09-26 00:38hgbotCheckin
2014-09-26 00:38hgbotNote Added: 0070412
2014-09-26 00:40hgbotCheckin
2014-09-26 00:40hgbotNote Added: 0070413
2014-09-26 00:40hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.sampledata/rev/b0e2346f3e5ff4beac6f10eca07ad6cbf02927ff [^]
2014-09-29 19:45marvintmReview Assigned To => marvintm
2014-09-29 19:45marvintmStatusresolved => closed
2018-06-26 11:37hgbotCheckin
2018-06-26 11:37hgbotNote Added: 0105397
2018-06-26 11:37hgbotStatusclosed => resolved
2018-06-26 11:37hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/pmods/org.openbravo.retail.sampledata/rev/b0e2346f3e5ff4beac6f10eca07ad6cbf02927ff [^] => http://code.openbravo.com/retail/backports/3.0RR18Q2.1/modules/org.openbravo.test.mobile.sampledata/rev/b0e2346f3e5ff4beac6f10eca07ad6cbf02927ff [^]
2018-06-26 14:45gorka_gilStatusresolved => closed
2018-06-26 14:45gorka_gilFixed in SCM revisionhttp://code.openbravo.com/retail/backports/3.0RR18Q2.1/modules/org.openbravo.test.mobile.sampledata/rev/b0e2346f3e5ff4beac6f10eca07ad6cbf02927ff [^] => http://code.openbravo.com/erp/pmods/org.openbravo.retail.sampledata/rev/b0e2346f3e5ff4beac6f10eca07ad6cbf02927ff [^]
2018-06-26 14:45gorka_gilfix_in_branchpi =>
2018-06-26 14:45gorka_gilNote Deleted: 0105397

Notes
(0068951)
Orekaria   
2014-07-29 09:44   
As of Q4, I can see 9 error messages
(0069971)
hgbot   
2014-09-04 19:03   
Repository: erp/pmods/org.openbravo.mobile.core
Changeset: 06f895bfcc4320edfd9bb095dc40dfba28165c7a
Author: Rafa Alonso <rafael.alonso <at> openbravo.com>
Date: Thu Sep 04 19:03:16 2014 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.mobile.core/rev/06f895bfcc4320edfd9bb095dc40dfba28165c7a [^]

Related to issue 26919: Better error message

---
M web/org.openbravo.mobile.core/source/data/ob-datasource.js
---
(0070412)
hgbot   
2014-09-26 00:38   
Repository: erp/pmods/org.openbravo.mobile.core
Changeset: a492e90368fe9d32edbf7fff186717da592647d1
Author: Rafa Alonso <rafael.alonso <at> openbravo.com>
Date: Fri Sep 26 00:23:33 2014 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.mobile.core/rev/a492e90368fe9d32edbf7fff186717da592647d1 [^]

Related to issue 26919: added log to catch the sql errors and its root causes

---
M web/org.openbravo.mobile.core/source/data/ob-dal.js
M web/org.openbravo.mobile.core/source/data/ob-datasource.js
M web/org.openbravo.mobile.core/source/model/ob-terminal-model.js
---
(0070413)
hgbot   
2014-09-26 00:40   
Repository: erp/pmods/org.openbravo.retail.sampledata
Changeset: b0e2346f3e5ff4beac6f10eca07ad6cbf02927ff
Author: Rafa Alonso <rafael.alonso <at> openbravo.com>
Date: Fri Sep 26 00:40:05 2014 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.sampledata/rev/b0e2346f3e5ff4beac6f10eca07ad6cbf02927ff [^]

Fixes issue 26919: the products that caused constraint errors have been removed from the assortments

---
M referencedata/sampledata/The_White_Valley_Group/OBRETCO_PROL_PRODUCT.xml
---