Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
community Alteryx IO Mission Control
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

SQL Error running on Server vs Desktop

gerconn
7 - Meteor
‎12-29-2016 03:22 PM

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".

Labels:
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

1 REPLY 1
gerconn
7 - Meteor
‎12-31-2016 04:34 PM

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.

Preview file
217 KB
Reply
0 Likes
connect with mentors
designer new user guide
Labels
Top Solution Authors
View All