BOT got stopped after 30 mins of execution

Help
1

I am using licenced version of Uipath (2019.2.0) on remote desktop and Uipath installed on same machine.

I am connecting to database and retrieving data and based on data doing some operations.
BOT is running fast for first 20 mins after that became slow and not able to process.

2

Hi,

Are you closing you database connection once you pulled data from the database.
How many times you are connecting and closing database connections in your workflow for a transaction.

3

Using Execute query Activity to connect to database and executing query also using same

4

It looks like your SQL connection timeout period, you need to check and close the connection then and there. so this issue wont happen.

5

Can you please try to find the mistake here as i am passing connstring value in Disconnect activity thrown error
connstring is of type string variable and disconnect activity expects database connection type.
So which value should i pass in disconnect activity.

connstring
connstring1051×345 58.5 KB
disconnect%20activity
disconnect%20activity883×202 17.1 KB

6

Even after closing the connection using disconnect where ever i have opened connection same behavior was happening with BOT…Can some one please guide me