Azure-Samples / Azure-Time-Series-Insights

Sample modules written in different languages that can be used as templates for applications needing to query Time Series Insights
MIT License
21 stars 31 forks source link

Azure TSI call returns Internal server error when requesting floor value. #43

Open DanielAnt opened 2 years ago

DanielAnt commented 2 years ago

Please provide us with the following information:

This issue is for a: (mark with an x)

- [x] bug report -> please search issues before submitting
- [ ] feature request
- [ ] documentation issue or request
- [ ] regression (a behavior that used to work and stopped in a new release)

Minimal steps to reproduce

When calling WarmStore through TSI API {{url}}/timeseries/query?api-version=2020-07-31 { "aggregateSeries":{ "searchSpan":{ "from":"2022-07-06T06:48:00.001Z", "to":"2022-07-06T13:37:00.001Z" }, "timeSeriesId":[ "device" ], "interval":"PT1M", "inlineVariables":{ "min":{ "kind":"numeric", "value":{ "tsx":"floor($event.value.Long)" }, "filter":{ "tsx":"$event.value.Long != null" }, "aggregation":{ "tsx":"min($value)" } } }, "projectedVariables":[ "min" ] } }

Any log messages given by the failure

{ "error": { "code": "InternalServerError", "message": "Internal server error. Please retry your request later." } }

Expected/desired behavior

Returns floored data

OS and Version?

2020-07-31

Versions

Gen2 (L1)

Mention any other details that might be useful

Floor function doesn't work for any of aggregation methods. The same request works with ceiling and round.


Thanks! We'll be in touch soon.