Toad World® Forums

TOAD crashes on excel table import


#1

Hi all,

I got the following problem: for one of our users, TOAD started crashing when importing xls file into table, something that has always worked okay.

First it threw the exception “List index out of bounds”.

Here is the Toad.pl file from that exception (I don’t see any “add attachment” options so I am pasting it):

EurekaLog 7.0.7.1

Application:

1.1 Start Date : Fri, 13 Apr 2018 08:24:38 +0200
1.2 Name/Description: Toad.exe - (Toad™ for Oracle®)
1.3 Version Number : 12.6.0.53
1.4 Parameters :
1.6 Up Time : 6 hour(s), 24 minute(s), 30 second(s)

Exception:

2.1 Date : Fri, 13 Apr 2018 14:49:08 +0200
2.2 Address : 0420CBBC
2.3 Module Name: Toad.exe - (Toad™ for Oracle®)
2.5 Type : EListError
2.6 Message : List index out of bounds (5).
2.7 ID : 13B40000
2.8 Count : 3
2.11 Sent : 0

User:

3.2 Name : Admin
3.3 Email:

Active Controls:

4.1 Form Class : TfrmMain
4.2 Form Text : Toad for Oracle - [CIMWK@CIMISNB - Import Table Data (CIMWK.CIMIS_PRELAZNI)]
4.3 Control Class: TButton
4.4 Control Text : Ne&xt >

Computer:

5.2 Total Memory : 3064283136 (2,85 Gb)
5.3 Free Memory : 712826880 (679,80 Mb)
5.4 Total Disk : 125724258304 (117,09 Gb)
5.5 Free Disk : 15515217920 (14,45 Gb)
5.6 System Up Time : 10 day(s), 19 hour(s), 45 minute(s), 15 second(s)
5.7 Processor : Intel® Pentium® CPU G630 @ 2.70GHz
5.12 Virtual Machine: VirtualPC

Operating System:

6.1 Type : Microsoft Windows 7 (32 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=4568; Parent=0; Priority=-2 |
|Class=; Name=MAIN |
|DeadLock=0; Wait Chain= |

Comment=
7FFFFFFE
00000040
00000040
00000040
00000040
00000040
00000040
00000040
00000040
00000040
00000040
00000040
00000040
00000040
00000040
00000040
00000040
00000040
00000040
00000040
00000040
00000040
00000040
00000040
00000040
00000040
00000040
00000040
00000040
00000040
00000040
00000040
00000040
00000040
00000040
00000040
00000040
00000040
00000040
---------------------------------------------------------------------------------------------------------------------------------------------------
Running Thread: ID=6564; Parent=4568; Priority=0
Class=TSendThread; Name=[Unnamed thread] Kind: TThread. Thread function: CSLog.TSendThread.Execute. Thread caller: CSLog.TSendThread.Create (CSLog.TSendThread.Execute)
DeadLock=0; Wait Chain=thread: [ 19A4 / 6564 ] is blocked
Comment=
---------------------------------------------------------------------------------------------------------------------------------------------------
7FFFFFFE
00000040
00000040
00000040
00000040
00000040
00000040
00000040
00000040

#2

the above text was edited by me, but I see now it’s all missing. The .pl files were in courier new

I apologize for this, it was not my intention


#3

I don’t remember seeing this bug before but 12.6 is a fairly old version of Toad, so I may have just forgotten about it.

The .lay files are not related to this.

Things you might want to try:

Use an XLSX file instead of XLS (maybe Toad doesn’t like something about your XLS file)

WIth Toad not running, delete/rename your ToadActions.dat (this will clear out the Automation designer, so if you care about anything in there, you may wish to export the apps that you want to save and then re-import them after)

If problem persists, you can email me your XLS file (to john.dorlon@quest.com) and I’ll take a look.

-John