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