The following intermittent error occurs while in Toad.
ERROR:
Cannot open file "C:\Documents and Settings\user_name\Application Data\Quest Software\Toad for Oracle\10.0\User Files\~EditorBackups.txt". The process cannot access the file because it is being used by another process.
Cause 1:
EditorBackups.txt is stored in the 'User Files' folder in 'C:\Documents and Settings\<username>\Application Data\Quest Software\Toad for Oracle\10.0\'. The user's application data folder was being archived on the server every hour and this was locking the file.
Cause 2:
Two copies of Toad are launched and there is a timing conflict when both instances of Toad try to access the referenced file at the same time.
RESOLUTION 1:
Have your network admin exclude the ~EditorBackups.txt file from auto archive or backup.
RESOLUTION 2:
Request for a local profile in your computer from your Network Admin team.
RESOLUTION 3:
1) Start Toad and go to View Menu | Toad Options | General | under “Application Data Directory” section
2) Change the entry from:
C:\Users\<username>\AppData\Roaming\Quest Software\Toad for Oracle\10.x\
to:
C:\Users\<username>\AppData\Local\Quest Software\Toad for Oracle\10.0\
For Cause 2:
WORKAROUND
Launch only one instance of Toad at a time
STATUS
Waiting for fix in a future release of Toad for Oracle
