TPT_ISSUE

Tools

TPT_ISSUE

hi,

anybody has any information about the following error messages.

Any manuals or documents related it ,please share with me.

Data_Connector: TPT19404 pmOpen failed. Requested file not found (4)
Data_Connector: TPT19304 Fatal error opening file.
TPT_INFRA: TPT02263: Error: Operator restart error, status = Multi Phase Error
Task(SELECT_2[0001]): restart completed, status = Multi Phase Error

Thanks
8 REPLIES
Teradata Employee

Re: TPT_ISSUE

Hi kusumayella,

Can u share your Data_Connector code..?? So that we can explain u clearly about the error..!!
Teradata Employee

Re: TPT_ISSUE

By "DataConnector code" I hope you meant the script.
We are not sharing any software.

The DataConnector error is self-explanatory. The file you specified in the script is not found.
As far as the "multi phase error", just ignore those for now.

What version of TPT are you using?
-- SteveF

Re: TPT_ISSUE

Hi,

We experienced the same issue couple of days ago. I verified that files and paths that are passed as arguments to the commands are all valid.

We are invoking the command as below (I've modified parts of it for security reasons):

tbuild -f /home/user1/tmocdr.tpt -u "STAGEDB='bi_stg', TGT='payments_hist_stg', TMO_TDP='Teradata', TMO_USER='BI_USR', TMO_PASS='XXXX', INCFILE='/home/user1/payments_hist_stg.inc', TPTLOG='payments_hist_stg_pl'" tptjob_payments_hist_stg

INC file:
SELECT * FROM OPERATOR ( DATACON [12] ATTR( DirectoryPath = '/home/user1', FileName = 'PAYMENTS_*.dat*'));

Error Log:

Teradata Parallel Transporter Version 12.00.00.02
Execution Plan generation started.
Execution Plan generation successfully completed.
Job id is tptjob_payments_hist_stg-81, running on devicc03
Found CheckPoint file: /opt/logs/tbuild/checkpoint/tptjob_payments_hist_stgLVCP
This is a restart job; it restarts at step MAIN_STEP.
Teradata Parallel Transporter Load Operator Version 12.00.00.03
LOADOP: private log specified: payments_hist_stg_pl
LOADOP: connecting sessions
DATACON: Instance 2 restarting.
DATACON: Instance 11 restarting.
DATACON: Instance 12 restarting.
DATACON: Instance 10 restarting.
Teradata Parallel Transporter DataConnector Version 12.00.00.04
DATACON: Instance 4 restarting.
DATACON: Instance 8 restarting.
DATACON: Instance 6 restarting.
DATACON: Instance 7 restarting.
DATACON: Instance 9 restarting.
DATACON: Instance 3 restarting.
DATACON: Instance 1 restarting.
DATACON: Instance 5 restarting.
DATACON: DataConnector Producer operator Instances: 12
LOADOP: preparing target table
LOADOP: entering Acquisition Phase
DATACON: pmOpen failed. Requested file not found (4)
DATACON: Fatal error opening file.
Operator(libdataconop.so) instance(1): RESTART method failed with status = Fatal Error
DATACON: pmOpen failed. Requested file not found (4)
DATACON: Fatal error opening file.
Operator(libdataconop.so) instance(3): RESTART method failed with status = Fatal Error
DATACON: pmOpen failed. Requested file not found (4)
DATACON: Fatal error opening file.
Operator(libdataconop.so) instance(2): RESTART method failed with status = Fatal Error
DATACON: Operator instance 4 processing file 'PAYMENTS_04_B.dat1'.
PXTB_Restart: Operator restart error, status = Multi Phase Error
Task(SELECT_2[0003]): restart completed, status = Multi Phase Error
PXTB_Restart: Operator restart error, status = Multi Phase Error
Task(SELECT_2[0009]): restart completed, status = Multi Phase Error
PXTB_Restart: Operator restart error, status = Multi Phase Error
Task(SELECT_2[0001]): restart completed, status = Multi Phase Error
PXTB_Restart: Operator restart error, status = Multi Phase Error
PXTB_Restart: Operator restart error, status = Multi Phase Error
Task(SELECT_2[0011]): restart completed, status = Multi Phase Error
Task(SELECT_2[0012]): restart completed, status = Multi Phase Error
PXTB_Restart: Operator restart error, status = Multi Phase Error
Task(SELECT_2[0006]): restart completed, status = Multi Phase Error
PXTB_Restart: Operator restart error, status = Multi Phase Error
PXTB_Restart: Operator restart error, status = Multi Phase Error
PXTB_Restart: Operator restart error, status = Multi Phase Error
PXTB_Restart: Operator restart error, status = Multi Phase Error
Task(SELECT_2[0010]): restart completed, status = Multi Phase Error
Task(SELECT_2[0008]): restart completed, status = Multi Phase Error
Task(SELECT_2[0007]): restart completed, status = Multi Phase Error
Task(SELECT_2[0002]): restart completed, status = Multi Phase Error
PXTB_Restart: Operator restart error, status = Multi Phase Error
PXTB_Restart: Operator restart error, status = Multi Phase Error
Task(SELECT_2[0005]): restart completed, status = Multi Phase Error
Task(SELECT_2[0004]): restart completed, status = Multi Phase Error
LOADOP: disconnecting sessions
DATACON: Total files processed: 0.
Job step MAIN_STEP terminated (status 12)
Job tptjob_payments_hist_stg terminated (status 12)
Teradata Employee

Re: TPT_ISSUE

If you are running a version as old as 12.00.00 (which, by the way is not a supported versin of TPT), please upgrade to the latest and greatest efix patches.

As for this command:

tbuild -f /home/user1/tmocdr.tpt -u "STAGEDB='bi_stg', TGT='payments_hist_stg', TMO_TDP='Teradata', TMO_USER='BI_USR', TMO_PASS='XXXX', INCFILE='/home/user1/payments_hist_stg.inc', TPTLOG='payments_hist_stg_pl'" tptjob_payments_hist_stg

Please explain to me these items you are using:

STAGEDB
TGT
TMO_TDP
TMO_USER
TMO_PASS
INC_FILE
TPTLOG

Those are not valid job variables.

Also, you indicated 12 instances of the DC operator and that may be too many. I am not sure you need that many.
How many files are you trying to process?
-- SteveF
Teradata Employee

Re: TPT_ISSUE

hi there, do you have any updates on this issue?  Our customer from Manila also encountered this error.  thanks!

Teradata Employee

Re: TPT_ISSUE

What issue?

I provided answers and asked questions and there has been no update.

-- SteveF

Re: TPT_ISSUE

I have same issue. So could you help to find out the solution? Thanks so much. 

the error log:

FastLoad/MultiLoad/TPT Log start here

Try to open: /ETL/DEV/LOG/ext_rmd_discode.logTeradata Parallel Transporter Version 14.00.00.10

Job log: /ETL/DEV/LOG/ext_rmd_discode-2348.out

Job id is ext_rmd_discode-2348, running on TDExpress1403_Sles10

Found CheckPoint file: /ETL/DEV/checkpoint/ext_rmd_discodeLVCP

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

Teradata Parallel Transporter W_dc_op_loadext_rmd_discode: TPT19006 Version 14.00.00.10

W_dc_op_loadext_rmd_discode Instance 1 directing private log report to 'dtacop-etl-25716-1'.

W_dc_op_loadext_rmd_discode Instance 1 restarting.

W_dc_op_loadext_rmd_discode: TPT19008 DataConnector Producer operator Instances: 1

W_dc_op_loadext_rmd_discode: TPT19003 ECI operator ID: W_dc_op_loadext_rmd_discode-25716

Teradata Parallel Transporter Load Operator Version 14.00.00.10

W_l_op_loadext_rmd_discode: private log specified: /ETL/DEV/LOG/ext_rmd_discode.log-1

W_l_op_loadext_rmd_discode: connecting sessions

W_l_op_loadext_rmd_discode: preparing target table

W_l_op_loadext_rmd_discode: entering Acquisition Phase

W_dc_op_loadext_rmd_discode: TPT19404 pmOpen failed. Requested file not found (4)

W_dc_op_loadext_rmd_discode: TPT19304 Fatal error opening file.

W_dc_op_loadext_rmd_discode: TPT19003 TPT Exit code set to 12.

TPT_INFRA: TPT02263: Error: Operator restart error, status = Fatal Error

Task(SELECT_2[0001]): restart completed, status = Fatal Error

W_l_op_loadext_rmd_discode: disconnecting sessions

W_dc_op_loadext_rmd_discode: TPT19221 Total files processed: 0.

W_l_op_loadext_rmd_discode: Total processor time used = '0.44 Second(s)'

W_l_op_loadext_rmd_discode: Start : Thu Aug 14 10:36:52 2014

W_l_op_loadext_rmd_discode: End   : Thu Aug 14 10:36:55 2014

Job step MAIN_STEP terminated (status 12)

Job ext_rmd_discode terminated (status 12)

Teradata Employee

Re: TPT_ISSUE

In the script, I will need you to add an attribute to the DataConnector operator definition, as:

VARCHAR TraceLevel = 'all'

and re-run the job that fails and send me the .out file for that job (can be found in the "logs" subdirectory which is located in the TPT install directory).

steven.feinholz@teradata.com

-- SteveF