Error in FastLoad Script

Tools
Enthusiast

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 (1)
4 REPLIES
Teradata Employee

Re: Error in FastLoad Script

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

Teradata Employee

Re: Error in FastLoad Script

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

Enthusiast

Re: Error in FastLoad Script

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.

Enthusiast

Re: Error in FastLoad Script

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.