MULTILOAD BUFFER ERROR!!! urgent

Tools

MULTILOAD BUFFER ERROR!!! urgent

Hi All,

I am trying to load the 8 mil rows into the target table and when I try to insert into target table then I get the below issue

* 16:46:18 UTY1802 Processing Import Sequence 1, Source Sequence 800000.

* 16:46:22 UTY4014 Access module error '17' received during 'pmReadDDparse'

  operation: 'Buffer overflow !ERROR! Not enough room in buffer for another

  record offset=65742 BufferSize=65536 BufferPosition=0'

* 16:46:22 UTY1803 Import processing statistics

  .                                       IMPORT  1     Total thus far

  .                                       =========     ==============

  Candidate records considered:........      884301.......      884301

  Apply conditions satisfied:..........      884301.......      884301

  Candidate records not applied:.......           0.......           0

  Candidate records rejected:..........           0.......           0

* 16:46:22 UTY1821 Aquisition Phase statistics

  Elapsed time:  00:01:03

  CPU time:      15.5 Seconds

  MB/sec:        3.96839

  MB/cpusec:     16.1296

  ====================================================== ==================

 

Is there any why I can increase the buffer size or avoid the error. My Mload script is as below or can I get TPT scrip for the same...appreciate your time....thanks again

 

 

 

.BEGIN MLOAD TABLES UDRBSCMS.BW_CPS_VOL_EXTR_STG SESSIONS 5 ;

.LAYOUT BW_CPS_VOL_EXTR;

 

.FIELD      D_VOL_IN_DT * VARCHAR (300);

.FIELD      D_VOL_OUT_DT * VARCHAR (300);

.FIELD      ACTION_DATE * VARCHAR (300);

.FIELD      CASE_CREATION_DATE * VARCHAR (300);

.FIELD      CSE_ID * VARCHAR (300);

.FIELD      CASE_ID * VARCHAR (300);

.FIELD      PTS_ID * VARCHAR (300);

.FIELD      COMPLETED_TASK  *  VARCHAR (300);

.FIELD      COMPLETED_PRC  *  VARCHAR (300);

.FIELD      TASK_GROUP_NAME  *  VARCHAR (300);

.FIELD      USR_ID* VARCHAR (300);

.FIELD      USER_NAME  *  VARCHAR (300);

.FIELD      USER_GROUP  *  VARCHAR (300);

.FIELD      CPS_SYSTEM_USER  *  VARCHAR (300);

.FIELD      CPS_ACTION  *  VARCHAR (300);

.FIELD      WAC_ID* VARCHAR (300);

.FIELD      WAC_DESC  *  VARCHAR (300);

.FIELD      NEXT_PTS_ID* VARCHAR (300);

.FIELD      NEXT_TASK  *  VARCHAR (300);

.FIELD      NEXT_PRC  *  VARCHAR (300);

.FIELD      NEXT_TEAM  *  VARCHAR (300);

.FIELD      CASE_ACTIVE  *  VARCHAR (300);

.FIELD      LENDNET_SEND  *  VARCHAR (300);

.FIELD      RN * VARCHAR(300) ;

 

.DML LABEL INS;

 

INSERT INTO UDRBSCMS.BW_CPS_VOL_EXTR_STG

(

  D_VOL_IN_DT ,

      D_VOL_OUT_DT ,

      ACTION_DATE ,

      CASE_CREATION_DATE ,

      CSE_ID ,

      CASE_ID ,

      PTS_ID ,

      COMPLETED_TASK   ,

      COMPLETED_PRC   ,

      TASK_GROUP_NAME   ,

      USR_ID,

      USER_NAME   ,

      USER_GROUP   ,

      CPS_SYSTEM_USER   ,

      CPS_ACTION   ,

      WAC_ID,

      WAC_DESC   ,

      NEXT_PTS_ID,

      NEXT_TASK  ,

      NEXT_PRC   ,

      NEXT_TEAM   ,

      CASE_ACTIVE   ,

      LENDNET_SEND   ,

      RN )

VALUES

(

:  D_VOL_IN_DT ,

:      D_VOL_OUT_DT ,

:      ACTION_DATE ,

:      CASE_CREATION_DATE ,

:      CSE_ID ,

:      CASE_ID ,

:      PTS_ID ,

:      COMPLETED_TASK   ,

:      COMPLETED_PRC   ,

:      TASK_GROUP_NAME   ,

:      USR_ID,

:      USER_NAME   ,

:      USER_GROUP   ,

:      CPS_SYSTEM_USER   ,

:      CPS_ACTION   ,

:      WAC_ID,

:      WAC_DESC   ,

:      NEXT_PTS_ID,

:      NEXT_TASK  ,

:      NEXT_PRC   ,

:      NEXT_TEAM   ,

:      CASE_ACTIVE   ,

:      LENDNET_SEND   ,

:      RN

 );

IMPORT INFILE 'BW_CPS_VOLUME_EXTRACT.txt'  

FORMAT VARTEXT ' '

 

LAYOUT BW_CPS_VOL_EXTR

 

APPLY INS;

.END MLOAD;

LOGOFF;

 

 

2 REPLIES
Teradata Employee

Re: MULTILOAD BUFFER ERROR!!! urgent

Hi,

1. Can you let us know the MultiLoad version and the Teradata Data Connector version? The Data Connector version could be obtained by issuing a ".version;" command using MultiLoad.

The version will be listed after "PMVER = Teradata Data Connector, "

2. Can you send us the data row which possibly caused this error? Could be around 884301.

  Apply conditions satisfied:..........      884301.......      884301

3. Yes, you can use TPT.

Thanks!

Re: MULTILOAD BUFFER ERROR!!! urgent

Hi Ivyuan,

thanks for getting back to me. Acutally there was issue with the tab space. we had extra tab hence the column got shifted to other and so forth...now its resolvd.