Streaming result set error when trying to run a data flow

user03144

I have a data flow, which has been working but which I have modified. But I can preview every part of it and get valid SQL returned, and yet when I actually run it I get this. Any ideas?

 

"The database reported a syntax error. Streaming result set com.mysql.jdbc.RowDataDynamic@232401f9 is still active. No statements may be issued when any streaming result sets are open and in use on a given connection. Ensure that you have called .close() on any active streaming result sets bef"

user03144

I escalated this to Domo support - turns out they were sending entirely the wrong error message, and actually it was a normal SQL error due to the format of the data, but their error messagewas wrong

AS

Does this happen every time? 

On the dataflow history tab, each run should have a record log for failure or success.  Have you checked the run to see at what point it failed?  When you click on the failure badge it should also show you on the next screen which transform failed.

It it always failing in the same transform?

user03144

I escalated this to Domo support - turns out they were sending entirely the wrong error message, and actually it was a normal SQL error due to the format of the data, but their error messagewas wrong