All Forums Tools
28 Feb 2014
Error in FastLoad Script

Hi All,
 
Below is the script for the fastload:
.LOGON home/jbhatt,jugal;
BEGIN LOADING DB.tables1
ERRORFILES ERR1,ERR2;
DEFINE col1 (VARCHAR(50)),
        col2 (VARCHAR(50)) 
FILE= /home/jugal/finsert.txt;
insert into DB.tables1 values(:col1,:col2);
END LOADING;
LOGOFF;
 When i ran the script i got the below error in the logs:
  ====================================================== =============
     =                                                                 =
     =          FASTLOAD UTILITY     VERSION 14.00.00.07               =
     =          PLATFORM LINUX                                         =
     =                                                                 =
     ====================================================== =============
     ====================================================== =============
     =                                                                 =
     =          Copyright 1984-2012, Teradata Corporation.             =
     =          ALL RIGHTS RESERVED.                                   =
     =                                                                 =
     ====================================================== =============
**** 10:25:58 Processing starting at: Fri Feb 28 10:25:58 2014
     ====================================================== =============
     =                                                                 =
     =          Logon/Connection                                       =
     =                                                                 =
     ====================================================== =============
0001 .LOGON home/Jbhatt,
**** 10:25:59 Teradata Database Release: 14.00.05.02
**** 10:25:59 Teradata Database Version: 14.00.05.03
**** 10:25:59 Number of AMPs available: 96
**** 10:25:59 Current CLI or RDBMS allows maximum row size: 64K
**** 10:25:59 Character set for this job: ASCII

0002 BEGIN LOADING DB.tables1
     ERRORFILES ERR1,ERR2;
**** 10:25:59 Session count 16 returned by the DBS overrides
              user-requested session count
**** 10:26:03 Number of FastLoad sessions connected = 16
**** 10:26:03 FDL4808 LOGON successful
**** 10:26:03 FastLoad is continuing a multifile job
**** 10:26:03 Number of AMPs available: 96
**** 10:26:03 BEGIN LOADING COMPLETE
0003 DEFINE col1 (VARCHAR(50)),
             col1 (VARCHAR(50))
     FILE= /home/jugal/finsert.txt;
**** 10:26:03 FDL4803 DEFINE statement processed
     ====================================================== =============
     =                                                                 =
     =          Insert Phase                                           =
     =                                                                 =
     ====================================================== =============
0004 insert into DB.tables1 values(:col1,:col2);
**** 10:26:03 I/O Error on File Checkpoint: 42, Text: Unable to obtain
              data signature Unexpected data format !ERROR! EOF
              encountered before expected EOR
     ====================================================== =============
     =                                                                 =
     =          Logoff/Disconnect                                      =
     =                                                                 =
     ====================================================== =============
**** 10:26:03 Logging off all sessions
**** 10:26:05 Total processor time used = '1.86 Seconds'
     .        Start : Fri Feb 28 10:25:58 2014
     .        End   : Fri Feb 28 10:26:05 2014
     .        Highest return code encountered = '12'.
**** 10:26:05 FastLoad Paused
I think i am not inserting the data from the test properly.
Please Help me with the error.

Tags:
SuSeSi 61 posts Joined 10/08
03 Mar 2014

Check once if you are using recent version of piom (dataconnector).
 

-Sudhansu

ThomasNguyen 30 posts Joined 04/09
03 Mar 2014

Also, check your data file, make sure the data records are in FastLoad format and in the endian of the test machine.

krishaneesh 140 posts Joined 04/13
03 Mar 2014

From the error it appears that there is an issue with the source file /home.jugal/finsert.txt. The error says that there is a unexpected data format or a control character in an unexpected position.
Also i do not see a SET RECORD command in the script. is it a formatted text or a vartext with the two columns separated by a separator(,| etc..). Inspect the file and verify.

04 Mar 2014

Hi Guys,
Thanks for the response. Yes. The error is relating to EOF(End of File), which more relates to source input.
This is the 1st time im running fastload script.
Following is the format give in the source file:
1001 1232
I have given it in the format which is used to give in Fast Export using .ACCEPT command.

You must sign in to leave a comment.