Issue with TPT named pipes on windows

Tools & Utilities
Teradata Employee

Issue with TPT named pipes on windows

hi all,

I am having a problem getting the named pipes TPT to complete. It appears to take several checkpoints and runs for a while (i am trying to copy apprx 18M rows). It appears to be hanging and the target table is 'being loaded' when I try to get a row count. Any ideas are welcomed....

C:\Windows\System32>tlogview -j Contact_Email_Ct_pipe_20150216_111826-12879

TPT_INFRA: TPT04101: Warning: TMSM failed to initialize

Teradata Parallel Transporter Executor Version 13.10.00.02

Teradata Parallel Transporter Coordinator Version 13.10.00.02

Teradata Parallel Transporter Executor Version 13.10.00.02

Teradata Parallel Transporter Executor Version 13.10.00.02

Teradata Parallel Transporter Executor Version 13.10.00.02

Teradata Parallel Transporter Executor Version 13.10.00.02

Teradata Parallel Transporter Executor Version 13.10.00.02

ACCESS_MODULE_READER: TPT19206 Attribute 'TraceLevel' value reset to 'MILESTONES

'.

ACCESS_MODULE_READER: TPT19206 Attribute 'TraceLevel' value reset to 'MILESTONES

'.

Teradata Parallel Transporter DataConnector Version 13.10.00.02

ACCESS_MODULE_READER Instance 2 directing private log report to 'dataconnector_log-2'.

ACCESS_MODULE_READER Instance 3 directing private log report to 'dataconnector_log-3'.

ACCESS_MODULE_READER: TPT19206 Attribute 'TraceLevel' value reset to 'MILESTONES'.

ACCESS_MODULE_READER Instance 1 directing private log report to 'dataconnector_log-1'.

ACCESS_MODULE_READER: TPT19008 DataConnector Producer operator Instances: 3

Teradata Parallel Transporter Load Operator Version 13.10.00.02

Contact_Email_CT_loadP1: private log specified: Contact_Email_CT_strm_log-1

ACCESS_MODULE_READER: TPT19003 ECI operator ID: ACCESS_MODULE_READER-4240

ACCESS_MODULE_READER: TPT19012 No files assigned to instance 2.  This instance will be inactive.

ACCESS_MODULE_READER: TPT19012 No files assigned to instance 3.  This instance will be inactive.

Contact_Email_CT_loadP1: connecting sessions

ACCESS_MODULE_READER: TPT19222 Operator instance 1 processing file '\.\pipe\npp1'.

Contact_Email_CT_loadP1: preparing target table

Contact_Email_CT_loadP1: entering Acquisition Phase

Job is running in Buffer Mode

Task(APPLY_1[0001]): checkpoint completed, status = Success

Task(APPLY_1[0003]): checkpoint completed, status = Success

Task(SELECT_2[0002]): checkpoint completed, status = Success

Task(SELECT_2[0003]): checkpoint completed, status = Success

Task(APPLY_1[0002]): checkpoint completed, status = Success

Task(SELECT_2[0001]): checkpoint completed, status = Success

C:\Windows\System32>

Also, why do I get ACCESS_MODULE_READER: TPT19012 No files assigned to instance 2.  This instance will be inactive.

ACCESS_MODULE_READER: TPT19012 No files assigned to instance 3.  This instance will be inactive.

Tags (1)
1 REPLY
Teradata Employee

Re: Issue with TPT named pipes on windows

In your script, you must have indicated that you wanted to use 3 instances of the DataConnector operator.

If you are using an access module, you can only use one instance of the DataConnector operator.

As for the issues, please let me know where the data is coming from.

It looks like you might be using named pipes in the job.

Are you using the Named Pipe Access Module?

If I understand the job a little more, perhaps I can assist.

-- SteveF