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

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.

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?

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?