Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0031343Retail ModulesWeb POSpublic2015-11-03 16:532015-11-05 12:29
Reporterguilleaer 
Assigned ToRetail 
PrioritynormalSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionRR15Q3.2Fixed in VersionRR15Q3.2 
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
Summary0031343: Suddenly incremental refresh is not working because lastUpdatedTimestamp becomes "null"
DescriptionSuddenly 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 [^])
Steps To ReproduceCurrently we don't have steps to reproduce the issue
Proposed Solution1st 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"
Additional Information
TagsNo tags attached.
Relationships
blocks defect 0031341 closed guilleaer Suddenly incremental refresh is not working because lastUpdatedTimestamp becomes "null" 
Attached Filesdiff diffIssue31341_posterminal_15q3_2.diff (4,710) 2015-11-03 18:58
https://issues.openbravo.com/file_download.php?file_id=8683&type=bug
diff diffIssue31341_mobilecore_15q3_2.diff (1,118) 2015-11-03 18:58
https://issues.openbravo.com/file_download.php?file_id=8684&type=bug
Issue History
Date ModifiedUsernameFieldChange
2015-11-03 16:54guilleaerTypedefect => backport
2015-11-03 16:54guilleaerTarget Version => RR15Q3.2
2015-11-03 18:58guilleaerFile Added: diffIssue31341_posterminal_15q3_2.diff
2015-11-03 18:58guilleaerFile Added: diffIssue31341_mobilecore_15q3_2.diff
2015-11-04 12:50hgbotCheckin
2015-11-04 12:50hgbotNote Added: 0081468
2015-11-04 12:50hgbotStatusscheduled => resolved
2015-11-04 12:50hgbotResolutionopen => fixed
2015-11-04 12:50hgbotFixed in SCM revision => http://code.openbravo.com/retail/backports/3.0RR15Q3.2/org.openbravo.retail.posterminal/rev/b6d80989b7cddf894769ca86cb1a2cd62ee74ed2 [^]
2015-11-04 12:50hgbotCheckin
2015-11-04 12:50hgbotNote Added: 0081469
2015-11-04 12:50hgbotFixed in SCM revisionhttp://code.openbravo.com/retail/backports/3.0RR15Q3.2/org.openbravo.retail.posterminal/rev/b6d80989b7cddf894769ca86cb1a2cd62ee74ed2 [^] => http://code.openbravo.com/retail/backports/3.0RR15Q3.2/org.openbravo.mobile.core/rev/b0f6183c7ca55b47603322e8b05f9cae5b5be238 [^]
2015-11-04 17:29hgbotCheckin
2015-11-04 17:29hgbotNote Added: 0081485
2015-11-05 12:29marvintmReview Assigned To => marvintm
2015-11-05 12:29marvintmStatusresolved => closed
2015-11-05 12:29marvintmFixed in Version => RR15Q3.2

Notes
(0081468)
hgbot   
2015-11-04 12:50   
Repository: retail/backports/3.0RR15Q3.2/org.openbravo.retail.posterminal
Changeset: b6d80989b7cddf894769ca86cb1a2cd62ee74ed2
Author: Guillermo Alvarez de Eulate <guillermo.alvarez <at> openbravo.com>
Date: Wed Nov 04 12:49:46 2015 +0100
URL: http://code.openbravo.com/retail/backports/3.0RR15Q3.2/org.openbravo.retail.posterminal/rev/b6d80989b7cddf894769ca86cb1a2cd62ee74ed2 [^]

Fixed issue 31343: 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/Discount.java
M src/org/openbravo/retail/posterminal/master/Product.java
M src/org/openbravo/retail/posterminal/master/SalesRepresentative.java
---
(0081469)
hgbot   
2015-11-04 12:50   
Repository: retail/backports/3.0RR15Q3.2/org.openbravo.mobile.core
Changeset: b0f6183c7ca55b47603322e8b05f9cae5b5be238
Author: Guillermo Alvarez de Eulate <guillermo.alvarez <at> openbravo.com>
Date: Wed Nov 04 12:47:14 2015 +0100
URL: http://code.openbravo.com/retail/backports/3.0RR15Q3.2/org.openbravo.mobile.core/rev/b0f6183c7ca55b47603322e8b05f9cae5b5be238 [^]

Fixed issue 31343: Check last update value

---
M src/org/openbravo/mobile/core/process/ProcessHQLQuery.java
---
(0081485)
hgbot   
2015-11-04 17:29   
Repository: retail/backports/3.0RR15Q3.2/org.openbravo.mobile.core
Changeset: 98eb03ffea9ebc7f4531f83e5ec2ae459840baa4
Author: Guillermo Alvarez de Eulate <guillermo.alvarez <at> openbravo.com>
Date: Wed Nov 04 17:28:41 2015 +0100
URL: http://code.openbravo.com/retail/backports/3.0RR15Q3.2/org.openbravo.mobile.core/rev/98eb03ffea9ebc7f4531f83e5ec2ae459840baa4 [^]

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

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