Error "Unable to update to DataSet" in MySQL DataFlow


Hi All ,


I have problem while executing MySQL Dataflow that always failed, the message error is only "Unable to update to DataSet". Can anyone please help or share, whether you have the same issue ? 


Thank you



Here is the capture

Based on history, try to re-reun 3 times and always failedBased on history, try to re-reun 3 times and always failedError Message on MySQL DataFlowError Message on MySQL DataFlow


  • cwolman
    cwolman Contributor

    It is hard to see but it appears that all of your transforms are outputting 0 rows.  Do you expect 0 rows?

  • Godiepi

    This might be very silly but did you select "Table" when adding transformations in MySQL ?


    if you selected 'SQL' , it does not generate rows 


    Screen Shot 04-04-19 at 02.08 PM.PNG


    Your transformations should  have an icon that looks like a table for the SQL to generate rows that you can then create an output dataset from

    , if they instead show with an icon with the "SQL" word , then you might have chosen the wrong type of transformation

    Screen Shot 04-04-19 at 02.12 PM.PNG

    Domo Arigato!

    **Say 'Thanks' by clicking the thumbs up in the post that helped you.
    **Please mark the post that solves your problem as 'Accepted Solution'
  • user17608


    In the transform there are only contains alter table to add index. 


  • user17608


    I just re-run again my DataFlow without any changes, but now suddenly working well ... Lol.

    Thanks guys for sharing ...