I recently uninstalled some older versions of Toad and started getting this error in Toad 14.1:
Toad.el shows:
Exception:
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
2.1 Date : Tue, 20 Jul 2021 13:44:05 -0600
2.2 Address : 00000000042C53CF
2.3 Module Name : Toad.exe - (Toad® for Oracle)
2.4 Module Version: 14.1.120.923
2.5 Type : EFCreateError
2.6 Message : Cannot create file "C:\Users\XXXXXXX\AppData\Roaming\Quest Software\Toad for Oracle\13.3\User Files\FmtPlus.opt". The system cannot find the path specified.
2.7 ID : 03DBF010
2.8 Count : 1
2.11 Sent : 0
Why is version 14.1 trying to read the FmtPlus.opt file from an older version when there is a copy in the 14.1\User Files folder?
I've renamed the 13.3_uninstalled folder back to 13.3 to stop the error but is there a way to stop Toad from looking in that folder?
I'm guessing one/both of these can be used to direct settings to the right folder.
Hi John, I checked the options and it says the it's loading from the 14.1 folder.
I also checked the timestamp on the file in the 14.1 folder and it's current so it is updating that one.
I have no idea at what point it decides to go to the 13.3 folder. I was getting the error as I was typing in the edit window.
Thanks
p.s, I checked the FmtPlus.opt file in the 13.3 folder and it has the same timestamp as the file in the 14.1 folder. Toad is updating both copies.
Please make the error happen again and then click where it says "click here". On the next dialog, check the "copy to clipboard" box, then click OK, and paste the clipboard contents here. That'll give me a full call stack and then I can probably give you better info.
A portion of the error is below. I hit the character limit for the post body so the full error text is attached.
ToadError.txt (98.8 KB)
EurekaLog 7.9.1.0 8D15780CC9CEB34C98151D73D556A099 32354559066BD5448D53A92694A5EB0A DA39A3EE5E6B4B0D3255BFEF95601890AFD80709 7E57B67165D2244384D20F22AA1ACCDC
Application:
------------------------------------------------------------------------
1.1 Start Date : Fri, 25 Jun 2021 10:46:46 -0600
1.2 Name/Description: Toad.exe - (Toad® for Oracle)
1.3 Version Number : 14.1.120.923
1.4 Parameters :
1.5 Compilation Date: Thu, 11 Mar 2021 11:39:35 -0600
1.6 Up Time : 25 day(s), 2 hour(s), 57 minute(s), 19 second(s)
Exception:
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
2.1 Date : Tue, 20 Jul 2021 13:44:05 -0600
2.2 Address : 00000000042C53CF
2.3 Module Name : Toad.exe - (Toad® for Oracle)
2.4 Module Version: 14.1.120.923
2.5 Type : EFCreateError
2.6 Message : Cannot create file "C:\Users\XXXXXXX\AppData\Roaming\Quest Software\Toad for Oracle\13.3\User Files\FmtPlus.opt". The system cannot find the path specified.
2.7 ID : 03DBF010
2.8 Count : 1
2.11 Sent : 0
User:
-------------------------
3.2 Name: Raymond Leung
Active Controls:
---------------------------------------------------------------------------------
4.1 Form Class : TfrmMain
4.2 Form Text : DYNATRACEAGENT@R_PROD - Toad for Oracle - [Editor (New 1 *)]
4.3 Control Class: TtdDScintilla
4.4 Control Text :
Computer:
---------------------------------------------------------------------------------------------------------------------------------------------------------------------
5.2 Total Memory : 17054662656 (15.88 Gb)
5.3 Free Memory : 8038678528 (7.49 Gb)
5.4 Total Disk : 253898432512 (236.46 Gb)
5.5 Free Disk : 80912240640 (75.36 Gb)
5.6 System Up Time : 25 day(s), 4 hour(s), 34 minute(s), 31 second(s) / 25 day(s), 4 hour(s), 37 minute(s), 16 second(s)
5.7 Processor : Intel(R) Core(TM) i5-6300U CPU @ 2.40GHz
5.8 Display Mode : \\.\DISPLAY1[PRIMARY]: 1920x1080x32 96 DPI @ 0x0, \\.\DISPLAY2: 1920x1080x32 96 DPI @ -1920x0, \\.\DISPLAY3: 2560x1440x32 96 DPI @ 1920x-1079
5.9 Display DPI : 96
5.10 Video Card : Intel(R) HD Graphics 520 (driver 27.20.100.8190 - RAM 1073741824)
5.11 Printer : Microsoft Shared Fax Driver (driver 10.0.19041.1023)
5.12 Virtual Machine:
WIth Toad not running, look in Toad.ini
Find this value and fix if needed: FORMAT_OPTIONS_FILENAME=....
I'm guessing it's wrong there.
It looks correct in Toad.ini:
FORMAT_OPTIONS_FILENAME=C:\Users\XXXXXX\AppData\Roaming\Quest Software\Toad for Oracle\14.1\User Files\FmtPlus.opt
I did a search on 13.3 in the ini file and found these entries:
[Database Browser]
CurrentFile=C:\Users\XXXXXX\AppData\Roaming\Quest Software\Toad for Oracle\13.3\User Files\DatabaseBrowser.tdb
[Database Browser Files]
C:\Users\XXXXXX\AppData\Roaming\Quest Software\Toad for Oracle\13.3\User Files\DatabaseBrowser.tdb=1
[FmtOptMRU_Files]
0=C:\Users\XXXXXX\AppData\Roaming\Quest Software\Toad for Oracle\14.1\User Files\FmtPlus.opt
1=C:\Users\XXXXXX\AppData\Roaming\Quest Software\Toad for Oracle\13.3\User Files\FmtPlus.opt
2=C:\Users\XXXXXX\AppData\Roaming\Quest Software\Toad for Oracle\12.12\User Files\FmtPlus.opt
I don't have a 12.12 folder but Toad doesn't give me an error for that one.
So now that I've closed Toad and restarted it I can't reproduce the error anymore. I wonder if it's related to having Toad running when I uninstalled the older versions so Toad had some pointer to the older version folders because they were still installed when it started.
If it comes back I'll let you know. Thanks.
1 Like
