Openbravo Issue Tracking System - Retail Modules
View Issue Details
0031342Retail ModulesWeb POSpublic2015-11-03 16:532015-11-05 12:29
guilleaer 
Retail 
normalmajorhave not tried
closedfixed 
5
 
RR15Q4RR15Q3.2 
marvintm
No
0031342: Suddenly incremental refresh is not working because lastUpdatedTimestamp becomes "null"
Suddenly incremental refresh is not working because lastUpdatedTimestamp becomes "null"

When this situation happens, server side components (models) raise an exception like that:

Error when generating query: null (JSONObject["lastUpdated"] is not a number.)
org.codehaus.jettison.json.JSONException: JSONObject["lastUpdated"] is not a number.

Because we are trying to process the word "null" as a number.

In the client side we are also generating 2 log messages per each failed request:

serviceSuccess error: status: -1, error.message: JSONObject["lastUpdated"] is not a number.; stackTrace: serviceSuccess (http://79.125.89.90/openbravo/web/js/gen/79cdf4b98f1dc68c16f37bb80ef63806_WebPOS.js:41:4 [^]);Object.enyo.Ajax.success (http://79.125.89.90/openbravo/web/js/gen/79cdf4b98f1dc68c16f37bb80ef63806_WebPOS.js:55:489 [^]);Object.enyo.call (http://79.125.89.90/openbravo/web/org.openbravo.mobile.core/build/enyo.js:335:28 [^]);Object.enyo.kind.handle (http://79.125.89.90/openbravo/web/org.openbravo.mobile.core/build/enyo.js:889:14 [^]);Object.enyo.kind.respond (http://79.125.89.90/openbravo/web/org.openbravo.mobile.core/build/enyo.js:903:41 [^]);Object.enyo.kind.receive (http://79.125.89.90/openbravo/web/org.openbravo.mobile.core/build/enyo.js:1034:97 [^]);XMLHttpRequest.e.onreadystatechange (http://79.125.89.90/openbravo/web/org.openbravo.mobile.core/build/enyo.js:962:24 [^])

Error in datasource: [object Object]; stackTrace: http://79.125.89.90/openbravo/web/js/gen/79cdf4b98f1dc68c16f37bb80ef63806_WebPOS.js:75:23;serviceSuccess [^] (http://79.125.89.90/openbravo/web/js/gen/79cdf4b98f1dc68c16f37bb80ef63806_WebPOS.js:45:103 [^]);Object.enyo.Ajax.success (http://79.125.89.90/openbravo/web/js/gen/79cdf4b98f1dc68c16f37bb80ef63806_WebPOS.js:55:489 [^]);Object.enyo.call (http://79.125.89.90/openbravo/web/org.openbravo.mobile.core/build/enyo.js:335:28 [^]);Object.enyo.kind.handle (http://79.125.89.90/openbravo/web/org.openbravo.mobile.core/build/enyo.js:889:14 [^]);Object.enyo.kind.respond (http://79.125.89.90/openbravo/web/org.openbravo.mobile.core/build/enyo.js:903:41 [^]);Object.enyo.kind.receive (http://79.125.89.90/openbravo/web/org.openbravo.mobile.core/build/enyo.js:1034:97 [^])
Currently we don't have steps to reproduce the issue
1st step

Servlets should check at the begining of the process that the value received for "lastUpdated" is valid. It will stop the creation of exceptions but will provoque a full refresh when it happens

2nd step

Try to understand why at some point the value of lastUpdatedTimestamp becomes "null"
No tags attached.
blocks defect 0031341 closed guilleaer Suddenly incremental refresh is not working because lastUpdatedTimestamp becomes "null" 
Issue History
2015-11-03 16:54guilleaerTypedefect => backport
2015-11-03 16:54guilleaerTarget Version => RR15Q4
2015-11-04 13:59hgbotCheckin
2015-11-04 13:59hgbotNote Added: 0081477
2015-11-04 13:59hgbotStatusscheduled => resolved
2015-11-04 13:59hgbotResolutionopen => fixed
2015-11-04 13:59hgbotFixed in SCM revision => http://code.openbravo.com/retail/backports/3.0RR15Q4/org.openbravo.retail.posterminal/rev/36ea80b2696a8484b802a63e1d3b4ee71be571b4 [^]
2015-11-04 13:59hgbotCheckin
2015-11-04 13:59hgbotNote Added: 0081478
2015-11-04 13:59hgbotFixed in SCM revisionhttp://code.openbravo.com/retail/backports/3.0RR15Q4/org.openbravo.retail.posterminal/rev/36ea80b2696a8484b802a63e1d3b4ee71be571b4 [^] => http://code.openbravo.com/retail/backports/3.0RR15Q4/org.openbravo.mobile.core/rev/7396daf82a82a8cf17d62b6f84834ff14d6c7697 [^]
2015-11-05 12:18hgbotCheckin
2015-11-05 12:18hgbotNote Added: 0081515
2015-11-05 12:29marvintmReview Assigned To => marvintm
2015-11-05 12:29marvintmStatusresolved => closed
2015-11-05 12:29marvintmFixed in Version => RR15Q3.2

Notes
(0081477)
hgbot   
2015-11-04 13:59   
Repository: retail/backports/3.0RR15Q4/org.openbravo.retail.posterminal
Changeset: 36ea80b2696a8484b802a63e1d3b4ee71be571b4
Author: Guillermo Alvarez de Eulate <guillermo.alvarez <at> openbravo.com>
Date: Wed Nov 04 13:23:49 2015 +0100
URL: http://code.openbravo.com/retail/backports/3.0RR15Q4/org.openbravo.retail.posterminal/rev/36ea80b2696a8484b802a63e1d3b4ee71be571b4 [^]

Fixed issue 31342: Check last update value in some Web POS data providers

---
M src/org/openbravo/retail/posterminal/master/BPLocation.java
M src/org/openbravo/retail/posterminal/master/BusinessPartner.java
M src/org/openbravo/retail/posterminal/master/Product.java
M src/org/openbravo/retail/posterminal/master/SalesRepresentative.java
---
(0081478)
hgbot   
2015-11-04 13:59   
Repository: retail/backports/3.0RR15Q4/org.openbravo.mobile.core
Changeset: 7396daf82a82a8cf17d62b6f84834ff14d6c7697
Author: Guillermo Alvarez de Eulate <guillermo.alvarez <at> openbravo.com>
Date: Wed Nov 04 13:23:39 2015 +0100
URL: http://code.openbravo.com/retail/backports/3.0RR15Q4/org.openbravo.mobile.core/rev/7396daf82a82a8cf17d62b6f84834ff14d6c7697 [^]

Fixed issue 31342: Check last update value

---
M src/org/openbravo/mobile/core/process/ProcessHQLQuery.java
---
(0081515)
hgbot   
2015-11-05 12:18   
Repository: retail/backports/3.0RR15Q4/org.openbravo.mobile.core
Changeset: 8c37bfc938674a2c2391ae8a6ffa2a5818311c03
Author: Guillermo Alvarez de Eulate <guillermo.alvarez <at> openbravo.com>
Date: Thu Nov 05 12:18:24 2015 +0100
URL: http://code.openbravo.com/retail/backports/3.0RR15Q4/org.openbravo.mobile.core/rev/8c37bfc938674a2c2391ae8a6ffa2a5818311c03 [^]

Related to issue 31342: LastUpdated will never be null. Log added to detect this situation

---
M web/org.openbravo.mobile.core/source/data/ob-datasource.js
---