Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Alteryx is here to help you solve your biggest data challenges. Read about the new Virtual Solution Center here.

Error opening "SELECT SERVERPROPERTY('EngineEdition')": No Columns Returned.

Highlighted
5 - Atom

Receiving this error when running an iterative macro: Error opening "SELECT SERVERPROPERTY('EngineEdition')": No Columns Returned. This doesn't always happen, but usually happens once we have completed a couple hundred iterations. We are attempting to write to SQL Server using an ODBC Connection. Help is greatly appreciated on this! Thanks.

Highlighted
Inactive User
Not applicable

How fast are the iterations? I am assuming inside the macro is a set of input tool(s) containing a SQL Server DB ODBC connection? Is anything being modified on that connection through the iterations, such as table name or the select statement?

 

You could try putting an ODBC trace on to see if anything more detailed shows up.  This appears to be a standard error message related to the type of SQL Server instance https://docs.microsoft.com/en-us/sql/t-sql/functions/serverproperty-transact-sql

 

 

Labels