Toad World® Forums

strange error


#1

It may be my PC or something but I had something go afoul while trying to Import
some table data.

When I try to exit and restart I get a message that says “Import in progress,
wait for it to finish or Cancel”

How do I cancel? It will not let me shut down toad.


#2

I think you’ll just have to kill it. It sounds like it thinks it is still
running but it isn’t. If you can let me know how I can reproduce the
problem I’ll try to fix it.


#3

i HAD TO KILL IT WITH WINDOWS TASK MANAGER.

What I was doing was importing data from 17 excel spreadsheets… one at a
time… approx 1000 records per file

I did a commit after each one… but

I tried to get fancy and not close and reopen the import table data wizzard
between files…

Another thing it does is sometimes when you select the excel file and it first
shows you the data…

that’s blank sometime…

fir example my version of toad only suports excel 2003… the files were sent
to me in excel 2007.

I save them as excel 2003s’ but sometime if I forget it can’t read the
excel 2007 file.

To make sure that did not happen again… I converted them all first.

On Thu, Dec 2, 2010 at 11:46 AM, John Dorlon wrote:

I think you’ll just have to kill it.   It sounds like it thinks it is
still running but it isn’t.   If you can let me know how I can reproduce
the problem I’ll try to fix it.

#4

What version of Toad do you have? When you say 2003 and 2007, you are referring
to .xls and .xlsx files, is that right?


#5

9.1

and yes you are correct abput the .xls and .xlsx files.

I just loaded one file,

commited,

closed the wizzard,

tried to load another,

It could recognize the file and shut down/crashed on its own.

On Thu, Dec 2, 2010 at 12:29 PM, John Dorlon wrote:

What version of Toad do you have?   When you say 2003 and 2007, you are
referring to .xls and .xlsx files, is that right?

#6

OK. I’ll test on the current version with some random error and just make
sure it’s handled gracefully. That’s about all I can do…


#7

It now crashes every time after doing just one.

I do see the option to import .xlsx files (excel 12) once you actually pick the
file from the directory… I am going to reboot my machine in the process.

On Thu, Dec 2, 2010 at 12:42 PM, John Dorlon wrote:

OK.   I’ll test on the current version with some random error and just
make sure it’s handled gracefully.   That’s about all I can do…

#8

Oops - you are right. 9.1 should handle xlsx. If you have a particular file that
causes problems, please send it to me (along with table DDL) and I will test it
in the current version.


#9

Now I am getting invalid pointer, and

Access violation at address 00404EBC in module ‘toad.exe’. Read of
address 7373655F.

we all get the 2nd one a lot from time to time…

What I am havibng to do is load one file, commit, shutdown toad and restart.

Even that does not help sometimes.

On Thu, Dec 2, 2010 at 1:13 PM, John Dorlon wrote:

Oops - you are right.   9.1 should handle xlsx.   If you have a particular
file that causes problems, please send it to me (along with table DDL) and I
will test it in the current version.

#10

I think I may have fixed it.

  1. I clear the wizzard settings every time

  2. I moved the files closer to root level.

old location c:\documents And Settings\MyDocuments\Dr Brown Report Server\degree
files\converted to XL03\

new location:c:\degree files moved\

Did not have any more problems.

On Thu, Dec 2, 2010 at 1:13 PM, John Dorlon wrote:

Oops - you are right.   9.1 should handle xlsx.   If you have a particular
file that causes problems, please send it to me (along with table DDL) and I
will test it in the current version.