You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
We're facing issue with data fething using REST API and as well as from dashboard. We are trying to get history data for device using different interval like 1 day, 7 day and 30 days. It's taking 10 or more seconds, even sometimes it takes 30 seconds or more and also failed to load many times.
I'm using thingsboard professional edition and our current thingsboard version is v.3.3.0
sample url: https://[domain name here]/api/plugins/telemetry/DEVICE/a05e8220-19b4-11ee-8f45-97d7eca13f17/values/timeseries?keys=1_unit,2_Unit,3_Unit&startTs=1714500000000&endTs=1715831823357&interval=86400000&orderBy=DESC&intervalType=MILLISECONDS&agg=MAX
We need all data in request and having issue to get the data using REST API. I would greatly appreciate any updates.
The text was updated successfully, but these errors were encountered:
Hi. As far as I know, I already answered you to this question on customer portal. I am duplicating the answer here without the sensitive information so that the community can refer to this ticket in case of similar problem
"You have at least 50k datapoints for each 1/2/3_unit key, as shown on widgets. Considering that 50k is the maximum allowable value for display, we can see that this is only in 3 days. That is, the final value can be dramatically larger.
Given that you are using an aggregation function, this may take some time to calculate. And even this does not guarantee that the database will handle this request.
It can be related to a lack of system resources or database design capabilities. In this case, I recommend recreating your aggregation logic; you can consider aggregating the data in the rule chain." https://thingsboard.io/docs/paas/user-guide/rule-engine-2-0/analytics-nodes/ https://thingsboard.io/docs/user-guide/rule-engine-2-0/tutorials/aggregate-incoming-data-stream/
We're facing issue with data fething using REST API and as well as from dashboard. We are trying to get history data for device using different interval like 1 day, 7 day and 30 days. It's taking 10 or more seconds, even sometimes it takes 30 seconds or more and also failed to load many times.
I'm using thingsboard professional edition and our current thingsboard version is v.3.3.0
sample url: https://[domain name here]/api/plugins/telemetry/DEVICE/a05e8220-19b4-11ee-8f45-97d7eca13f17/values/timeseries?keys=1_unit,2_Unit,3_Unit&startTs=1714500000000&endTs=1715831823357&interval=86400000&orderBy=DESC&intervalType=MILLISECONDS&agg=MAX
We need all data in request and having issue to get the data using REST API. I would greatly appreciate any updates.
The text was updated successfully, but these errors were encountered: