Error "Unable to update to DataSet" in MySQL DataFlow

Reply
Visitor

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

BP Connectivity Combined Query   Domo_Summary.pngBased on history, try to re-reun 3 times and always failedIMG_20190404_190056_Edit.jpgError Message on MySQL DataFlow

Major Blue Belt

Re: Error "Unable to update to DataSet" in MySQL DataFlow

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


-----------------
Chris
Major Red Belt

Re: Error "Unable to update to DataSet" in MySQL DataFlow

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'
Visitor

Re: Error "Unable to update to DataSet" in MySQL DataFlow

Hi,

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

Thanks

Visitor

Re: Error "Unable to update to DataSet" in MySQL DataFlow

Hi,

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

Thanks guys for sharing ... 

^^

Announcements
Looking for the latest Community solutions? Please visit our accepted solutions board here!