When deadlock occurs during the execution of SQL statements or stored procedures, unlike client/server applications, the deadlocked transaction cannot be aborted by closing IE. This is because the database transaction is connected to the Appeon Server, rather than to the client.
To abort a transaction when deadlock occurs, use any of the following workarounds: 1) Restart the database; 2) Abort the transaction at the Database Server; or 3) Wait until the transaction time out.
