Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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