Fastload Logtable error

Tools & Utilities

Fastload Logtable error

Hi - I am trying to load to teradata using the fastload utility. As far as I can tell the command file is correct but I am getting an unusual error when I run it.

**** 11:51:00 No row found for this job in log table SYSADMIN.FASTLOG.

              BEGIN LOADING was successful, but there is no restart info.

              This job cannot be continued or restarted.

I have a tried searching, but I can't see any reference to this error anywhere. Does anyone know what it can be, and more importantly how to fix it?

Thanks

Mike

P.S. here is the script

------------------------------------------------

SESSIONS 4;

ERRLIMIT 25;

LOGON VIVALDI/username,password;

DATABASE MY_DB;

/* START IMPORTING FROM LINE 2 */ 

RECORD 2;

/* DATA IS DELIMITED BY A | */

SET RECORD VARTEXT "|";

DEFINE USER_ID (VARCHAR(50))

, COL0 (VARCHAR(255))

, COL1 (VARCHAR(255))

, COL2 (VARCHAR(255))

FILE=C:\Users\files\MYDATA.txt;

/* THE BELOW TABLE (my_data) ALREADY EXISTS */

BEGIN LOADING MY_DB.my_data

ERRORFILES MY_DB.my_data_ERR1, MY_DB.my_data_ERR2

CHECKPOINT 100000;

INSERT INTO MY_DB.my_data VALUES

(

:USER_ID

, :COL0

, :COL1

, :COL2

);

END LOADING;

LOGOFF;

--------------------------------------

Here is the full output in the command prompt

--------------------------------------

C:\fast>fastload.exe <fastload.txt

     ===================================================================

     =                                                                 =

     =          FASTLOAD UTILITY     VERSION 13.10.00.003              =

     =          PLATFORM WIN32                                         =

     =                                                                 =

     ===================================================================

     ===================================================================

     =                                                                 =

     =          Copyright 1984-2010, Teradata Corporation.             =

     =          ALL RIGHTS RESERVED.                                   =

     =                                                                 =

     ===================================================================

**** 11:50:24 Processing starting at: Wed Jun 20 11:50:23 2012

0001 SESSIONS 4;

**** 11:50:24 FDL4866 SESSIONS command accepted

0002 ERRLIMIT 25;

**** 11:50:24 Error limit set to: 25

     ===================================================================

     =                                                                 =

     =          Logon/Connection                                       =

     =                                                                 =

     ===================================================================

0003 LOGON VIVALDI/username,

**** 11:50:31 Teradata Database Release: 13.10.02.518

**** 11:50:31 Teradata Database Version: 13.10.02.518

**** 11:50:31 Current CLI or RDBMS allows maximum row size: 64K

**** 11:50:31 Character set for this job: ASCII

0004 DATABASE MY_DB;

**** 11:50:36 Command completed successfully

     /* START IMPORTING FROM LINE 2 */

0005 RECORD 2;

**** 11:50:36 Starting record number set to  : 2

     /* DATA IS DELIMITED BY A | */

0006 SET RECORD VARTEXT "|";

**** 11:50:36 Now set to read 'Variable-Length Text' records

**** 11:50:36 Delimiter character(s) is set to '|'

**** 11:50:36 Command completed successfully

0007 DEFINE USER_ID (VARCHAR(50))

                , COL0 (VARCHAR(255))

                , COL1 (VARCHAR(255))

                , COL2 (VARCHAR(255))

     FILE=C:\Users\files\MYDATA.txt;

**** 11:50:36 FDL4803 DEFINE statement processed

     /* THE BELOW TABLE (my_data) ALREADY EXISTS */

0008 BEGIN LOADING MY_DB.my_data

     ERRORFILES MY_DB.my_data_ERR1, MY_DB.my_data_ERR2

     CHECKPOINT 100000;

**** 11:50:45 Number of FastLoad sessions requested = 4

**** 11:50:45 Number of FastLoad sessions connected = 4

**** 11:50:45 FDL4808 LOGON successful

**** 11:51:00 No row found for this job in log table SYSADMIN.FASTLOG.

              BEGIN LOADING was successful, but there is no restart info.

              This job cannot be continued or restarted.

     ===================================================================

     =                                                                 =

     =          Logoff/Disconnect                                      =

     =                                                                 =

     ===================================================================

**** 11:51:00 Logging off all sessions

**** 11:51:06 Total processor time used = '0.421203 Seconds'

     .        Start : Wed Jun 20 11:50:23 2012

     .        End   : Wed Jun 20 11:51:06 2012

     .        Highest return code encountered = '12'.

**** 11:51:06 FDL4818 FastLoad Terminated

-----------------------------------

6 REPLIES
Teradata Employee

Re: Fastload Logtable error

This error is usually due to the Teradata Database telling FastLoad that the job is a restart, but there is no information in the FastLoad restart log table (SYSADMIN.FASTLOG) for that table.

Teradata keeps track if a table had already begun to be loaded by a FastLoad process.

-- SteveF
N/A

Re: Fastload Logtable error

try moving the begin loading statement 

BEGIN LOADING MY_DB.my_data

ERRORFILES MY_DB.my_data_ERR1, MY_DB.my_data_ERR2

CHECKPOINT 100000;

just after

DATABASE MY_DB;

Junior Supporter

Re: Fastload Logtable error

Hi Steve,

If i want to know if a table is locked by the fastload job/any fastload job is active on a source table, can i query SYSADMIN.FASTLOG for the presence of that source table ? I can see a field 'status' - with values 'loading init' in SYSADMIN.FASTLOG .  So, do i need to check for a specific status that would tell this fload is still active on a source table or just an entry in SYSADMIN.FASTLOG for a source table means that it is locked ?

I know i can do this by simply doing a count(*) from that table which would give me an error that the table is being loaded, but i want to know this without firing a query on that table ?

If you can direct me to any manual link that has more details on this, then that would be great.

thanks !

Samir

Teradata Employee

Re: Fastload Logtable error

Good Question!

I wish I could say with a definitive answer that you can query the restart log as the solution for determining which tables are locked by a FastLoad job.

However, I have seen cases where FastLoad jobs begin, fail for some reason, the user cleans up the tables, but not the restart log table.

Thus, I suppose in most cases, you can use the restart log table, but possibly not as the official list of all tables currently locked.

-- SteveF
Junior Supporter

Re: Fastload Logtable error

Thanks Sreve for the reply.

I will go ahead assuming an entry is there in the restart log tabale.

During the migration from Td 13 to Td 14, TD GSC uses a utility called checkpending(not sure of the actual name, but something like this) to see if any tables have mload/fload locks on them. Any idea which tables contain this info. Just out of curiosity.

--Samir

Teradata Employee

Re: Fastload Logtable error

They are not recorded in any DBC or SysAdmin table. CheckTable PendingOp inspects the table header to find these persistent utility locks.