Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0031341Retail ModulesWeb POSpublic2015-11-03 16:532015-12-04 16:04
Reporterguilleaer 
Assigned Toguilleaer 
PrioritynormalSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in VersionRR16Q1 
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
Summary0031341: 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
depends on backport 0031342RR15Q4 closed Retail Suddenly incremental refresh is not working because lastUpdatedTimestamp becomes "null" 
depends on backport 0031343RR15Q3.2 closed Retail Suddenly incremental refresh is not working because lastUpdatedTimestamp becomes "null" 
related to defect 0031635RR16Q1 closed guilleaer Under certain circumstances web POS fails because Inc refresh and full refresh are executed at the same time 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2015-11-03 16:53guilleaerNew Issue
2015-11-03 16:53guilleaerAssigned To => Retail
2015-11-03 16:53guilleaerTriggers an Emergency Pack => No
2015-11-03 16:54guilleaerStatusnew => scheduled
2015-11-04 09:03hgbotCheckin
2015-11-04 09:03hgbotNote Added: 0081461
2015-11-04 09:03hgbotStatusscheduled => resolved
2015-11-04 09:03hgbotResolutionopen => fixed
2015-11-04 09:03hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/d9ee10401fc746a11bd7c7938fe784298fb06fa1 [^]
2015-11-04 14:01hgbotCheckin
2015-11-04 14:01hgbotNote Added: 0081479
2015-11-06 10:03hgbotCheckin
2015-11-06 10:03hgbotNote Added: 0081544
2015-11-16 13:36marvintmAssigned ToRetail => guilleaer
2015-11-18 15:50guilleaerReview Assigned To => marvintm
2015-12-01 21:21hgbotCheckin
2015-12-01 21:21hgbotNote Added: 0082503
2015-12-01 21:29guilleaerRelationship addedrelated to 0031635
2015-12-04 16:04marvintmStatusresolved => closed
2015-12-04 16:04marvintmFixed in Version => RR16Q1

Notes
(0081461)
hgbot   
2015-11-04 09:03   
Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: d9ee10401fc746a11bd7c7938fe784298fb06fa1
Author: Guillermo Alvarez de Eulate <guillermo.alvarez <at> openbravo.com>
Date: Tue Nov 03 22:06:05 2015 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/d9ee10401fc746a11bd7c7938fe784298fb06fa1 [^]

fixed issue 31341: ensure that lastupdate info is ok

---
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
---
(0081479)
hgbot   
2015-11-04 14:01   
Repository: erp/pmods/org.openbravo.mobile.core
Changeset: 7c32da6c1e998da6d96d73e1273308b73e9ca642
Author: Guillermo Alvarez de Eulate <guillermo.alvarez <at> openbravo.com>
Date: Wed Nov 04 14:00:59 2015 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.mobile.core/rev/7c32da6c1e998da6d96d73e1273308b73e9ca642 [^]

Related to issue 31341: Ensure datalimit value doesn't breaks the incremental refresh using try/catch

---
M src/org/openbravo/mobile/core/process/ProcessHQLQuery.java
---
(0081544)
hgbot   
2015-11-06 10:03   
Repository: erp/pmods/org.openbravo.mobile.core
Changeset: e8d8398cf05a918275f52cbd407cb60df8701b30
Author: Guillermo Alvarez de Eulate <guillermo.alvarez <at> openbravo.com>
Date: Thu Nov 05 12:23:02 2015 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.mobile.core/rev/e8d8398cf05a918275f52cbd407cb60df8701b30 [^]

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

---
M web/org.openbravo.mobile.core/source/data/ob-datasource.js
---
(0082503)
hgbot   
2015-12-01 21:21   
Repository: erp/pmods/org.openbravo.mobile.core
Changeset: 0255789d4dd40aa4859bf590d11c816c4926e4b9
Author: Guillermo Alvarez de Eulate <guillermo.alvarez <at> openbravo.com>
Date: Tue Dec 01 21:20:24 2015 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.mobile.core/rev/0255789d4dd40aa4859bf590d11c816c4926e4b9 [^]

Related to issue 31341: Fix the way to access to the modelname

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