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

SwapnaE
SwapnaE Member
in Magic ETL

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

  • Sean_Tully
    Sean_Tully 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.

  • rco
    rco 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

  • Sean_Tully
    Sean_Tully 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.

  • rco
    rco 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>

Categories