Oracle error ORA-01013: user requested cancel of current operation

Published: Wednesday, 16 February 2011
oracle

ORA-01013: user requested cancel of current operation. cause and solution.

Cause: user locked record and application transaction cancellation

We experienced this error today when a tester was modifying records on our test server but forgetting to commit his changes. This has the effect of records being locked and unmodifiable in the database.

SQL Error: 1013, SQLState: 72000
ORA-01013: user requested cancel of current operation

Our application will cancel any transaction that it deems to have timed out. In this case it was attempting to update records which were locked and not released by another transaction

The solution is to educate testers/developers to be careful not to lock records in the database for extended periods.