TOAD crashes on excel table import

vatro · May 14, 2018, 5:41am

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 |

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

vatro · May 14, 2018, 5:43am

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

JohnDorlon · May 14, 2018, 5:56am

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

khatriankeshanju · January 29, 2019, 3:32pm

Hi Team,

I am importing bulk excel data in oracle using toad but unfortunately my toad is getting crash though using the higher version (12.8) of toad. Below is screenshot i have attached.

khatriankeshanju · January 29, 2019, 3:35pm

Please check your mail I have mailed you.

JohnDorlon · January 30, 2019, 12:30pm

For anyone who may be reading this - Kkhatriankeshanju and I exchanged several emails. It turns out there was some kind of corruption in his excel file. After cutting/pasting the data to a new file in Excel, the new file was imported without errors. Also, another workaround in cases like this is to save your Excel file as CSV and then import the CSV file in Toad using the “Import from Text” option.

khatriankeshanju · February 28, 2019, 3:20pm