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 Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023