This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Other than simple query with the input tool , most others failing with the following message
I thought I will just remove the so called input tool 30 ( reading from MY SQL with DSN connection sitting in my desktop as well server) to a separate workflow by itself . It went thru fine . no issues . I tried to delete this tool and copy paste other working tool and just substitute the SQL , still no luck
Its been more than a week . Support team did not return my call/email. meanwhile , my research suggested that SQL driver version could be the issue . version out of sync in server compared to my latest version desktop . After making sure both versions are same and re doing those connections ion workflows...seems to be stable now . not out of the woods yet
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