You’re offline. This is a read only version of the page.
Announcements
Hi,
I am facing very strange issue with SQL stored procedure and connecting it via Microsoft Flow.
I had created a stored procedure which takes input that is set as nvarchar(max). If I test stored procedure over SSMS it works fine while if i call it from Ms.Flow i get below error message.
The 'inputs.parameters' of workflow operation 'Execute_stored_procedure_(V2)' of type 'OpenApiConnection' is not valid. Error details: The API operation 'ExecuteProcedure_V2' requires the property 'parameters/Comments' to be a string of maximum length '-1' but is of length '20'.
I had another sql database for my other project which uses same table, SP and Ms Flow. I transferred everything from that tenancy to current to test this issue. I see issue on this database.
My flow is running in preview version. Database where SP+Ms.Flow with nvarchar(max) is basic plan while one with issue is standard plan.
I also found issue with int column. If pass details to SP with int column it throws similar issue. As a work around i changed variable to nvarchar(255) and then cast it to int in query it worked.
Need help on fixing this issue.
Thanks
Priyank Bhat
Hi @priyankbhat1 ,
The error message said the property 'parameters/Comments' to be a string of maximum length '-1' but is of length '20', I'm afraid that you could only trouble shooting it according to this message and you could change the maximum length.
Best Regards,
Alice
Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Share
Report
All responses (
Answers (
525
