UiPath - Snowflake activity failing when response takes >30 seconds

[ajp]

I am using the Snowflake Native Search activity to call a store procedure. It works fine whenever the store procedure response is returned within 30 seconds but the same activity throws the below error whenever the store procedure takes more than 30 seconds to return the result. Has anyone encountered this before? To me looks like a time-out issue. I could not find any timeout parameter within the activity itself. Hence, I tried updating the generic time-out value (which was set to 30 sec) in the project setting but no luck. Any idea?

[ashokkarale]

@ajp,

Try Limit property to limit the result if your business requirement allows.

Thanks,
Ashok

[ajp]

Thanks, Ashok.

Limit will not work in my case as I am calling a store procedure which is performing a bulk data update and generally, it takes more than 3 minutes to complete.

Regards.
AJP