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.
Hello, I have created several workflows over the past few months that used regular input data tools going through an ODBC connection to our Datawarehouse. They have worked perfectly for months when I run them or through our scheduler. Today, when I try to run any of the previously created workflows, I receive an error that no columns were returned. I can create a new workflow utilizing the same type of connection and it works as expected.
I have attempted to reboot and reinstall Alteryx but neither have solved the issue. We have multiple licensed users and I appear to be the only one with this issue. I can view the tables in SQL or Access, so I don't believe this is a permissions issue. Any suggestions on what to try next?
I am definitely confused as well. Yes, the previously created workflows seem to run successfully using our scheduler, but not from my desktop. I can create new workflows that look at the same sources and they run with no problem.
same thing happened to me but for a different reason. I was pulling through data from a SQL database in an input node and i forgot to reference one of my left joins with the database name i.e. i put dbo.Table rather than Database.dbo.Table and it was 'returning no columns' on Alteryx even though the node return columns and the sql query returned columns. small issue but could occur again.