Cat Tracker Fetch Fail

[DevNetNow]

Hi 

I'm working with version v8.6.90 since the master version at this date have an Auth amplify issue. 

The Fetch function on the map is buggy :  

Here is the Chrome dev console output every time i change the fetch number : 

App.tsx:159 [Timestream] {timestreamQuery: "SELECT↵ array_agg(measure_value::double) AS …P BY measureGroup, time↵ ORDER BY time DESC", error: ValidationException: line 4:18: Column 'source' does not exist
at https://my.cloudf …}error: ValidationException: line 4:18: Column 'source' does not exist
at https://my.cloudf ront.net/static/js/5.5f3e6fc2.chunk.js:2:493867
at https://my.cloudf ront.net/static/js/0.df04d68b.chunk.js:2:2833
at Object.next (https://my.cloudf ront.net/static/js/0.df04d68b.chunk.js:2:2938)
at r (https://my.cloudf ront.net/static/js/0.df04d68b.chunk.js:2:1676)$fault: "client"$metadata: {httpStatusCode: 400, requestId: "KCGYVRAMST5FQFVTWIADCWG7WQ", extendedRequestId: undefined, cfId: undefined, attempts: 1, …}name: "ValidationException"message: "line 4:18: Column 'source' does not exist"stack: "ValidationException: line 4:18: Column 'source' does not exist\n at https://my.cloudf ront.net/static/js/5.5f3e6fc2.chunk.js:2:493867\n at https://my.cloudf ront.net/static/js/0.df04d68b.chunk.js:2:2833\n at Object.next (https://my.cloudf ront.net/static/js/0.df04d68b.chunk.js:2:2938)\n at r (https://my.cloudf ront.net/static/js/0.df04d68b.chunk.js:2:1676)"__proto__: Objectconstructor: ƒ Error()message: ""name: "Error"toString: ƒ toString()__proto__: ObjecttimestreamQuery: "SELECT\n\t\t\t\t\t\t\tarray_agg(measure_value::double) AS objectValues,\n\t\t\t\t\t\t\tarray_agg(measure_name) AS objectKeys,\n\t\t\t\t\t\t\tarray_agg(source) AS objectSource,\n\t\t\t\t\t\t\ttime AS date\n\t\t\t\t\t\t\tFROM \"historicalDatadb40B23029-9EZu10DiXCG3\".\"historicalDatatableD9D795E1-Pdz72bsHpC5q\"\n\t\t\t\t\t\t\tWHERE deviceId='352656101085507' \n\t\t\t\t\t\t\tAND measureGroup IN (\n\t\t\t\t\t\t\t\tSELECT\n\t\t\t\t\t\t\t\tmeasureGroup\n\t\t\t\t\t\t\t\tFROM \"historicalDatadb40B23029-9EZu10DiXCG3\".\"historicalDatatableD9D795E1-Pdz72bsHpC5q\"\n\t\t\t\t\t\t\t\tWHERE deviceId='352656101085507' \n\t\t\t\t\t\t\t\tAND substr(measure_name, 1, 4) = 'gps.'\n\t\t\t\t\t\t\t\tGROUP BY measureGroup, time\n\t\t\t\t\t\t\t\tORDER BY time DESC\n\t\t\t\t\t\t\t\tLIMIT 14\n\t\t\t\t\t\t\t)\n\t\t\t\t\t\t\tAND substr(measure_name, 1, 4) = 'gps.'\n\t\t\t\t\t\t\tGROUP BY measureGroup, time\n\t\t\t\t\t\t\tORDER BY time DESC"__proto__: Objectconstructor: ƒ Object()hasOwnProperty: ƒ hasOwnProperty()isPrototypeOf: ƒ isPrototypeOf()propertyIsEnumerable: ƒ propertyIsEnumerable()toLocaleString: ƒ toLocaleString()toString: ƒ toString()valueOf: ƒ valueOf()__defineGetter__: ƒ __defineGetter__()__defineSetter__: ƒ __defineSetter__()__lookupGetter__: ƒ __lookupGetter__()__lookupSetter__: ƒ __lookupSetter__()get __proto__: ƒ __proto__()set __proto__: ƒ __proto__()
(anonymous) @ App.tsx:159
Promise.catch (async)
query @ App.tsx:141
fetchHistory @ CatMap.tsx:70
(anonymous) @ HistoricalDataMap.tsx:32
setTimeout (async)
(anonymous) @ HistoricalDataMap.tsx:30
Ii @ react-dom.production.min.js:262
t.unstable_runWithPriority @ scheduler.production.min.js:18
$l @ react-dom.production.min.js:122
Oi @ react-dom.production.min.js:261
(anonymous) @ react-dom.production.min.js:261
D @ scheduler.production.min.js:16
k.port1.onmessage @ scheduler.production.min.js:12
23:24:16.613 ValidationException: line 4:18: Column 'source' does not exist
at https://my.cloudf ront.net/static/js/5.5f3e6fc2.chunk.js:2:493867
at https://my.cloudf ront.net/static/js/0.df04d68b.chunk.js:2:2833
at Object.next (https://my.cloudf ront.net/static/js/0.df04d68b.chunk.js:2:2938)
at r (https://my.cloudf ront.net/static/js/0.df04d68b.chunk.js:2:1676)

Thanks for Feedback 

[DevNetNow]

i have only the last position on the map 

[DevNetNow]

Hi

i took versions used in Markus video, i suppose from dates in the video 12/03  

asset-tracker-cloud-aws-js v25.0.2 

asset-tracker-cloud-app-js v8.6.24

Now, timestream queries are OK. and Auth Ok. but passive mode is buggy. i never succeded to set passive mode. 

On setting passive mode, device stops all data sending, there is no movement detection. the activity chart is always empty. i tried hard shake. car journey, ...nothing activate the passive data sending on movement (accelerometer treshold detection) 

may be it's firmware bug or default config parameters ?? 

 

[Didrik Rokhaug]

Hi,

I am happy to hear you found the solution.

Using the correct versions are important.

I see you have made a new ticket for the passive mode problem. Does that mean we can close this ticket?

Best regards,

Didrik

[DevNetNow]

Hi 

Yes the passive mode issue is pure hardware.

full description in the other ticket 

yes we can close this 

Regards 

[Markus Tacker (he/him)]

Thanks for reporting this.

This error is expected if no historical data exists yet in the database for any device, because then the column does not exist in Timestream.

I've added a note to the error message so it's more clear: github.com/.../2b76f1ecbd8898519af5959972aae79a1587e3ce