TPT19417 pmRead failed. Buffer overflow (17)

Tools

TPT19417 pmRead failed. Buffer overflow (17)

Hi,

 

I am getting this error upon running our TPT that uses a file.

 

TPT_DATACONNECTOR_OPERATOR[1]: TPT19417 pmRead failed. Buffer overflow (17)
TPT_DATACONNECTOR_OPERATOR[1]: TPT19305 Fatal error reading data.
TPT_DATACONNECTOR_OPERATOR[1]: TPT19015 TPT Exit code set to 12.
TPT_INFRA: TPT02255: Message Buffers Sent/Received = 0, Total Rows Received = 0, Total Rows Sent = 0
TPT_INFRA: TPT02255: Message Buffers Sent/Received = 2, Total Rows Received = 0, Total Rows Sent = 0
TPT_INFRA: TPT02255: Message Buffers Sent/Received = 0, Total Rows Received = 0, Total Rows Sent = 0
TPT_DATACONNECTOR_OPERATOR[1]: Total files processed: 0.
TPT_INFRA: TPT02255: Message Buffers Sent/Received = 1, Total Rows Received = 0, Total Rows Sent = 0
TPT_LOAD_OPERATOR: disconnecting sessions
TPT_LOAD_OPERATOR: Total processor time used = '0.628904 Second(s)'
TPT_LOAD_OPERATOR: Start : Wed Apr 5 20:44:51 2017
TPT_LOAD_OPERATOR: End : Wed Apr 5 20:45:01 2017
Job step LOAD_TABLES terminated (status 12)
Job LD00404_001_D_01 terminated (status 12)
Job start: Wed Apr 5 20:44:47 2017
Job end: Wed Apr 5 20:45:01 2017
Total available memory: 20000676
Largest allocable area: 20000676
Memory use high water mark: 2344676
Free map size: 1024
Free map use high water mark: 34
Free list use high water mark: 0

 

I understand thatTPT19015 TPT Exit code set to 12, can be the following:

Exit Code = 12
A fatal error terminated the job.
A fatal error is any error other than a user error, for example:
•Incompatible data types encountered during reading of data sources.
•Data errors exceeding the value specified in the ErrorLimit attribute.
•Insufficient system resources, such as shared memory or semaphores, to execute the job.

 

However, I want to know how to debug the job and trap the right issue among the suggested fatal errors.

Btw, we are using Global Control Framework and Teradata Parallel Transporter Version 15.10.01.02 32-Bit. Thank you!

2 REPLIES

Re: TPT19417 pmRead failed. Buffer overflow (17)

Latest Update:

We found out the issue yet we dont know how to fix it.

 

offset=165655
FileInfo->BufferSize=131072
FileInfo->BufferPosition=0
Not enough room in buffer for another record
!ERROR! rcode=17
!ERROR! returning rcode=17
Last RecCount=2094
RecCount=2094
Buffer->Data
Address provided is null, no data to display.
pmGetErrText entry <<<<
LastReturnCode=17
WARNING! pmRead rc=17
WARNING! 'Buffer overflow'
TPT Exit code set to 12.
Method PX_Terminate entry: Phase 1
**** 22:43:16 @@@@@ TERMINATE phase 1
Attribute 'SYSTEM_ExecutePassed' value is 'N'
Enter DC_UTIL_Term Phase 1
Closing file: 'Data File'
pmClose entry <<<<
Closing file=/prd/edm/CTRLFW/BTS/ALL/source_data/loading/BTS_ALL_INSTRUMENT_2017-04-04_000000.000000.DAT
closed via default paramod
Record count=2094
pmUnxDskClose entry <<<<
pmDetach entry <<<<
Detaching default Access Module
Method PX_Terminate entry: Phase 2
**** 22:43:16 @@@@@ TERMINATE phase 2
Attribute 'SYSTEM_ExecutePassed' value is 'N'
Files read by this instance: 0
**** 22:43:16 Total processor time used = '0.00 Seconds(s)'
Processing of file 'BTS_ALL_INSTRUMENT_2017-04-04_000000.000000.DAT' by instance 1 failed. Status is: still processing.
Total files processed in pass: 0
**** 22:43:16 Total files processed: 0
PX_DeleteGlobalVar rc 0 for 'DirInfo'
PX_DeleteGlobalVar rc 0 for 'FileNames'
CkptCount=2
Enter DC_UTIL_Term Phase 2
pmShutDown entry <<<<
Shutting down API
Exit code is 12
Closing logs

Teradata Employee

Re: TPT19417 pmRead failed. Buffer overflow (17)

What (exact) version of TPT are you running?

Can you please provide the script?

What format is the data? Delimited?

Does this error occur at the very beginning of the job? Some elapsed time in the middle of reading the file?

How large is the data file?

 

-- SteveF