Archives of the TeradataForum
Message Posted: Mon, 16 Jun 2008 @ 21:57:00 GMT
<-- Anonymously Posted: Mon, 16 Jun 2008 18:04 -->
I developed a TPT script which loads data from Oracle to Teradata using ODBC and LOAD operator. This script run fine, but sometime it throws this error which causes the load to fail. Basically I get this error when more than one TPT script run in parallel. I have no clue for this error.
The number of load-operator instance used for this job is four.
Could you please help me to resolve this?
Thanks a lot in advance.
Teradata Parallel Transporter Load Operator Version 12.00.00.00 W_1_o_fct_cashflow_load_test: private log not specified W_0_o_fct_cashflow_load_test: connecting sessions W_1_o_fct_cashflow_load_test: connecting sessions W_1_o_fct_cashflow_load_test: preparing target table W_1_o_fct_cashflow_load_test: entering Acquisition Phase An object did not exist for key: APPLY_1 An object did not exist for key: APPLY_1 An object did not exist for key: APPLY_1 Operator(odbcop.dll) instance(1): RESTART method failed with status = Fatal Error PXTB_Restart: Operator restart error, status = Multi Phase Error Task(SELECT_2): restart completed, status = Multi Phase Error W_0_o_fct_cashflow_load_test: disconnecting sessions W_1_o_fct_cashflow_load_test: disconnecting sessions W_0_o_fct_cashflow_load_test: aborting due to the following error: Cannot restart in the middle of export. Must start from scratch. Job step MAIN_STEP terminated (status 12) Job cashflow_load terminated (status 12)
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|