Execute Stored Procedure Smart Service - missing parameter error

Question

Hi, 
 I am trying to run a process that uses the Execute Stored Procedure Smart Service. The stored procedure can run based on 3 values (either the RoleId or the RoleExternalKey and the RoleTypeCode). I am passing a value for the RoleId in the pv and have confirmed this by checking it with a new PV and passing null values for the other two parameters. I have confirmed that the data types and parameter names all match those for the Stored Proc, however I am still receiving this error message: 
 "One or more IN or INOUT parameters were not passed to the stored procedure. Missing parameter names: RoleId." 
 Has anyone received this error and how did you work through it? 
 Thanks

Shubham Aware · Accepted Answer

Make sure RoleId matches exactly the stored procedure parameter name, including case. Delete the old parameter mapping and re-add it fresh in the Smart Service node. Define all IN and INOUT parameters even if you pass null to some.

Harsha Sharma · Answer

It could have been a cache issue. Sometimes when everything is right yet issue occurs this is the only solution -> unplug and plug again

Execute Stored Procedure Smart Service - missing parameter error

Top Replies