I am getting "Error in advanced query SQL1: ORA-01013: user requested cancel of current operation"
I have written SQL query Delete from {Entity} but while testing the SQL I am getting above mentioned error,
I have also increased timeout from by default to 7200secs still getting this error.
@shahrukh mujawar In addition to the query timeout on the SQL action, have you also increased your timeouts in Service Center?
Additionally, the IIS configuration machine.config under the httpRuntime section has executionTimeout. Make sure you have bumped this one up as well. Documentation For that here: https://success.outsystems.com/support/troubleshooting/application_runtime/timeouts_under_the_hood/
Finally, some modules also have module-wide timeout settings set as well, you should also verify that those are not lower than the others.
Shahrukh, just out of curiosity, how many records does the entity have?
If you're going to delete all records, have you tried the TRUNCATE command?
Hello @shahrukh mujawar,
This is probably due to huge amount of records in entity. Better to delete records in chunks, not more then 10000 recs at a time. Create a loop and delete 10K records at a time till all the records get deleted in server action.