Error "Unable to update to DataSet" in MySQL DataFlow

user17608

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 failedError Message on MySQL DataFlow

cwolman

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 

 

 

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

user17608

Hi,

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

Thanks

user17608

Hi,

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

Thanks guys for sharing ... 

^^