Home Page for the TeradataForum
 
 

 

Archives of the TeradataForum





Message Posted: Mon, 17 Jun 2008 @ 00:20:23 GMT





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




Subj:   Re: TPT error-PXTB_Restart: Operator restart error
 
From:   Christopher Stephens



The messages:

     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]

look like internal errors that a user is never supposed to see ... I'd open an incident.

My guess is that load operator instances 2, 3, and 4 are unable to pick up the INSERT statement being passed to them on restart. I agree with the previous message - is TPT running in restart mode? If you initially ran a job using one instance and got a failure, then tried to run it again using four instances, it may still by trying to restart the single instance job.

Can you try figuring out where the checkpoint / restart directory is to clean up any existing restart files? Also drop the log tables from the database (unless, of course, your table is still locked for FastLoading ...)


- Chris Stephens





     
  <Prev Next>   <<First <Prev
Next>
Last>>
 
 
 
 
 
 
 
 
 
  
 
  Top Home Join Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky 
Last Modified: 16 Nov 2008