I am facing an issue when I try to execute a SQL query in Uipath Studio. I receive the error message “Execute Delete Korning: ERROR [HYT00] [Oracle][ODBC][Ora]ORA-01013:
User requested cancel of current operation”.
When I run the query in Microsoft SQL Developer it works fine so I know the query it self is correct.
The query I try to run is:
DELETE From external_data ed Where ed.id In (Select ed2.id From external_data ed2, korning k Where K.init_korning_id = 87 and K.arende_id = ‘20284508’ and K.beslutstyp = 'saknas’and K.orgnr = ‘0000000005’ AND ed2.korning_id = k.id);
When googling the issue it seems like it is related to timeouts so I’ve tried to extend the timeput to over 2 minutes but it still gets the same error message.
Any ideas what I can do?