All Forums Tools
bmkumar 8 posts Joined 11/06
12 Dec 2006
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' operationon 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_abcworktables w_t1errortables e_t1u_t1errlimit 1000ampcheck 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.txtformat vartext ' | ' layout inputlayout apply inserts;.end Mload;.logoff;and my input file isabc | def | 011106 | 1001 lmn | opq | 011106 | 1001 regards,Mohan

Thanks & Regards, B Mohan Kumar Teradata Certified Master

varun2102 37 posts Joined 12/06
12 Dec 2006

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. )RegardsVarun R

Fred 1096 posts Joined 08/04
12 Dec 2006

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

BBR2 96 posts Joined 12/04
20 Dec 2006

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

jndrfq 5 posts Joined 08/06
10 Jan 2007

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

--
jndrfq

jndrfq 5 posts Joined 08/06
03 Apr 2007

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.

--
jndrfq

dilip_023 3 posts Joined 03/10
30 Mar 2010

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

You must sign in to leave a comment.