Fastload error -- unable to obtain data signature

Tools
Enthusiast

Fastload error -- unable to obtain data signature

I am getting an error: I/O Error on File Checkpoint: 42, Text: Unable to obtain data signature Unexpected data format !ERROR! EOF encountered before expected EOR

I get this error when I run from the command window:

fastload < C:\Users\...\Desktop\M_Init_Fastload_DM.txt

 

I'm running via the command window as stated above. But strangely enough when I open up the Fastload window and run the same code -- it works.  The file is text delimited by "|"

 

 

**************************

SESSIONS 12;
ERRLIMIT 10;
  .logmech KRB5;
   .logon Teraprod/,;
DROP TABLE tempDB.M_Init_WORK_ERROR1;                                

 
DROP TABLE tempDB.M_Init_WORK_ERROR2;
DROP TABLE TEMPDB.M_Init;


CREATE SET TABLE tempdb.M_Init ,NO FALLBACK ,
     NO BEFORE JOURNAL,
     NO AFTER JOURNAL,
     CHECKSUM = DEFAULT
     (
      Initiative_ID CHAR(5) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,
      Initiative_Name Varchar(75),
      Start_Date DATE FORMAT 'YYYY-MM-DD',
      End_Date DATE FORMAT 'YYYY-MM-DD',
      Initiative_Type Int,
      Initiative_Rank Int)
UNIQUE PRIMARY INDEX M_Init_PI ( Initiative_ID);

 

/*SET RECORD VARTEXT "|";*/
   
DEFINE 
        M_Init_ID (varchar(50)),
        M_Init_Name (Varchar(75)),
        Start_Date (varchar(50)),
        End_Date (varchar(50)),
       M_Init_Type (varchar(50)),
        M_Init_Rank (varchar(50))


FILE =  C:\Users\...\Desktop\M_Init_initiatives.txt;


BEGIN LOADING TEMPDB.M_Init
  ERRORFILES TEMPDB.M_Init_WORK_ERROR1
            ,TEMPDB.M_Init_WORK_ERROR2;


INSERT INTO TEMPDB.M_Init
 (
        M_Init_ID,
        M_Init_Name,
        Start_Date,
        End_Date,
        M_Init_Type,
        M_Init_Rank
 

)
VALUES
 (
        :M_Init_ID,
        :M_Init_Name,
        :Start_Date,
        :End_Date,
        :M_Init_Type,
        :M_Init_Rank
);

END LOADING;
LOGOFF;

 

***********************************

 

It gives the error and logs off but it says Fastload is paused?

 

 

How to fix?

5 REPLIES
Teradata Employee

Re: Fastload error -- unable to obtain data signature

I am not sure what you mean by the "FastLoad window".

You do need to specify the SET RECORD command if you want to process the data as VARTEXT data.

You do not need to specify the delimiter character because FastLoad will use the '|' as the default.

-- SteveF
Enthusiast

Re: Fastload error -- unable to obtain data signature

Ok. So I added or uncommented out...

SET RECORD VARTEXT;

By "FastLoad Window" I mean actually opening up Fastload from the Start -->Teradata Client folder.

Currently I am using the cmd.exe window.  As I stated the SAME code works if I copy and past into the Fastload Window.  But the SAME code generates error in cmd window.

 

So now after adding back in SET RECORD VARTEXT;

 

But now I still get error message:

Error on piom GET ROW: 35, Text: EOF encountered before end of record

Fastload Paused

 

***

Now again I run this same code in the Program window or Fastload program window.  But when I run from the cmd window I get error -- as I started in previous post and the new error in this reply/post.

 

Any suggestions?

 

Enthusiast

Re: Fastload error -- unable to obtain data signature

Also I must add I am running Teradata 14.0

 

Are these types of errors some known bug in 14.0? What is a workaround?

Teradata Employee

Re: Fastload error -- unable to obtain data signature

Make sure the last record in the data file as an end-of-record marker (linefeed character, or carriage-return/linefeed, depending on the platform).

 

-- SteveF
Enthusiast

Re: Fastload error -- unable to obtain data signature

I opened the text file and deleted the last line to make sure there was no garbage at the end.  The fastload still didn't work.

I went back and totally regenerated the file again from scratch and that DID work.

 

Last question is how do I "un-pause" the job.  And have it terminate?  So that it won't lock up the database?  

 

In my earlier post the error message said that FastLoad is paused....

 

How to clear this up?