Getting error on Fastload..."nvalid state for Load"

Tools
Enthusiast

Getting error on Fastload..."nvalid state for Load"

Hi ,

I am getting the following error when doing a fast load.

**** 15:21:00 RDBMS error 2635: Error tables are invalid OR
TFL_SALE is in an invalid state for Load

does this mean the is a fastload lock on the table.

Need help in solving this...

Thanks
Nick
4 REPLIES
Teradata Employee

Re: Getting error on Fastload..."nvalid state for Load"

Apparently, you are attempting to re-run or resubmit a job that terminated previously for some reason.
Please provide more detailed information about this so that I can help you out.
The table exists for some reason.
It is locked because a job was loading it.
But the failure could be something as simple as this new job specifying incorrect error table names.
-- SteveF
Enthusiast

Re: Getting error on Fastload..."nvalid state for Load"

My job failed leaving the loading table, ET and UV tables locked. The ET and UV tables were accidently droped. After that when the fastload was run on the same table (which is still locked), this error was returned.

Enthusiast

Re: Getting error on Fastload..."nvalid state for Load"

Ali--you can try doing a fast load after dropping and rebuilding the target table(the one which was locked).

Teradata Employee

Re: Getting error on Fastload..."nvalid state for Load"

Yes, once the error tables are dropped, the job must start from the beginning, meaning you must drop and recreate the target table.

-- SteveF