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
Discussion posts and replies are publicly visible
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.
Thank you! I'm not sure how or why but deleting the input and re-adding it appears to have fixed the problem
It could have been a cache issue. Sometimes when everything is right yet issue occurs this is the only solution -> unplug and plug again
Thanks for your suggestion, 100% very likely