community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

SQL Server Stored Procedure Error

Atom

I'm connecting to a MS SQL Server database and using a stored procedure. I enter the parameters that I need, but I get the error


Error: Input Data (1): Error opening "EXEC usp_NBReportNULL, NULL, NULL, NULL, 04/01/2019, 04/01/2019, NULL, TBD": No Columns Returned.

 

The query in the error message is the one auto-generated after I entered the parameters, I did not write this. I've read a few posts about dynamic input but can't seem to get that to work as I can't get the input tool that must go before it to work. 

Aurora

hi @AY1 

 

The space is missing between the procedure name and the first null parameter.

 

EXEC usp_NBReportNULL, NULL, NULL, NULL, 04/01/2019, 04/01/2019, NULL, TBD

 

It should be 

 

EXEC usp_NBReport NULL, NULL, NULL, NULL, 04/01/2019, 04/01/2019, NULL, TBD

 

This happens occasionally in Alteryx.  You need to edit the connection, go into the SQL Editor and add the space back in manually.  

 

Dan

Atom

With the space added, I am still getting the same error. 

Aurora

@AY1 

 

Does the procedure actually return anything?

 

Dan

Labels