All Forums Tools
krishna1985 13 posts Joined 08/16
25 Aug 2016
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;
 
 

Regards, Hari Krishna
Ivyuan 63 posts Joined 01/10
29 Aug 2016

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!

krishna1985 13 posts Joined 08/16
31 Aug 2016

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.

Regards,
Hari Krishna

You must sign in to leave a comment.