Magic ETL flow failed while executing with "Failed to index Dataset " error

SwapnaE · 2024-04-16T18:03:37+00:00

There was an error rendering this rich post.

SwapnaE

Hi,

I am facing below error while executing magic ETL flow in Domo.

Failed while executing "Failed to index DataSet '3a922bde-7139-42c1-96c3-88d7516a1fa7' "

All tiles were executed successfully, but output dataset is not created.

I used "upsert" as update method for creating output Dataset.

Could you please suggest to resolve this error.

Thank you.

Find more posts tagged with

Accepted answers

Sean_Tully

I haven't used Magic ETL upserts yet, but from other experience this sounds like your upsert key isn't unique to each row. Hopefully someone else who has used this feature can give you a more certain answer.

rco

@SwapnaE It looks like your upsert key was empty in one of the rows your DataFlow produced. If you replace empty strings in it with some other value, does the issue go away?

All comments

Sean_Tully

rco

@SwapnaE It looks like your upsert key was empty in one of the rows your DataFlow produced. If you replace empty strings in it with some other value, does the issue go away?

Winnie_1234

i am facing the same issue