Error to execute store procedure

Help Activities
, ,
1

Hello everone!

I have some troubles when I want to execute a store procedure using the UiPath database activities.

I’ve already configured all the setting that are needed to execute it (connection, parameter, sql query which is the name of procedure) however, When I run the process there will be the following error

image

The flow has others simple queries which run perfectly, the problem is to execute the store procedure.

This store procedure takes more than 30 minutes to finish, I don´t know if it is the cause to the error.

I tested to specify 2400000 as timeout (considering that it is the time that the SP takes to finish) but another error appeared

image
image981×215 35.6 KB

How Shall I do to solve it?

Thanks

2

@julio.cruz - This is the problem faced in UiPath only, while otherwise the query/stored proc runs pretty well without any issues.
timeout is the only way to manage and try to see how the avg time the query takes and put that in the timeout field in UiPath.

2 other approaches I generally take is:

1/ Split the bulk queries so the execution time is less
2/ If its stored procs, split those to multiple pieces or parameterize them by limiting the no. of records.