TPT ERROR - General failure (34): 'pmunxRBuf: 'tell' error (Value too large to be stored in data type.)'

Tools & Utilities
Highlighted

TPT ERROR - General failure (34): 'pmunxRBuf: 'tell' error (Value too large to be stored in data type.)'

Hi All,

When running the TPT scripts for loading a 12GB files into loaded table, scripts faing with below error message, where as if same scripts ran sucessfully with few 10000 records.

Teradata Parallel Transporter Version 12.00.00.00
Execution Plan generation started.
Execution Plan generation successfully completed.
Job log: /usr/tbuild/12.00.00.00/logs/test_load-1.out
Job id is test_load-1, running on a01faif1a
Teradata Parallel Transporter DataConnector Version 12.00.00.00
FILE_READER: Instance 1 directing private log report to 'FILE_READER_LOG-1'.
FILE_READER: DataConnector Producer operator Instances: 3
FILE_READER: Instance 2 directing private log report to 'FILE_READER_LOG-2'.
FILE_READER: Instance 3 directing private log report to 'FILE_READER_LOG-3'.
Teradata Parallel Transporter Update Operator Version 12.00.00.00
UPDATE_OPERATOR: private log specified: Target_updated.log-1
FILE_READER: Operator instance 1 processing file '/stage/bdw/nrd/ AGREEMENT_BALANCE_HIST_20500.dat_I_U'.
UPDATE_OPERATOR: connecting sessions
UPDATE_OPERATOR: preparing target table(s)
UPDATE_OPERATOR: entering DML Phase
UPDATE_OPERATOR: entering Acquisition Phase
FILE_READER: pmRead failed. General failure (34): 'pmunxRBuf: 'tell' error (Value too large to be stored in data type.)'
FILE_READER: Fatal error reading data.
Operator(libdataconop.so) instance(1): EXECUTE method failed with status = Fatal Error
FILE_READER: Total files processed: 0.
UPDATE_OPERATOR: disconnecting sessions
Job step TARGET_UPADATE_INSERT terminated (status 8)
Job test_load terminated (status 8)
4 REPLIES
Teradata Employee

Re: TPT ERROR - General failure (34): 'pmunxRBuf: 'tell' error (Value too large to be stored in data type.)'

Hi Sapsanju,

Have you found the solution for your problem?

Teradata Employee

Re: TPT ERROR - General failure (34): 'pmunxRBuf: 'tell' error (Value too large to be stored in data type.)'

Technically, we do not support TPT 12.00 anymore.

Having said that, I have tried looking into which version we began supporting file sizes larger than 2GB.

One thing I see, though, is that you are using a very old version of TPT (12.00.00.00 is the GCA version). We are always providing bug fixes and new enhancements in patches, and so prior to reporting an error, the very first thing you should do is make sure your release is up to date.

Therefore, you need to go to the patch server and download the latest patches for TPT 12.00. Then, try your test again.

(Engineers are on vacation this week and most of next, and so I will not be getting an answer about the >2GB file limit support for a while.)

-- SteveF
Teradata Employee

Re: TPT ERROR - General failure (34): 'pmunxRBuf: 'tell' error (Value too large to be stored in data type.)'


Hi Feinholz,

Thanks for the reply. I didn't realized that the question asked by Sapsanju is pertaining to TD 12. 

In my environment, I am using TTU / TPT 13.10 on an AIX box. However the TD Database is version 14. The version of the TPT components that I have installed is as per below which is the latest version that I have downloaded from our Teradata software server. 

cliv2 [Teradata CLIv2  13.10.00.12]

pexpda00  [Teradata Parallel Transporter Export Operator  13.10.00.06]

plodda00   [Teradata Parallel Transporter Load Operator 13.10.00.04]

pstmda00  [Teradata Parallel Transporter Stream Operator 13.10.00.07]

pupdda00  [Teradata Parallel Transporter Update Operator 13.10.00.04]

papida00   [Teradata Parallel Transporter API 13.10.00.07]

TeraGSS     [Teradata GSS client  13.10.00.03]

tdicu1310  [Teradata ICU 13.10.00.00]

tbldda00   [Teradata Parallel Transporter Load Operator tbldda00_aix_power.13.10.00.02] >> I can't find a patch for this.

But still I am getting the same error as Sapsanju. Below is the exact error that I am getting which I hope you could shed some light. [ Have been struggling day and night to get this work]

Teradata Parallel Transporter Version 13.10.00.02

Job log: /tmp/tptlogs/logs/stg_cif_cifaddr-18.out

Job id is stg_cif_cifaddr-18, running on redwuatetl

Found CheckPoint file: /tmp/tptlogs/checkpoint/stg_cif_cifaddrLVCP

This is a restart job; it restarts at step SETUP_TABLES.

Teradata Parallel Transporter SQL DDL Operator Version 13.10.00.02

DDL_OPERATOR: private log specified: ddlLog

DDL_OPERATOR: connecting sessions

DDL_OPERATOR: sending SQL requests

DDL_OPERATOR: TPT10508: RDBMS error 3807: Object 'EUAT1T_WRK.STG_CIF_CIFADDR_LOG' does not exist.

DDL_OPERATOR: TPT18046: Warning: error is ignored as requested in ErrorList

DDL_OPERATOR: TPT10508: RDBMS error 3807: Object 'EUAT1T_WRK.STG_CIF_CIFADDR_ET' does not exist.

DDL_OPERATOR: TPT18046: Warning: error is ignored as requested in ErrorList

DDL_OPERATOR: TPT10508: RDBMS error 3807: Object 'EUAT1T_WRK.STG_CIF_CIFADDR_UV' does not exist.

DDL_OPERATOR: TPT18046: Warning: error is ignored as requested in ErrorList

DDL_OPERATOR: TPT10508: RDBMS error 3807: Object 'EUAT1T_WRK.STG_CIF_CIFADDR_WT' does not exist.

DDL_OPERATOR: TPT18046: Warning: error is ignored as requested in ErrorList

DDL_OPERATOR: Rows Deleted:  0

DDL_OPERATOR: disconnecting sessions

DDL_OPERATOR: Total processor time used = '0.017587 Second(s)'

DDL_OPERATOR: Start : Thu Dec 27 15:27:22 2012

DDL_OPERATOR: End   : Thu Dec 27 15:27:22 2012

Job step SETUP_TABLES completed successfully

Teradata Parallel Transporter DataConnector Version 13.10.00.02

Teradata Parallel Transporter Load Operator Version 13.10.00.04

LOAD_OPERATOR: private log not specified

DATACONNECTOR_OPERATOR Instance 1 directing private log report to 'DATACONN-1'.

DATACONNECTOR_OPERATOR: TPT19008 DataConnector Producer operator Instances: 1

DATACONNECTOR_OPERATOR: TPT19003 ECI operator ID: DATACONNECTOR_OPERATOR-24379428

LOAD_OPERATOR: connecting sessions

DATACONNECTOR_OPERATOR: TPT19222 Operator instance 1 processing file '/redw/data/rawsource/cif_cifaddr_2012-10- 31_000000.000000.dat'.

LOAD_OPERATOR: preparing target table

LOAD_OPERATOR: entering Acquisition Phase

DATACONNECTOR_OPERATOR: TPT19104 VARCHAR field length error in column 2 .  Received 18 (max 4) on record 1.

DATACONNECTOR_OPERATOR: TPT19104 VARCHAR field length error in column 14 .  Received 5 (max 1) on record 761284.

DATACONNECTOR_OPERATOR: TPT19104 VARCHAR field length error in column 14 .  Received 5 (max 1) on record 900430.

DATACONNECTOR_OPERATOR: TPT19104 VARCHAR field length error in column 14 .  Received 5 (max 1) on record 1184431.

DATACONNECTOR_OPERATOR: TPT19109 Data Schema Column count (34) conflicts with columns received (35) in record 1297226.

DATACONNECTOR_OPERATOR: TPT19109 Data Schema Column count (34) conflicts with columns received (54) in record 1499366.

DATACONNECTOR_OPERATOR: TPT19109 Data Schema Column count (34) conflicts with columns received (54) in record 1499366.

DATACONNECTOR_OPERATOR: TPT19104 VARCHAR field length error in column 19 .  Received 5 (max 4) on record 1728344.

DATACONNECTOR_OPERATOR: TPT19104 VARCHAR field length error in column 19 .  Received 5 (max 4) on record 2550627.

DATACONNECTOR_OPERATOR: TPT19104 VARCHAR field length error in column 19 .  Received 5 (max 4) on record 2655661.

DATACONNECTOR_OPERATOR: TPT19109 Data Schema Column count (34) conflicts with columns received (35) in record 2913158.

DATACONNECTOR_OPERATOR: TPT19109 Data Schema Column count (34) conflicts with columns received (44) in record 2969048.

DATACONNECTOR_OPERATOR: TPT19104 VARCHAR field length error in column 14 .  Received 5 (max 1) on record 3197246.

DATACONNECTOR_OPERATOR: TPT19104 VARCHAR field length error in column 6 .  Received 43 (max 40) on record 4064438.

DATACONNECTOR_OPERATOR: TPT19104 VARCHAR field length error in column 14 .  Received 5 (max 1) on record 4326948.

DATACONNECTOR_OPERATOR: TPT19104 VARCHAR field length error in column 16 .  Received 14 (max 3) on record 4410549.

DATACONNECTOR_OPERATOR: TPT19104 VARCHAR field length error in column 14 .  Received 5 (max 1) on record 4624655.

DATACONNECTOR_OPERATOR: TPT19104 VARCHAR field length error in column 14 .  Received 5 (max 1) on record 7016461.

DATACONNECTOR_OPERATOR: TPT19104 VARCHAR field length error in column 14 .  Received 5 (max 1) on record 7411075.

DATACONNECTOR_OPERATOR: TPT19104 VARCHAR field length error in column 14 .  Received 5 (max 1) on record 7869512.

DATACONNECTOR_OPERATOR: TPT19104 VARCHAR field length error in column 14 .  Received 5 (max 1) on record 7935973.

DATACONNECTOR_OPERATOR: TPT19104 VARCHAR field length error in column 5 .  Received 42 (max 40) on record 8199010.

DATACONNECTOR_OPERATOR: TPT19104 VARCHAR field length error in column 7 .  Received 43 (max 40) on record 8507472.

DATACONNECTOR_OPERATOR: TPT19104 VARCHAR field length error in column 14 .  Received 5 (max 1) on record 8520960.

DATACONNECTOR_OPERATOR: TPT19104 VARCHAR field length error in column 4 .  Received 41 (max 40) on record 8575512.

DATACONNECTOR_OPERATOR: TPT19104 VARCHAR field length error in column 4 .  Received 41 (max 40) on record 8576154.

DATACONNECTOR_OPERATOR: TPT19104 VARCHAR field length error in column 14 .  Received 5 (max 1) on record 10290213.

DATACONNECTOR_OPERATOR: TPT19104 VARCHAR field length error in column 14 .  Received 5 (max 1) on record 11280828.

DATACONNECTOR_OPERATOR: TPT19104 VARCHAR field length error in column 14 .  Received 5 (max 1) on record 11715860.

DATACONNECTOR_OPERATOR: TPT19104 VARCHAR field length error in column 14 .  Received 5 (max 1) on record 12195226.

DATACONNECTOR_OPERATOR: TPT19104 VARCHAR field length error in column 14 .  Received 5 (max 1) on record 12580187.

DATACONNECTOR_OPERATOR: TPT19350 I/O error on file '/redw/data/rawsource/cif_cifaddr_2012-10- 31_000000.000000.dat'.

LOAD_OPERATOR: disconnecting sessions

DATACONNECTOR_OPERATOR: TPT19434 pmRead failed. General failure (34): 'pmunxRBuf: 'tell' error (Value too large to be stored in data type.)'

DATACONNECTOR_OPERATOR: TPT19305 Fatal error reading data.

DATACONNECTOR_OPERATOR: TPT19221 Total files processed: 0.

LOAD_OPERATOR: Total processor time used = '3.02677 Second(s)'

LOAD_OPERATOR: Start : Thu Dec 27 15:27:22 2012

LOAD_OPERATOR: End   : Thu Dec 27 15:28:07 2012

Job step LOAD_TABLES terminated (status 12)

Job stg_cif_cifaddr terminated (status 12)

I have isolated the record 12580187 that is giving the problem by loading that particular record into the database. There was no issue found. 

Note: The total record of the data file is 20,528,460 records (  2.138 GB in size = 2,241,942,917 bytes). I have chopped the file into 12 million and 13 million record separately, they all get loaded successfully. However, when i chopped the file so that it only contains 14 million records, the same error occured but at a different record i.e. 12,935,766 instead of the previous record 12,580,187. Therefore, I have reason to believe it is not a data problem.

Does version 13.10 also has the >2GB file limit as well? Is there a workround or patches to solve this?

Teradata Employee

Re: TPT ERROR - General failure (34): 'pmunxRBuf: 'tell' error (Value too large to be stored in data type.)'

Finally, my problem has been solved. 

The problem is with the "tbldda00" components. As the ETL server that my client is using is a 64 bit AIX server, i have downloaded all the patches for 64 bit from the teradata software server. 

However, the patch for the "tbldda00" is only listed in the 32 bit section and hence it was missed out from my download list.

Now that I have updated the "tbldda00" components to the latest version 13.10.00.12 (I didn't realized this could also be applied to a 64 bit server as well), the error didn't occur again and the load has been successful.