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 "|"
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,
Start_Date DATE FORMAT 'YYYY-MM-DD',
End_Date DATE FORMAT 'YYYY-MM-DD',
UNIQUE PRIMARY INDEX M_Init_PI ( Initiative_ID);
/*SET RECORD VARTEXT "|";*/
FILE = C:\Users\...\Desktop\M_Init_initiatives.txt;
BEGIN LOADING TEMPDB.M_Init
INSERT INTO TEMPDB.M_Init
It gives the error and logs off but it says Fastload is paused?
How to fix?
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.
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
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.
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?
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).
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?