Execute query : String[1]: the Size property has an invalid size of 0

uiautomation
activities
uipath

#1

I have a stored procedure and would like to get output from the params. I have declared two variables and have assigned the variables to output params in the execute query activity. I get the following error once I exectue it.

Execute query : String[1]: the Size property has an invalid size of 0.

image

Stored Proc:

declare @p5 int
set @p5=-1
declare @p6 varchar(1000)
set @p6='Query Invoice Header Successful (No Lines)'
exec sp_My_Stored_Proc @a,@p5 output,@p6 output
select @p5, @p6

What could be done to solve this issue?


#2

@Sripadraj, I have received the same error. Was this issue resolved for you? what could be need to change to rectify this issue


#3

I also got the same error. And not sure about the root cause.
But issue got resolved by following step.

Created a seperate workflow with connection and execute query. It was working.
Copy pasted the workflow in current program(Which uses arguments). Then all working fine