SQL Error running on Server vs Desktop

[gerconn]

Is there any way to get more detailed error messages when a SQL query fails rather than just "No Columns Returned"?

I have a query that runs fine on my desktop instance but fails when run on the server using an ODBC connection to a DB2 database. 

The query joins two tables and returns about 40 columns. If I reduce the columns to 10-15, the query is succcesful on the server but when I add columns back in, it fails again. 

I've looked at the log files but its the same error message is "Error opening - No Columns Returned".

[gerconn · Accepted solution]

Just an update, modifying the Memory Limit per Anchor (KB) setting from 1024 to 2048 in the Alteryx Server settings seems to have resolved the issue.