RE: crash problems

Hi Wendy,

Toad still doesn't do well when Oracle is pulled away from it in the middle of the night. This is a systemic problem I think.

Regarding document recovery, there was an enhancement a couple of releases back which came from user requests to have the database connection which was tied to a file automatically occur when the file is recovered.  Your long 25 second pause is happening because it's trying to re-establish the connection to ITHACA@SISQA and is failing. The information about which document is tied to which connection is kept in the temporary file ~EditorBackups.txt, which is in the User Files folder, as you probably know.

All files in all tabs of all open Editor windows are backed up, regardless of whether any change was made to them. You can view all of the temporary files in your User Files folder while Toad is running. They are the ones prefixed with "~eb" with a .tmp extension.

I was trying to figure out your workflow. By 'second instance of Toad' do you mean the same version? If so, it doesn't follow that the 'cut & paste' works since the destination is the same as the source (same User Files folder).

anyway, maybe some of what I said helps.

Maybe a useful enhancement request would be to have a check box on the document recovery window to not automatically reconnect to the database - just recover the file.

Mark


From: [email protected] [mailto:[email protected]] On Behalf Of Wendy Penfold
Sent: Thursday, October 27, 2011 12:09 PM
To: ToadList
Subject: [toad] crash problems

Using Toad 11.0.0.116 occasionally when I come in in the morning having left Toad running overnight, I have an Invalid Window Handle error 1400 and Toad is frozen--presumably because it was disconnected from one of the databases I was working in overnight....(?)  This has happened since version 10.  It used to be I could kill Toad and restart it and it was nice enough to save all my open windows.  I'm running into some issues with version 11 though...
It only saves the editor windows that were unsaved at the time--which I can live with.  However, I can't successfully restore the ones it has saved.  I select the documents I want to restore and click ok.  There is about a 25 second pause for each document and then I get this error:
[cid:[email protected]]
After I've done this for each window the database connection window comes up and I select a database to connect to.  And then I get this error.
[cid:[email protected]]
The only way i've been able to figure out how to recover is open another instance of Toad and manually cut and paste all the recovered documents from the first instance to the second.  Is there something messed up in my settings?