Archives of the TeradataForum

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

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

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>>