Skip to main content
GAmaro
Gold ⭐️
February 21, 2020
Solved

Error storing data "Row key not found"

Hello,

After 13th January, all my store streamsets stopped storing data with an error similar like this below.

We are collecting data from ETW and IIS log data, that is first collect, then transform, and finally store. This last step is falling.

Can someone help?

 

KUDU_15 - Row key '(string id="3d755d2d-949e-4fba-9925-63f658b44773", int32 year=2020, int32 month=2, int32 day=21, string host="vipe-exch03", string type="etw", string environment="prod", string groupid="iis")' not found

-----------------------------------

GAmaro
GAmaroAnswer
Gold ⭐️
March 2, 2020

Just found what the problem was. The table was divided in partitions by months and some tables reached the already monthly pré-created partitions. The resolution passed by creating new partitions and the data started to by stored again.

3 replies

metadaddy
Silver ⭐️⭐️
February 24, 2020

Are you a StreamSets customer? If so, you should open a support ticket.

Translate
metadaddy
Silver ⭐️⭐️
February 24, 2020

Looking at the error, it seems like you're trying to process an insert as an update. Check the logic of your pipeline. If it was working before, something must have changed.

Translate
GAmaro
GAmaroAuthorAnswer
Gold ⭐️
March 2, 2020

Just found what the problem was. The table was divided in partitions by months and some tables reached the already monthly pré-created partitions. The resolution passed by creating new partitions and the data started to by stored again.

Translate