Database - ORA-01013: user requested cancel of current operation

Help Activities
, ,
1

During the recent bot execution, the following error was encountered:
Run Command: ORA-01013: user requested cancel of current operation

I am using the Execute Query activity to run Oracle SQL commands on the Oracle database. The same query works successfully when executed manually. Until recently, it was also running without any issues through UiPath.

Select queries running as expected.
Out of three UPDATE queries, two are consistently failing with the above error.

  • I have already increased the timeout setting to 5 minutes (300,000 ms), but the issue persists.

The issue appears to be specific to the UPDATE operations, as the connection remains stable and other commands execute correctly.

Thanks & Regards,
Meghana

2

How about checking authorities? If is not working all of sudden, based on my experience, it was usually authority problem.

3

How I need to check the authorities?

Out of 2 one update query is working fine and all select queries are working. From morning to till two hours back these queries also working and manually i can able to update using UiPath facing the error.

4

Hi @Meghana_Bonu

May be put in some delay between different update query runs..

May be bot is trying to do another update while first update was still not completely done.

Also refer below kb from UiPath on same