Magic ETL

Magic ETL

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

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.

Best Answers

  • Contributor
    Answer ✓

    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.

  • Domo Employee
    Answer ✓

    @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?

    Randall Oveson <randall.oveson@domo.com>

Answers

  • Contributor
    Answer ✓

    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.

  • Domo Employee
    Answer ✓

    @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?

    Randall Oveson <randall.oveson@domo.com>

Welcome!

It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
Sign In