Import table not responding

Teradata Studio

Import table not responding

Not sure how long to wait when asking Studio to import a 9 million row text file.

I was able to load 2 million rows, and in that case when I hit "FINISH" it hour-glassed for a few minutes, then gave the window showing the progress until completion (about 10 minutes total).

But on the 9 million, I get that preliminary hour glass, and after 30 minutes it is still there. 

And the message in the loading window is "Load Data Wizard (Not Responding)".

I'm not sure if this is normal, and I just need to wait an hour or two until the actual loading starts, or if there is some limitation, and I need to break the load into multiples, or maybe one format works better than another.

The file is .txt tab delimited, and only two varchar(40) columns.


Accepted Solutions
Teradata Employee

Re: Import table not responding

The problem was fixed in Studio 15.10. 

1 ACCEPTED SOLUTION
4 REPLIES

Re: Import table not responding

OK, the "Transfer Progress View" just popped onto the screen, so apparently Studio does a preliminary scan of the txt file prior to starting loading, and during this preliminary scan it shows as "Not Responding".  Now Studio is running again.

Teradata Employee

Re: Import table not responding

What version of Studio are you using? We had a load scanning issue that was fixed in recent version.

Re: Import table not responding

Version 15.0

Teradata Employee

Re: Import table not responding

The problem was fixed in Studio 15.10.