uty4015 error encountered - uploading text file thru multiload

Tools & Utilities
Enthusiast

uty4015 error encountered - uploading text file thru multiload

Hi All,
While i'm uploading a file to teradata thru Multiload I'm facing the following problem.

========================================================================
= =
= MultiLoad Acquisition Phase =
= =
========================================================================
**** 16:03:36 UTY0817 MultiLoad submitting the following request:
BEGIN TRANSACTION;
**** 16:03:36 UTY0817 MultiLoad submitting the following request:
CHECKPOINT LOADING;
**** 16:03:36 UTY0817 MultiLoad submitting the following request:
CHECKPOINT LOADING;
**** 16:03:37 UTY0817 MultiLoad submitting the following request:
USING Ckpt(VARBYTE(1024)) INSERT kmr.l_t1 (Logtype, Seq, MLoadSeq,
MLoadImpSeq, MLoadSrcSeq, MiscInt1,MiscInt2,MiscInt3,MiscInt4,
MiscInt5,MiscInt6,MiscInt7,MiscInt8,MLoadCkpt) VALUES (110, 1, 0, 1, 0, 0,
0, 0, 0, 0, 0, 0, 0, :Ckpt);
**** 16:03:37 UTY4015 Access module error '35' received during 'read' operation
on record
number '1': 'EOF encountered before end of record'
**** 16:03:37 UTY1803 Import processing statistics
. IMPORT 1 Total thus far
. ========= ==============
Candidate records considered:........ 1....... 1
Apply conditions satisfied:.......... 1....... 1
Candidate records not applied:....... 0....... 0
Candidate records rejected:.......... 0....... 0
========================================================================
= =
= Logoff/Disconnect =
= =
========================================================================
**** 16:03:37 UTY6212 A successful disconnect was made from the RDBMS.
**** 16:03:37 UTY2410 Total processor time used = '0.09375 Seconds'
. Start : 16:03:33 - TUE DEC 12, 2006
. End : 16:03:37 - TUE DEC 12, 2006
. Highest return code encountered = '12'.

my script is

.logtable kmr.l_t1;
.logon demotdat/bmk,mkb;
.begin import mload tables new_abc
worktables w_t1
errortables e_t1
u_t1
errlimit 1000
ampcheck all;
.layout inputlayout;
.Field md * varchar(11);
.Field mc *varchar(11);
.Field dte *varchar(11);
.Field acct *varchar(11);
.dml label inserts;
insert into new_abc (md, mc, dte, acct ) values( :md, :mc, :dte,:acct );
.import infile D:\l1.txt
format vartext ' | '
layout inputlayout
apply inserts;
.end Mload;
.logoff;

and my input file is

abc | def | 011106 | 1001
lmn | opq | 011106 | 1001

regards,
Mohan
6 REPLIES
Enthusiast

Re: uty4015 error encountered - uploading text file thru multiload

I have a feeling that the VARCHAR, when chanegd to CHAR will make a difference.

Just try it out and if it dont work, dont scream at me. )

Regards
Varun R
Teradata Employee

Re: uty4015 error encountered - uploading text file thru multiload

The delimiter must be a single character. And since you are on Windows, each record (including the last) must end with CR/LF combination.
Enthusiast

Re: uty4015 error encountered - uploading text file thru multiload

Access modules errors usually showup if there is a outage of the file server from where MLOAD is reading the file.

Try rerunning the job and ensure that there is connectivity to the file server.

I think it should run successfully.

Vinay
Enthusiast

Re: uty4015 error encountered - uploading text file thru multiload

Multiload expects a CR as an EOF.
So after every file or pipe a CR/LF has to be placed for the multiload to know
the EOF

Enthusiast

Re: uty4015 error encountered - uploading text file thru multiload

If you are using a text file which is not created by fastexport then use FORMAT Vartext 'Delimiter' after the .Import Infile command ..

* if delimiter is a tab just put a tab etc.

Re: uty4015 error encountered - uploading text file thru multiload

I am facing an error in TPUMP while reading the data

**** 17:24:58 UTY6608 Import 1 begins.
**** 17:24:58 UTY4015 Access module error '17' received during 'read' operation on record
number '28': 'Buffer overflow'

please help me

Regards
Dilip