I got a reply from Alteryx Support as well that I must revert to 8.0.19 from 8.0.24 . But few things are not clear . What is this - ODBC Client Version: 1.00.19.1021 ?
I thought I need same ODBC MY SQL driver version 8.0.19 and that's what I have and it' s working fine for all desktop connection
And meanwhile my workflows are failing randomly instead of failing consistently . Will go thru one day fine and next day it will fail and most of the time data output is complete but still the bizarre error comes
Does it mean I have to re do my connections and publish workflows again ? ( some of them i did anyway. but no luck still )
and what is this ODBC version that shows up in log of a workflow after its done running ?
Message Type Process or Tool Id Details
Information -1 Running at a Low Priority.
Information 1 ODBC Driver version: 03.80