Openbravo Issue Tracking System - Retail Modules
View Issue Details
0031824Retail ModulesWeb POSpublic2016-01-05 17:572016-01-19 15:18
mtaal 
mtaal 
normalmajorhave not tried
closedfixed 
5
 
RR16Q2 
migueldejuana
No
0031824: Import entry may not get saved in case of low level database error, webpos sees message as succesfully send
When there is a low level error when saving an import entry the WebPOS client will think that the message is saved on the server and will remove it from the local cache.
1- Login to webpos
2- Create a trigger which gives an exception, set as after-insert trigger on c_import_entry table. See the example trigger function attached to the issue.
3- Create a ticket in webpos and submit
4- The ticket is not saved on the server but still removed from webpos

See the attached stack trace for what the console shows.
on the server create the correct error json and set a failure status code so that the webpos client correctly signals an error.
No tags attached.
depends on backport 0031825RR16Q1 closed mtaal Import entry may not get saved in case of low level database error, webpos sees message as succesfully send 
depends on backport 0031826RR15Q4.2 closed mtaal Import entry may not get saved in case of low level database error, webpos sees message as succesfully send 
causes defect 0037301 closed marvintm Java Heap Memory can rise on login if batch size is big 
txt trigger.txt (50) 2016-01-05 17:57
https://issues.openbravo.com/file_download.php?file_id=8891&type=bug
txt stack-trace.txt (54,739) 2016-01-05 17:58
https://issues.openbravo.com/file_download.php?file_id=8892&type=bug
Issue History
2016-01-05 17:57mtaalNew Issue
2016-01-05 17:57mtaalAssigned To => mtaal
2016-01-05 17:57mtaalFile Added: trigger.txt
2016-01-05 17:57mtaalTriggers an Emergency Pack => No
2016-01-05 17:57mtaalStatusnew => scheduled
2016-01-05 17:58mtaalFile Added: stack-trace.txt
2016-01-05 17:58mtaalReview Assigned To => marvintm
2016-01-05 22:11hgbotCheckin
2016-01-05 22:11hgbotNote Added: 0083145
2016-01-05 22:11hgbotStatusscheduled => resolved
2016-01-05 22:11hgbotResolutionopen => fixed
2016-01-05 22:11hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.mobile.core/rev/727a4f04e3e023624bbdc36cdb682e95304129ad [^]
2016-01-14 16:15hgbotCheckin
2016-01-14 16:15hgbotNote Added: 0083305
2016-01-14 16:15hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/pmods/org.openbravo.mobile.core/rev/727a4f04e3e023624bbdc36cdb682e95304129ad [^] => http://code.openbravo.com/retail/backports/3.0RR16Q1/org.openbravo.mobile.core/rev/886ed432a5b837bbd459ea148b8c195d9873aef2 [^]
2016-01-14 16:18mtaalNote Deleted: 0083305
2016-01-18 16:47mtaalReview Assigned Tomarvintm => migueldejuana
2016-01-19 15:18migueldejuanaNote Added: 0083405
2016-01-19 15:18migueldejuanaStatusresolved => closed
2017-11-16 07:40guillermogilRelationship addedcauses 0037301

Notes
(0083145)
hgbot   
2016-01-05 22:11   
Repository: erp/pmods/org.openbravo.mobile.core
Changeset: 727a4f04e3e023624bbdc36cdb682e95304129ad
Author: Martin Taal <martin.taal <at> openbravo.com>
Date: Tue Jan 05 18:20:56 2016 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.mobile.core/rev/727a4f04e3e023624bbdc36cdb682e95304129ad [^]

Fixes issue 31824: Import entry may not get saved in case of low level database error, webpos sees message as succesfully send
Create correct error json and return status code 500 on error

---
M src/org/openbravo/mobile/core/process/MobileService.java
---
(0083405)
migueldejuana   
2016-01-19 15:18   
Tested and reviewed in RR16Q2