question

BERNARDThomas-8090 avatar image
0 Votes"
BERNARDThomas-8090 asked ·

Missing record in table storage (from stream analytics)

Hi everybody,

I have a problem of missing records in a table storage account.

I use a stream analytics job to send data from an IOTHub to a table storage. The stream analytics job seems working correctly (output event count seems correct).

I expect to see around 100 records every 10 minutes in the table, but I only see 1 record coming into the table. All other records seems to be lost. That's why I suppose my problem comes from the table storage write capability.

Is there any parameter in the table storage account which should be modified to accept all my write requests ? Or anything else that I misunderstood ?

Thanks in advance for your help !

Thomas

azure-iot-hubazure-stream-analyticsazure-table-storage
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

BERNARDThomas-8090 avatar image
0 Votes"
BERNARDThomas-8090 answered ·

Finally I found the problem. The ROWKEY value in the table should be unique (with the PARTITIONKEY).

I cannot use EvendId value from the IOTHub as ROWKEY because this value is the same for all stream analytics output coming from the same input.

I have created my own value with concatenation of DATETIME and IDENT as ROWKEY and DEVICE as PARTITIONKEY, and now everything is OK.

Hope it can help other people facing problems.

Regards,

Thomas

·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.