When I describe an object using the F4 key, I get the “List index out of bounds (-1)” error.
I checked online and the full version of toad 12.5.1.1 was installed over the trial version. I copied the connection files (3) from the Trial version to the full version. The forum suggested deleting the Rulesets folder. I did that but I still get the error.
A clean set of user files will probably fix it, but it will cause you to lose whatever customizations that you have made in Toad. To do that, from the main menu, go to Utilities -> Copy User Files. In the dialog that appears, choose “reset to a clean set of user files from the base installation”. Then click OK.
If you’d rather not lose your customizations and would like to try to find the cause of the problem and fix it, then the next time you see that error message…click where it says “Click Here”, then at the bottom of the dialog that appears, check “Copy to Clipboard” and click OK. Then you can come back here and paste in the contents of your clipboard and that should tell me where the error is coming from and hopefully what you can do to fix it.
Thank you John!! I did that and haven’t received the error yet.
I’m afraid I spoke too soon. I did the change in the settings and also upgraded to Toad 12.6. I still see the error. I am pasting the contents of the popup.
EurekaLog 7.0.7.1
Application:
1.1 Start Date : Mon, 20 Oct 2014 11:09:37 -0400
1.2 Name/Description: Toad.exe - (Toad™ for Oracle®)
1.3 Version Number : 12.6.0.53
1.4 Parameters :
1.6 Up Time : 11 minute(s), 49 second(s)
Exception:
2.1 Date : Mon, 20 Oct 2014 11:21:26 -0400
2.2 Address : 0000000004248B58
2.3 Module Name: Toad.exe - (Toad™ for Oracle®)
2.5 Type : EListError
2.6 Message : List index out of bounds (-1).
2.7 ID : A0FA0000
2.8 Count : 1
2.11 Sent : 0
User:
3.2 Name : ITUser
3.3 Email:
Active Controls:
4.1 Form Class : TF4HolderForm
4.2 Form Text : STHOMAS@MAPSDV5 - Describe Objects (Package Body PRS.APC_STRESS_MGR)
4.3 Control Class: TToadPageControl
4.4 Control Text :
Computer:
5.2 Total Memory : 8544862208 (7.96 Gb)
5.3 Free Memory : 4860440576 (4.53 Gb)
5.4 Total Disk : 159893041152 (148.91 Gb)
5.5 Free Disk : 100672761856 (93.76 Gb)
5.6 System Up Time : 2 day(s), 13 hour(s), 12 minute(s), 9 second(s)
5.7 Processor : Intel® Core™ i7-2600 CPU @ 3.40GHz
5.12 Virtual Machine:
Operating System:
6.1 Type : Microsoft Windows 7 (64 bit)
6.2 Build #: 7601
Steps to reproduce:
8.1 Text:
Call Stack Information:
|Methods |Details|Stack |Address |Module |Offset |Unit |Class |Procedure/Method |Line |
|*Exception Thread: ID=1080; Parent=0; Priority=-2 |
|Class=; Name=MAIN |
|DeadLock=0; Wait Chain= |
|Comment= |
|---------------------------------------------------------------------------------------------------------------------------------------------------------------------|
|7FFFFFFE|03 |0000000000000000|0000000004248B58|Toad.exe |00000000000B8B58|System.Classes |TList |Get | |
|00000040|03 |000000000042FB18|00000000082782FA|Toad.exe |00000000040E82FA|FrmF4Holder |TF4HolderForm |tmrDelayedOpenTimer | |
|00000040|03 |000000000042FB98|000000000453E60A|Toad.exe |00000000003AE60A|Vcl.ExtCtrls |TTimer |Create | |
|00000040|03 |000000000042FBC8|000000000453E446|Toad.exe |00000000003AE446|Vcl.ExtCtrls |TTimer |WndProc | |
|00000040|03 |000000000042FC18|0000000004266A94|Toad.exe |00000000000D6A94|System.Classes | |StdWndProc | |
|00000040|03 |000000000042FC68|0000000077049BCA|user32.dll |0000000000019BCA|USER32 | | (possible TranslateMessageEx+666)| |
|00000040|03 |000000000042FD28|00000000770498D5|user32.dll |00000000000198D5|USER32 | | (possible TranslateMessage+485) | |
|00000040|03 |000000000042FDA8|00000000045CD75F|Toad.exe |000000000043D75F|Vcl.Forms |TApplication |ProcessMessage | |
|00000040|03 |000000000042FE28|00000000045CD7D3|Toad.exe |000000000043D7D3|Vcl.Forms |TApplication |HandleMessage | |
|00000040|03 |000000000042FE98|00000000045CDCCF|Toad.exe |000000000043DCCF|Vcl.Forms |TApplication |Run | |
|00000040|03 |000000000042FED8|0000000008EFC759|Toad.exe |0000000004D6C759|Toad | |Initialization | |
|00000040|03 |000000000042FF58|00000000772A59EB|kernel32.dll |00000000000159EB|kernel32 | | (possible VirtualQuery+4743) | |
|00000040|03 |000000000042FF88|000000007775C53F|ntdll.dll |000000000002C53F|ntdll | | (possible towupper+2271) | |
|---------------------------------------------------------------------------------------------------------------------------------------------------------------------|
| |
|Running Thread: ID=6832; Parent=1080; Priority=0 |
|Class=TSendThread; Name=[Unnamed thread] Kind: TThread. Thread function: CSLog.TSendThread.Execute + $0. Thread caller: CSLog.TSendThread.Create + $3C (CSLog.TSendThread.Execute)|
|DeadLock=0; Wait Chain=thread: [ 1AB0 / 6832 ] is blocked |
|Comment= |
|---------------------------------------------------------------------------------------------------------------------------------------------------------------------|
|7FFFFFFE|03 |0000000000000000|00000000777812FA|ntdll.dll |00000000000512FA|ntdll | |ZwWaitForSingleObject | |
|00000040|03 |000000001319FCC8|000007FEFDC810D6|KERNELBASE.dll|00000000000010D6|KERNELBASE | |WaitForSingleObjectEx | |
|00000040|03 |000000001319FD68|00000000066EF376|Toad.exe |000000000255F376|CSLog |TSendThread |Execute | |
|00000040|03 |000000001319FDC8|0000000004261D58|Toad.exe |00000000000D1D58|System.Classes | |ThreadProc | |
|00000040|04 |000000001319FE28|0000000004379014|Toad.exe |00000000001E9014|EThreadsManager | |NakedBeginThreadWrapper |1287[5] |
|00000040|04 |000000001319FE78|00000000043BE7FE|Toad.exe |000000000022E7FE|EExceptionManager| |DefaultThreadHandleException |2767[6] |
|00000040|04 |000000001319FED8|0000000004379F44|Toad.exe |00000000001E9F44|EThreadsManager | |ThreadWrapperCT |1677[17] |
|00000040|03 |000000001319FF58|00000000772A59EB|kernel32.dll |00000000000159EB|kernel32 | | (possible VirtualQuery+4743) | |
|00000040|03 |000000001319FF88|000000007775C53F|ntdll.dll |000000000002C53F|ntdll | | (possible towupper+2271) | |
|---------------------------------------------------------------------------------------------------------------------------------------------------------------------|
| |
|Running Thread: ID=2808; Parent=1080; Priority=0 |
|Class=TSaveSettingsThread; Name=[Unnamed thread] Kind: TThread. Thread function: tdSaveSettings.TSaveSettingsThread.Execute + $0. Thread caller: tdSaveSettings.TSaveSettingsThread.Create + $3C (tdSaveSettings.TSaveSettingsThread.Execute)|
|DeadLock=0; Wait Chain=thread: [ 0AF8 / 2808 ] is blocked |
|Comment= |
|---------------------------------------------------------------------------------------------------------------------------------------------------------------------|
|7FFFFFFE|03 |0000000000000000|000000007778186A|ntdll.dll |000000000005186A|ntdll | |ZwWaitForMultipleObjects | |
|00000040|03 |000000001983FB88|000007FEFDC8142A|KERNELBASE.dll|000000000000142A|KERNELBASE | | (possible GetCurrentProcess+58) | |
|00000040|03 |000000001983FC88|00000000772B171E|kernel32.dll |000000000002171E|kernel32 | | (possible IsProcessInJob+8510) | |
|00000040|03 |000000001983FD18|0000000004272542|Toad.exe |00000000000E2542|System.SyncObjs |THandleObject |WaitFor | |
|00000040|03 |000000001983FD78|000000000828E739|Toad.exe |00000000040FE739|tdSaveSettings |TSaveSettingsThread|Execute | |
|00000040|03 |000000001983FDC8|0000000004261D58|Toad.exe |00000000000D1D58|System.Classes | |ThreadProc | |
|00000040|04 |000000001983FE28|0000000004379014|Toad.exe |00000000001E9014|EThreadsManager | |NakedBeginThreadWrapper |1287[5] |
|00000040|04 |000000001983FE78|00000000043BE7FE|Toad.exe |000000000022E7FE|EExceptionManager| |DefaultThreadHandleException |2767[6] |
|00000040|04 |000000001983FED8|0000000004379F44|Toad.exe |00000000001E9F44|EThreadsManager | |ThreadWrapperCT |1677[17] |
|00000040|03 |000000001983FF58|00000000772A59EB|kernel32.dll |00000000000159EB|kernel32 | | (possible VirtualQuery+4743) | |
|00000040|03 |000000001983FF88|000000007775C53F|ntdll.dll |000000000002C53F|ntdll | | (possible towupper+2271) | |
|---------------------------------------------------------------------------------------------------------------------------------------------------------------------|
| |
|Running Thread: ID=4932; Parent=1080; Priority=0 |
|Class=TWorkerThread; Name=[Unnamed thread] Kind: TThread. Thread function: VirtualTrees.TWorkerThread.Execute + $0. Thread caller: VirtualTrees.TWorkerThread.Create + $42 (VirtualTrees.TWorkerThread.Execute)|
|DeadLock=0; Wait Chain=thread: [ 1344 / 4932 ] is blocked |
|Comment= |
|---------------------------------------------------------------------------------------------------------------------------------------------------------------------|
|7FFFFFFE|03 |0000000000000000|00000000777812FA|ntdll.dll |00000000000512FA|ntdll | |ZwWaitForSingleObject | |
|00000040|03 |000000001DAAFCD8|000007FEFDC810D6|KERNELBASE.dll|00000000000010D6|KERNELBASE | |WaitForSingleObjectEx | |
|00000040|03 |000000001DAAFD78|00000000053222CF|Toad.exe |00000000011922CF|VirtualTrees |TWorkerThread |Execute | |
|00000040|03 |000000001DAAFDC8|0000000004261D58|Toad.exe |00000000000D1D58|System.Classes | |ThreadProc | |
|00000040|04 |000000001DAAFE28|0000000004379014|Toad.exe |00000000001E9014|EThreadsManager | |NakedBeginThreadWrapper |1287[5] |
|00000040|04 |000000001DAAFE78|00000000043BE7FE|Toad.exe |000000000022E7FE|EExceptionManager| |DefaultThreadHandleException |2767[6] |
|00000040|04 |000000001DAAFED8|0000000004379F44|Toad.exe |00000000001E9F44|EThreadsManager | |ThreadWrapperCT |1677[17] |
|00000040|03 |000000001DAAFF58|00000000772A59EB|kernel32.dll |00000000000159EB|kernel32 | | (possible VirtualQuery+4743) | |
|00000040|03 |000000001DAAFF88|000000007775C53F|ntdll.dll |000000000002C53F|ntdll | | (possible towupper+2271) | |
|---------------------------------------------------------------------------------------------------------------------------------------------------------------------|
| |
|Running Thread: ID=7012; Parent=1080; Priority=0 |
|Class=TSyntFinishThread; Name=[Unnamed thread] Kind: TThread. Thread function: ecSyntAnal.TSyntFinishThread.Execute + $0. Thread caller: ecSyntAnal.TSyntFinishThread.Create + $C3 (ecSyntAnal.TSyntFinishThread.Execute)|
|DeadLock=0; Wait Chain=thread: [ 1B64 / 7012 ] is blocked |
|Comment= |
|---------------------------------------------------------------------------------------------------------------------------------------------------------------------|
|7FFFFFFE|03 |0000000000000000|00000000777812FA|ntdll.dll |00000000000512FA|ntdll | |ZwWaitForSingleObject | |
|00000040|03 |0000000026E7FAF8|000007FEFDC810D6|KERNELBASE.dll|00000000000010D6|KERNELBASE | |WaitForSingleObjectEx | |
|00000040|03 |0000000026E7FB98|000000000420BBB4|Toad.exe |000000000007BBB4|System.SysUtils | |WaitForSyncWaitObj | |
|00000040|03 |0000000026E7FBC8|000000000420BE79|Toad.exe |000000000007BE79|System.SysUtils | |WaitOrSignalObj | |
|00000040|03 |0000000026E7FBF8|000000000419DE1F|Toad.exe |000000000000DE1F|System |TMonitor |Wait | |
|00000040|03 |0000000026E7FC68|000000000419DF01|Toad.exe |000000000000DF01|System |TMonitor |Wait | |
|00000040|03 |0000000026E7FCA8|0000000004262C97|Toad.exe |00000000000D2C97|System.Classes |TThread |Synchronize | |
|00000040|03 |0000000026E7FD28|0000000004262D94|Toad.exe |00000000000D2D94|System.Classes |TThread |Synchronize | |
|00000040|03 |0000000026E7FD88|00000000042623D2|Toad.exe |00000000000D23D2|System.Classes |TThread |DoTerminate | |
|00000040|03 |0000000026E7FDC8|0000000004261D94|Toad.exe |00000000000D1D94|System.Classes | |ThreadProc | |
|00000040|04 |0000000026E7FE28|0000000004379014|Toad.exe |00000000001E9014|EThreadsManager | |NakedBeginThreadWrapper |1287[5] |
|00000040|04 |0000000026E7FE78
Couple of questions:
Where are you F4ing from?
Is this 32 or 64 bit Toad?
From the editor.
64 bit
I’m not having any luck reproducing this problem, and unfortunately, I can’t pinpoint it with the call stack.
Are you having any connection problems to this DB?
Does it happen on all packages? It looks like the package is in a schema different than your logon schema. What about if the package is in your schema?
No connection problems so far. This is not specific to packages, it happens on other object types also.
I don’t have objects in my schema. DBA’s just create a user for me and all objects reside on application schemas. I can create objects on my schema and try.
Also, when you asked “Where am I F4ing from?”. I use it from the “Used By” tab from an object’s popup description.
for e.g.
Type an object name in the editor. e.g. Table A.
Place the cursor on Table A and press F4.
This opens a popup showing Table A’s description.
Click on the “Used By” tab.
Select a dependent and press F4.
This should show you the error. If not, try one more level of dependents. Table A >> Table B >> Table C.
Ah-hah! I do get the error that way. I’m not sure that there is anything you can do about it except F4 a different way for the object in the “used by” tab. (like click the “Describe another object” button on the describe dialog and type in the name of the object).
I’ll have it fixed for the next beta.
Thanks!! The error does not crash my session of Toad, it just takes the spinning wheel about 10 seconds to show the error popup and until then Toad freezes. I think I’ll live with this until the next version is released.
Thanks.