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

Alteryx designer Discussions

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

Looks aren't everything... But the latest Community refresh looks darn good!

Learn More

Function sequence error with SQL Stored Procedure

Highlighted
Asteroid

I have the following Stored Procedure in SQL Server. Whenever I try to call it using the Input tool, I get the following error msg:

 

Error: Dynamic Input (56): Error SQLExtendedFetch: [Microsoft][ODBC Driver 13 for SQL Server]Function sequence error

 

USE [DevSaqib]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[uspTryCatch]    
   
       AS         
   BEGIN  

     begin try
         PRINT 'test'
         SELECT 'Return Value'=0

     end try

     begin catch
         PRINT 'test failed'
         SELECT 'Return Value'=-1

     end catch    
  END -- proc end

Please advise.

Alteryx
Alteryx

Hi @saqib,

 

What driver are you using for the SQL Server? Also, can you please share the workflow through private message?

Best,
John Posada
Senior Customer Support Engineer - Alteryx

Just to confirm. Was this resolved? I have same issue.

Labels