Time Series Insights WarmStore floor function.

Daniel Antkiewicz 1 Reputation point
2022-07-07T06:59:22.487+00:00

Hi,

I'm having an issue, when I send this request, I'm getting Internal Server Error response.

Request:
{
"aggregateSeries":{
"searchSpan":{
"from":"2022-06-30T06:48:00.001Z",
"to":"2022-07-06T13:37:00.001Z"
},
"timeSeriesId":[
"device"
],
"interval":"PT1440M",
"inlineVariables":{
"min":{
"kind":"numeric",
"value":{
"tsx":"floor($event.parameter_name.Long)"
},
"filter":{
"tsx":"$event.parameter_name.Long != null"
},
"aggregation":{
"tsx":"min($value)"
}
}
},
"projectedVariables":[
"min"
]
}
}

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

I send this request to {url}/timeseries/query?api-version=2020-07-31?storeType=WarmStore.
This request works perfectly fine on ColdStore. I have checked it on two of TSI instances that I'm working with. Also It works when I change floor to ceiling or round.

Regards,
Daniel

Azure Time Series Insights
Azure Time Series Insights
An Azure internet of things (IoT) analytics platform to monitor, analyze, and visualize industrial IoT analytics data at scale.
78 questions
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.