In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. Learn more here
community Alteryx IO MyAlteryx
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
Start 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
Fall Release Webinar
Alteryx One Admin Experience
Labels
Top Solution Authors
View All