Alteryx Server Discussions

Find answers, ask questions, and share expertise about Alteryx Server.
SOLVED

No Columns Returned - ONLY from server

StolenColon
5 - Atom

Hi all,

 

I have a workflow with an input using ODBC connection from server to connect to a SQL database and select* a small table.  It works as expected when running from designer locally, and on the VM where Server is installed.

 

When I attempt to save to the gallery the validation fails stating "No Columns Returned".  Looking at the logs of the validation job I see the connection is made, just no columns returned,

 

After testing further I see that any input tool configured to look at this specific database yields the same results (fine on designer, no columns returned on server).  Anybody have any suggestions??

 

Thanks!

1 REPLY 1
StolenColon
5 - Atom

Turns out it was permissions for my worker - had to get the "real IT" guys involved....haha