Submitting forms on the support site are temporary unavailable for schedule maintenance. If you need immediate assistance please contact technical support. We apologize for the inconvenience.
Open transaction timeout setting does not end transaction properly.
설명
Open transaction timeout setting does not end transaction properly. If the user sets the Open transaction timeout to 5 seconds, even after 5 seconds, the transaction time for the query will continue to increase. Users have to cancel the running query manually.
Steps to replicate
1. In the Editor, type in 2 queries example: select * from sys.dba_objects and select * from dual
2. In Tools | Options | Editor | General > limit number of rows to initially fetch in data tab to something small like 40 since customer only wants to view 40.
3. Execute F9 or even F5 select * from sys.dba_objects Issue - at the bottom of the TDA window to the right of the AutoCommit icons there is a timing that shows the transaction running. The transaction time will continue to increase.
4. Go to Tools | Options | Database | Timeouts -- set the Open transaction timeout to 5, 10 or even 30 seconds but it has no effect.
해결 방안
WORKAROUND: User will have to manually cancel the transaction by clicking on the Cancel X icon on the toolbar.
STATUS: Waiting for fix in a future release of Toad for Data Analysts.
