cancel
Showing results for 
Search instead for 
Did you mean: 
harryr
Nintex Newbie

SQL Request Stored Procedure parameter not supplied

Jump to solution

 Hi 

I am using Nintex forms to grab some data from a remote SQL server for a dropdown field.

 

The SQl query ran fine but I wanted to change this to use a stored procedure.

 

When I test run the stored procedure in Nintex Forms i get an error shown in the screenshot below:

 

CaptureStoredProcedureError.PNG

 

The thing is, when I run this in SQL, I get the expected results (a list of customers).

I am thinking that the value for the @CUSTTABLECUBEPARTITION ids not being passed for some reason.

 

I have tried altering the stored procedure so that it only needs one paramaeter (@DATAAREAID) and the same problem comes up:

CaptureStoredProcedureError2.PNG

 

Anyone know what may be going on here and how to get the value to pass from Nintex/Sharepoint to the stored procedure?

 

Thanks.

Labels: (1)
0 Kudos
Reply
1 Reply
harryr
Nintex Newbie

Re: SQL Request Stored Procedure parameter not supplied

Jump to solution

Ok Solved this one. I removed the "@" before the parameter name in the SQL Request configuration. Instead of typing "@DATAAREAID", I used "DATAAREAID". Working as expected now. 

 

CaptureStoredProcedureError3.PNG

0 Kudos
Reply