Connection to BigQuery database

Help Activities
, ,
1

Hello!
Suddenly I’m having issues with adding records to my GCP table.
I’m using “Connect” activity with connection string: “Dsn=TableName”, and ODBC provider.
Now: one of the job was stuck for 9h on activity Execute Query, with adding new records to the table. I had to Kill the job, so I wasn’t able to properly Disconnect.

  1. How to close such connection manually now? Is it possible? Does connection have some lifetime and will close automatically?
  2. How to set timeout/lifespan to connection in UiPath? Updating connection string with “timeout” is not helpful because this timeout refers to “How long does we want to wait to establish connection”, not to maintain it.
  3. Is it possible, that tables on GCP have some limitations in Data Size? Currently, tables has around 32 millions of records, around 5-10 columns. It seems not much, but maybe I have crossed the limits?
  4. What other limitations might keeping my process in stuck?
    Thank you for the discussion.

+Let me add, that process was successfully running for over 1 year, and now it’s having sudden issues like described.