TPT - Scripts from 13.10 doesn't work with 15.10 using named pipes

Tools
Enthusiast

TPT - Scripts from 13.10 doesn't work with 15.10 using named pipes

Hi,

I'm was using TTU 13.10 until now, when I upgraded my production machine with TTU 15.00.

But now I'm getting this error:

TPT19435 pmRead failed. EOF encountered before end of record (35)

The process that load data to the named pipes doesn't have time to connect to the pipes.

When I uninstalled 15.00 and installed 13.10 again everything back to normal.

I also tryed to run tbuild 15.00 using the np_AXSMOD.dll from the 13.10 package, but result was the same.

I can't find anything wrong in the docs.

Here's the dataconnector producer:

 DEFINE OPERATOR PIPE_READER1()
DESCRIPTION 'Define opcoes de leitura de arquivos'
TYPE DATACONNECTOR PRODUCER
SCHEMA LOAD_AS_IS_TEST_SCHEMA
ATTRIBUTES
(
VARCHAR AccessModuleName = 'np_axsmod.dll'
, VARCHAR AccessModuleInitStr
, VARCHAR FileName = '\.\pipe\LoadAsIs_1'
, VARCHAR Format = 'TEXT'
, VARCHAR IndicatorMode = 'N'
, VARCHAR OpenMode = 'Read'
, VARCHAR RowErrFileName = @errorFilePath
, INTEGER MaxSessions = @maxExportSessions
, INTEGER MinSessions = @minExportSessions
);

Log (using 13.10):

15:24:07 INFO > Teradata Parallel Transporter Version 13.10.00.02
15:24:07 INFO > Job log: D:\Programacao\Java\Projetos\teradata-loader\src\test\resources\temp/LoadAsIs-1.out
15:24:07 ERROR> WARN:Failed to lookup account administrators
15:24:07 ERROR> WARN:Failed to lookup account administrators
15:24:07 INFO > Job id is LoadAsIs-1, running on DragonZord
15:24:10 INFO > Teradata Parallel Transporter SQL DDL Operator Version 13.10.00.02
15:24:10 INFO > PREPARES_LOAD: private log not specified
15:24:13 INFO > PREPARES_LOAD: connecting sessions
15:24:14 INFO > PREPARES_LOAD: sending SQL requests
15:24:16 INFO > PREPARES_LOAD: TPT10508: RDBMS error 3807: Object 'DCT_PROD_TDM.LOAD_AS_IS_TEST' does not exist.
15:24:16 INFO > PREPARES_LOAD: TPT18046: Warning: error is ignored as requested in ErrorList
15:24:16 INFO > PREPARES_LOAD: disconnecting sessions
15:24:17 INFO > PREPARES_LOAD: Total processor time used = '0.140401 Second(s)'
15:24:17 INFO > PREPARES_LOAD: Start : Mon Aug 11 15:24:10 2014
15:24:17 INFO > PREPARES_LOAD: End : Mon Aug 11 15:24:17 2014
15:24:17 INFO > Job step PREPARES_LOAD_LOAD_AS_IS_TEST completed successfully
15:24:26 INFO > Teradata Parallel Transporter DataConnector Version 13.10.00.02
15:24:26 INFO > PIPE_READER4: TPT19008 DataConnector Producer operator Instances: 1
15:24:26 INFO > Teradata Parallel Transporter DataConnector Version 13.10.00.02
15:24:26 INFO > Teradata Parallel Transporter Load Operator Version 13.10.00.02
15:24:26 INFO > DATA_LOAD: private log not specified
15:24:26 INFO > PIPE_READER5: TPT19008 DataConnector Producer operator Instances: 1
15:24:26 INFO > Teradata Parallel Transporter DataConnector Version 13.10.00.02
15:24:26 INFO > Teradata Parallel Transporter DataConnector Version 13.10.00.02
15:24:26 INFO > PIPE_READER3: TPT19008 DataConnector Producer operator Instances: 1
15:24:26 INFO > PIPE_READER2: TPT19008 DataConnector Producer operator Instances: 1
15:24:26 INFO > Teradata Parallel Transporter DataConnector Version 13.10.00.02
15:24:26 INFO > Teradata Parallel Transporter DataConnector Version 13.10.00.02
15:24:26 INFO > PIPE_READER8: TPT19008 DataConnector Producer operator Instances: 1
15:24:26 INFO > PIPE_READER6: TPT19008 DataConnector Producer operator Instances: 1
15:24:26 INFO > Teradata Parallel Transporter DataConnector Version 13.10.00.02
15:24:26 INFO > PIPE_READER7: TPT19008 DataConnector Producer operator Instances: 1
15:24:26 INFO > Teradata Parallel Transporter DataConnector Version 13.10.00.02
15:24:26 INFO > PIPE_READER1: TPT19008 DataConnector Producer operator Instances: 1
15:24:26 INFO > PIPE_READER1: TPT19003 ECI operator ID: PIPE_READER1-6656
15:24:26 INFO > PIPE_READER4: TPT19003 ECI operator ID: PIPE_READER4-2596
15:24:26 INFO > PIPE_READER7: TPT19003 ECI operator ID: PIPE_READER7-6900
15:24:26 INFO > PIPE_READER2: TPT19003 ECI operator ID: PIPE_READER2-6128
15:24:26 INFO > PIPE_READER5: TPT19003 ECI operator ID: PIPE_READER5-3504
15:24:26 INFO > PIPE_READER8: TPT19003 ECI operator ID: PIPE_READER8-5456
15:24:26 INFO > PIPE_READER6: TPT19003 ECI operator ID: PIPE_READER6-5728
15:24:26 INFO > PIPE_READER3: TPT19003 ECI operator ID: PIPE_READER3-3396
15:24:28 INFO > DATA_LOAD: connecting sessions
15:24:37 INFO > PIPE_READER2: TPT19222 Operator instance 1 processing file '\.\pipe\LoadAsIs_2'.
15:24:37 INFO > PIPE_READER1: TPT19222 Operator instance 1 processing file '\.\pipe\LoadAsIs_1'.
15:24:37 INFO > PIPE_READER5: TPT19222 Operator instance 1 processing file '\.\pipe\LoadAsIs_5'.
15:24:37 INFO > PIPE_READER3: TPT19222 Operator instance 1 processing file '\.\pipe\LoadAsIs_3'.
15:24:37 INFO > PIPE_READER8: TPT19222 Operator instance 1 processing file '\.\pipe\LoadAsIs_8'.
15:24:37 INFO > PIPE_READER6: TPT19222 Operator instance 1 processing file '\.\pipe\LoadAsIs_6'.
15:24:37 INFO > PIPE_READER4: TPT19222 Operator instance 1 processing file '\.\pipe\LoadAsIs_4'.
15:24:37 INFO > PIPE_READER7: TPT19222 Operator instance 1 processing file '\.\pipe\LoadAsIs_7'.
15:24:39 INFO > DATA_LOAD: preparing target table
15:24:40 INFO > DATA_LOAD: entering Acquisition Phase
15:24:49 INFO > DATA_LOAD: entering Application Phase
15:24:50 INFO > DATA_LOAD: Statistics for Target Table: 'DCT_PROD_TDM.LOAD_AS_IS_TEST'
15:24:50 INFO > DATA_LOAD: Total Rows Sent To RDBMS: 3352
15:24:50 INFO > DATA_LOAD: Total Rows Applied: 3352
15:24:52 INFO > DATA_LOAD: disconnecting sessions
15:24:52 INFO > PIPE_READER4: TPT19221 Total files processed: 1.
15:24:52 INFO > PIPE_READER7: TPT19221 Total files processed: 1.
15:24:52 INFO > PIPE_READER8: TPT19221 Total files processed: 1.
15:24:52 INFO > PIPE_READER6: TPT19221 Total files processed: 1.
15:24:52 INFO > PIPE_READER3: TPT19221 Total files processed: 1.
15:24:52 INFO > PIPE_READER2: TPT19221 Total files processed: 1.
15:24:52 INFO > PIPE_READER5: TPT19221 Total files processed: 1.
15:24:52 INFO > PIPE_READER1: TPT19221 Total files processed: 1.
15:24:57 INFO > DATA_LOAD: Total processor time used = '0.405603 Second(s)'
15:24:57 INFO > DATA_LOAD: Start : Mon Aug 11 15:24:26 2014
15:24:57 INFO > DATA_LOAD: End : Mon Aug 11 15:24:57 2014
15:24:57 INFO > Job step LOAD_LOAD_AS_IS_TEST completed successfully
15:24:57 INFO > Job LoadAsIs completed successfully

Log (using 15.00):

14:24:54 INFO > Teradata Parallel Transporter Version 15.00.00.00
14:24:54 INFO > Job log: D:\Programacao\Java\Projetos\teradata-loader\src\test\resources\temp/LoadAsIs-42.out
14:24:54 ERROR> WARN:Failed to lookup account administrators
14:24:54 ERROR> WARN:Failed to lookup account administrators
14:24:54 INFO > Job id is LoadAsIs-42, running on DragonZord
14:24:57 INFO > Teradata Parallel Transporter SQL DDL Operator Version 15.00.00.00
14:24:57 INFO > PREPARES_LOAD: private log not specified
14:24:59 INFO > PREPARES_LOAD: connecting sessions
14:25:00 INFO > PREPARES_LOAD: The RDBMS retryable error code list was not found
14:25:00 INFO > PREPARES_LOAD: The job will use its internal retryable error codes
14:25:00 INFO > PREPARES_LOAD: sending SQL requests
14:25:07 INFO > PREPARES_LOAD: disconnecting sessions
14:25:08 INFO > PREPARES_LOAD: Total processor time used = '0.0936006 Second(s)'
14:25:08 INFO > PREPARES_LOAD: Start : Mon Aug 11 14:24:57 2014
14:25:08 INFO > PREPARES_LOAD: End : Mon Aug 11 14:25:08 2014
14:25:08 INFO > Job step PREPARES_LOAD_LOAD_AS_IS_TEST completed successfully
14:25:18 INFO > Teradata Parallel Transporter PIPE_READER2[1]: TPT19006 Version 15.00.00.00
14:25:18 INFO > Teradata Parallel Transporter PIPE_READER6[1]: TPT19006 Version 15.00.00.00
14:25:18 INFO > Teradata Parallel Transporter PIPE_READER7[1]: TPT19006 Version 15.00.00.00
14:25:18 INFO > Teradata Parallel Transporter PIPE_READER3[1]: TPT19006 Version 15.00.00.00
14:25:18 INFO > PIPE_READER2[1]: TPT19010 Instance 1 directing private log report to 'dtacop-Home Work-5760-1'.
14:25:18 INFO > PIPE_READER6[1]: TPT19010 Instance 1 directing private log report to 'dtacop-Home Work-4060-1'.
14:25:18 INFO > PIPE_READER7[1]: TPT19010 Instance 1 directing private log report to 'dtacop-Home Work-5348-1'.
14:25:18 INFO > PIPE_READER3[1]: TPT19010 Instance 1 directing private log report to 'dtacop-Home Work-3300-1'.
14:25:18 INFO > Teradata Parallel Transporter PIPE_READER5[1]: TPT19006 Version 15.00.00.00
14:25:18 INFO > PIPE_READER2[1]: TPT19003 NotifyMethod: 'None (default)'
14:25:18 INFO > PIPE_READER2[1]: TPT19008 DataConnector Producer operator Instances: 1
14:25:18 INFO > PIPE_READER7[1]: TPT19003 NotifyMethod: 'None (default)'
14:25:18 INFO > PIPE_READER7[1]: TPT19008 DataConnector Producer operator Instances: 1
14:25:18 INFO > Teradata Parallel Transporter PIPE_READER8[1]: TPT19006 Version 15.00.00.00
14:25:18 INFO > PIPE_READER5[1]: TPT19010 Instance 1 directing private log report to 'dtacop-Home Work-1488-1'.
14:25:18 INFO > PIPE_READER6[1]: TPT19003 NotifyMethod: 'None (default)'
14:25:18 INFO > PIPE_READER3[1]: TPT19003 NotifyMethod: 'None (default)'
14:25:18 INFO > PIPE_READER6[1]: TPT19008 DataConnector Producer operator Instances: 1
14:25:18 INFO > PIPE_READER3[1]: TPT19008 DataConnector Producer operator Instances: 1
14:25:18 INFO > PIPE_READER5[1]: TPT19003 NotifyMethod: 'None (default)'
14:25:18 INFO > PIPE_READER5[1]: TPT19008 DataConnector Producer operator Instances: 1
14:25:18 INFO > PIPE_READER8[1]: TPT19010 Instance 1 directing private log report to 'dtacop-Home Work-1196-1'.
14:25:18 INFO > PIPE_READER8[1]: TPT19003 NotifyMethod: 'None (default)'
14:25:18 INFO > PIPE_READER8[1]: TPT19008 DataConnector Producer operator Instances: 1
14:25:18 INFO > Teradata Parallel Transporter PIPE_READER4[1]: TPT19006 Version 15.00.00.00
14:25:18 INFO > Teradata Parallel Transporter Load Operator Version 15.00.00.00
14:25:18 INFO > DATA_LOAD: private log not specified
14:25:18 INFO > PIPE_READER4[1]: TPT19010 Instance 1 directing private log report to 'dtacop-Home Work-6988-1'.
14:25:18 INFO > PIPE_READER4[1]: TPT19003 NotifyMethod: 'None (default)'
14:25:18 INFO > PIPE_READER4[1]: TPT19008 DataConnector Producer operator Instances: 1
14:25:18 INFO > PIPE_READER6[1]: TPT19003 ECI operator ID: 'PIPE_READER6-4060'
14:25:18 INFO > PIPE_READER5[1]: TPT19003 ECI operator ID: 'PIPE_READER5-1488'
14:25:18 INFO > PIPE_READER8[1]: TPT19003 ECI operator ID: 'PIPE_READER8-1196'
14:25:18 INFO > PIPE_READER7[1]: TPT19003 ECI operator ID: 'PIPE_READER7-5348'
14:25:18 INFO > PIPE_READER2[1]: TPT19003 ECI operator ID: 'PIPE_READER2-5760'
14:25:18 INFO > PIPE_READER3[1]: TPT19003 ECI operator ID: 'PIPE_READER3-3300'
14:25:18 INFO > PIPE_READER6[1]: TPT19222 Operator instance 1 processing file '\.\pipe\LoadAsIs_6'.
14:25:18 INFO > PIPE_READER8[1]: TPT19222 Operator instance 1 processing file '\.\pipe\LoadAsIs_8'.
14:25:18 INFO > PIPE_READER7[1]: TPT19222 Operator instance 1 processing file '\.\pipe\LoadAsIs_7'.
14:25:18 INFO > PIPE_READER3[1]: TPT19222 Operator instance 1 processing file '\.\pipe\LoadAsIs_3'.
14:25:18 INFO > PIPE_READER2[1]: TPT19222 Operator instance 1 processing file '\.\pipe\LoadAsIs_2'.
14:25:18 INFO > Teradata Parallel Transporter PIPE_READER1[1]: TPT19006 Version 15.00.00.00
14:25:18 INFO > PIPE_READER1[1]: TPT19010 Instance 1 directing private log report to 'dtacop-Home Work-5768-1'.
14:25:18 INFO > PIPE_READER4[1]: TPT19003 ECI operator ID: 'PIPE_READER4-6988'
14:25:18 INFO > PIPE_READER1[1]: TPT19003 NotifyMethod: 'None (default)'
14:25:18 INFO > PIPE_READER1[1]: TPT19008 DataConnector Producer operator Instances: 1
14:25:18 INFO > PIPE_READER5[1]: TPT19222 Operator instance 1 processing file '\.\pipe\LoadAsIs_5'.
14:25:18 INFO > PIPE_READER4[1]: TPT19222 Operator instance 1 processing file '\.\pipe\LoadAsIs_4'.
14:25:18 INFO > PIPE_READER1[1]: TPT19003 ECI operator ID: 'PIPE_READER1-5768'
14:25:18 INFO > PIPE_READER1[1]: TPT19222 Operator instance 1 processing file '\.\pipe\LoadAsIs_1'.
14:25:21 INFO > DATA_LOAD: connecting sessions
14:25:21 INFO > DATA_LOAD: The RDBMS retryable error code list was not found
14:25:21 INFO > DATA_LOAD: The job will use its internal retryable error codes
14:25:52 INFO > DATA_LOAD: preparing target table
14:25:58 INFO > DATA_LOAD: entering Acquisition Phase
14:26:01 INFO > PIPE_READER1[1]: TPT19435 pmRead failed. EOF encountered before end of record (35)
14:26:01 INFO > PIPE_READER2[1]: TPT19435 pmRead failed. EOF encountered before end of record (35)
14:26:01 INFO > PIPE_READER3[1]: TPT19435 pmRead failed. EOF encountered before end of record (35)
14:26:01 INFO > PIPE_READER1[1]: TPT19305 Fatal error reading data.
14:26:01 INFO > PIPE_READER2[1]: TPT19305 Fatal error reading data.
14:26:01 INFO > PIPE_READER3[1]: TPT19305 Fatal error reading data.
14:26:01 INFO > PIPE_READER1[1]: TPT19015 TPT Exit code set to 12.
14:26:01 INFO > PIPE_READER2[1]: TPT19015 TPT Exit code set to 12.
14:26:01 INFO > PIPE_READER3[1]: TPT19015 TPT Exit code set to 12.
14:26:01 INFO > PIPE_READER4[1]: TPT19435 pmRead failed. EOF encountered before end of record (35)
14:26:01 INFO > PIPE_READER5[1]: TPT19435 pmRead failed. EOF encountered before end of record (35)
14:26:01 INFO > PIPE_READER4[1]: TPT19305 Fatal error reading data.
14:26:01 INFO > PIPE_READER5[1]: TPT19305 Fatal error reading data.
14:26:01 INFO > PIPE_READER4[1]: TPT19015 TPT Exit code set to 12.
14:26:01 INFO > PIPE_READER6[1]: TPT19435 pmRead failed. EOF encountered before end of record (35)
14:26:01 INFO > PIPE_READER5[1]: TPT19015 TPT Exit code set to 12.
14:26:01 INFO > PIPE_READER6[1]: TPT19305 Fatal error reading data.
14:26:01 INFO > PIPE_READER6[1]: TPT19015 TPT Exit code set to 12.
14:26:01 INFO > PIPE_READER7[1]: TPT19435 pmRead failed. EOF encountered before end of record (35)
14:26:01 INFO > PIPE_READER8[1]: TPT19435 pmRead failed. EOF encountered before end of record (35)
14:26:01 INFO > PIPE_READER7[1]: TPT19305 Fatal error reading data.
14:26:01 INFO > PIPE_READER8[1]: TPT19305 Fatal error reading data.
14:26:01 INFO > PIPE_READER7[1]: TPT19015 TPT Exit code set to 12.
14:26:01 INFO > PIPE_READER8[1]: TPT19015 TPT Exit code set to 12.
14:26:01 INFO > DATA_LOAD: disconnecting sessions
14:26:01 INFO > PIPE_READER2[1]: TPT19221 Total files processed: 0.
14:26:01 INFO > PIPE_READER3[1]: TPT19221 Total files processed: 0.
14:26:01 INFO > PIPE_READER5[1]: TPT19221 Total files processed: 0.
14:26:01 INFO > PIPE_READER6[1]: TPT19221 Total files processed: 0.
14:26:01 INFO > PIPE_READER4[1]: TPT19221 Total files processed: 0.
14:26:01 INFO > PIPE_READER1[1]: TPT19221 Total files processed: 0.
14:26:01 INFO > PIPE_READER8[1]: TPT19221 Total files processed: 0.
14:26:01 INFO > PIPE_READER7[1]: TPT19221 Total files processed: 0.
14:26:18 INFO > DATA_LOAD: Total processor time used = '0.312002 Second(s)'
14:26:18 INFO > DATA_LOAD: Start : Mon Aug 11 14:25:18 2014
14:26:18 INFO > DATA_LOAD: End : Mon Aug 11 14:26:18 2014
14:26:18 INFO > Job step LOAD_LOAD_AS_IS_TEST terminated (status 12)
14:26:18 INFO > Job LoadAsIs terminated (status 12)
14:26:18 INFO > Job start: Mon Aug 11 14:24:54 2014
14:26:18 INFO > Job end: Mon Aug 11 14:26:18 2014

Sorry for the long post.

Thanks for the help.

6 REPLIES
Enthusiast

Re: TPT - Scripts from 13.10 doesn't work with 15.10 using named pipes

Before my workmates read this post: when I said production machine, I meant development machine...

Teradata Employee

Re: TPT - Scripts from 13.10 doesn't work with 15.10 using named pipes

That is a known issue and has been fixed in these versions of TPT:

13.10.00.19

14.00.00.12

14.10.00.05

15.00.00.02

-- SteveF
Enthusiast

Re: TPT - Scripts from 13.10 doesn't work with 15.10 using named pipes

Where can I get 15.00.00.02?

I can only find 15.00.00.00 in this site (http://downloads.teradata.com/download/tools/teradata-tools-and-utilities-windows-installation-packa...).

I can't find an "older" or "non-stable" or "RC" versions of TTU or TPT anywhere.

Teradata Employee

Re: TPT - Scripts from 13.10 doesn't work with 15.10 using named pipes

Efixes are not shipped to the Developer Exchange.

They are available on the patch server.

-- SteveF

Re: TPT - Scripts from 13.10 doesn't work with 15.10 using named pipes

Hi Feinholz,

We have just upgraded TTU utilities to 15.10 but the databse version is 13.10.07.12.

When Im running TPT , its giving below errors :

The RDBMS retryable error code list was not found

RetentionLogSelect: The RDBMS retryable error code list was not found

**** 05:29:00 The job will use its internal retryable error codes

 The job will use its internal retryable error codes

Buy TPT exits with return code = 0 (i.e. as Success) and out of 14,000 records to be extracted it only extracts 7938 records.

Could you please elaborate more this issue as in past posts I am seeing that you are refeering it as a known issue of PTP and is fixed woth version 15.00.00..02.

I am not sure if this  error is being caused by the same issue.

Thanks,

Sagar 

Teradata Employee

Re: TPT - Scripts from 13.10 doesn't work with 15.10 using named pipes

These messages:

The RDBMS retryable error code list was not found

RetentionLogSelect: The RDBMS retryable error code list was not found

**** 05:29:00 The job will use its internal retryable error codes

are not errors, they are informational messages and do not impact the job.

If there is an issue related to number of records extracted, it is not related to those messages.

-- SteveF