Archives of the TeradataForum

Message Posted: Mon, 16 Jun 2008 @ 21:57:00 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

<-- Anonymously Posted: Mon, 16 Jun 2008 18:04 -->

Hi All,

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[0002]
     An object did not exist for key: APPLY_1[0003]
     An object did not exist for key: APPLY_1[0004]
     Operator(odbcop.dll) instance(1): RESTART method failed with status =
     Fatal Error
     PXTB_Restart: Operator restart error, status = Multi Phase Error
     Task(SELECT_2[0001]): 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)

Thanks

	<Prev	Next>		<<First	<Prev	Next>	Last>>