TSI Data not always

Pascal Tellier 46

HI EveryOne,

I'm using TSI for explorerons timeseries data sent by a backend app connected to event hub.

The data are received in TSI but sometimes I have a field named op when I use the explorer event Gui. This field contains most of the data in a json format. They should be well formatted in different columns.

I don't know if my data are correct or if it's a Gui problem

Any ideas ?

Thanks

AshokPeddakotla-MSFT 27,126 Reputation points

2021-12-01T07:01:31.443+00:00

@Pascal Tellier Could you please share more details regarding the issue which you are facing? Share screenshots if possible for better understanding.
Pascal Tellier 46 Reputation points

2021-12-01T08:43:26.447+00:00

Hi

Of course

In the tsi-screen-shot.png a field named "op" contains data that should be split in different colonns like in screen-shot-ok.png file
I don't understand why sometimes the op field appears and sometimes all the data are well formatted. I'm wondering if the data are well stored or if it's a gui issue.

Best regards
AshokPeddakotla-MSFT 27,126 Reputation points

2021-12-07T13:32:58.253+00:00

@Pascal Tellier Thanks for sharing the additional details. We are looking into this issue and update you as earliest.
Appreciate your time and patience.
AshokPeddakotla-MSFT 27,126 Reputation points

2021-12-09T14:45:13.023+00:00

@Pascal Tellier Wanted to follow up with you to understand whether the below information helped. Please let us know if there are any other queries. If the below doesn't help, as requested please share your TSI ID to debug further.

If below suggestions answers your query, do click Accept Answer and Up-Vote for the same. And, if you have any further query do let us know.

1 answer

Fernando Henrique Inocêncio Borba Ferreira 6 Reputation points Microsoft Employee

2021-12-07T16:52:18.613+00:00

Hello, @Pascal Tellier .

The "op" is used when the TSI environment reaches its respective limit of columns.
In order to avoid losing data, TSI persists all additional data aggregated under the "op" column in JSON format.

For your knowledge:
S1 environments support up to 600 columns.
S2 environments support up to 800 columns.
Warm store (in PayG SKU) supports up to 1000 columns.

Please, provide the TSI Environment ID being used, and we can double check the current status for you.

Thanks.
Fernando
Please sign in to rate this answer.

1 person found this answer helpful.
Fernando Henrique Inocêncio Borba Ferreira 6 Reputation points Microsoft Employee

2021-12-09T17:14:51.667+00:00

For more information about the limit of columns, here it's the official documentation:

S1 and S2 environments: https://learn.microsoft.com/en-us/azure/time-series-insights/time-series-insights-how-to-scale-your-environment#property-limits

S1 and S2 (Gen 1) + PayG (Gen 2): https://learn.microsoft.com/en-us/azure/time-series-insights/how-to-plan-your-environment#property-limits

Pascal Tellier 46 Reputation points

2021-12-14T15:17:51.423+00:00

Hi Fernando

would it be possible to share the TSI Id on a private channel ? not sure that my customer wants to share it on public chat

Thanks

Fernando Henrique Inocêncio Borba Ferreira 6 Reputation points Microsoft Employee

2021-12-14T17:47:23.95+00:00

Hi, @Pascal Tellier !

For sure, please, open a support request providing the environment ID and any additional information.

We'll work in your case.

Thanks!
FH
Sign in to comment