Archives of the TeradataForum

Message Posted: Thu, 19 Oct 2006 @ 19:20:23 GMT

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

Raju:

Is your script doing an ALTER TABLE or some other DDL on the object? If so and your DML is resolved prior to the object being changed, the DML will fail with this error message. The PE's cache memory is spoiled after an ALTER and other DDL statements. Upon resubmitting your DML, it gets the latest definition of the object and therefore works. Does the object change every day? If so, you are running the risk of this happening. You will need to find a way to make sure your DDL and DML are not in conflict - job scheduling should handle this.

Regards,

Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor

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