Cat Tracker Fetch Fail

Question

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
 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)"__proto__: Objectconstructor: ƒ Error()message: ""name: "Error"toString: ƒ toString()__proto__: ObjecttimestreamQuery: "SELECT
							array_agg(measure_value::double) AS objectValues,
							array_agg(measure_name) AS objectKeys,
							array_agg(source) AS objectSource,
							time AS date
							FROM \"historicalDatadb40B23029-9EZu10DiXCG3\".\"historicalDatatableD9D795E1-Pdz72bsHpC5q\"
							WHERE deviceId='352656101085507' 
							AND measureGroup IN (
								SELECT
								measureGroup
								FROM \"historicalDatadb40B23029-9EZu10DiXCG3\".\"historicalDatatableD9D795E1-Pdz72bsHpC5q\"
								WHERE deviceId='352656101085507' 
								AND substr(measure_name, 1, 4) = 'gps.'
								GROUP BY measureGroup, time
								ORDER BY time DESC
								LIMIT 14
							)
							AND substr(measure_name, 1, 4) = 'gps.'
							GROUP BY measureGroup, time
							ORDER 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

Markus Tacker (he/him) · Accepted Answer

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

Cat Tracker Fetch Fail

Top Replies