All Forums Tools
ubya308 4 posts Joined 05/11
20 Jun 2012
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

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

feinholz 1234 posts Joined 05/08
28 Jun 2012

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

td4007 1 post Joined 11/12
20 Nov 2012

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;

teradatauser2 236 posts Joined 04/12
17 Mar 2015

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

feinholz 1234 posts Joined 05/08
17 Mar 2015

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

teradatauser2 236 posts Joined 04/12
19 Mar 2015

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

Fred 1096 posts Joined 08/04
20 Mar 2015

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

You must sign in to leave a comment.