0031826: Import entry may not get saved in case of low level database error, webpos sees message as succesfully send

Description

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.

Steps To Reproduce

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.

Proposed Solution

on the server create the correct error json and set a failure status code so that the webpos client correctly signals an error.

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

blocks

defect

0031824

RR16Q2

closed

mtaal

Import entry may not get saved in case of low level database error, webpos sees message as succesfully send

Notes
(0083302) hgbot (developer) 2016-01-14 15:32	Repository: retail/backports/3.0RR15Q4.2/org.openbravo.mobile.core Changeset: ebf29401c3eefc66e85e0fe4e3034c0d5408b0df Author: Martin Taal <martin.taal <at> openbravo.com> Date: Thu Jan 14 15:31:47 2016 +0100 URL: http://code.openbravo.com/retail/backports/3.0RR15Q4.2/org.openbravo.mobile.core/rev/ebf29401c3eefc66e85e0fe4e3034c0d5408b0df [^] Fixes issue 31826: 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 ---

(0083403) migueldejuana (developer) 2016-01-19 14:58	Tested and reviewed in RR15Q4.2

Issue History
Date Modified	Username	Field	Change
2016-01-05 17:57	mtaal	Type	defect => backport
2016-01-05 17:57	mtaal	Target Version	RR16Q2 => RR15Q4.3
2016-01-14 10:43	mtaal	Target Version	RR15Q4.3 => RR15Q4.2
2016-01-14 15:32	hgbot	Checkin
2016-01-14 15:32	hgbot	Note Added: 0083302
2016-01-14 15:32	hgbot	Status	scheduled => resolved
2016-01-14 15:32	hgbot	Resolution	open => fixed
2016-01-14 15:32	hgbot	Fixed in SCM revision	=> http://code.openbravo.com/retail/backports/3.0RR15Q4.2/org.openbravo.mobile.core/rev/ebf29401c3eefc66e85e0fe4e3034c0d5408b0df [^]
2016-01-18 16:45	mtaal	Review Assigned To	=> migueldejuana
2016-01-19 14:58	migueldejuana	Note Added: 0083403
2016-01-19 14:58	migueldejuana	Status	resolved => closed