Teradata Database Message 4360 - 4360 - Analytics Database - Teradata Vantage

Message

Warning: Table headers have been revalidated but insert-select to new CPPA table must be performed due to different config restore.

Explanation

A restore has been done to a different system configuration than the source. Either a new Hash Function or a different number of AMPs. The ALTER TABLE revalidate will succeed to indicate that the table header and EVL op codes have been regenerated however the data rows are still unusable and a new table must be created and an insert select performed to correct the data.

Generated By

stpmtb

For Whom

End user.

Notes

None

Remedy

1) Create new table 2) Insert-Select data into the new table 3) Drop the original table alternate remedy: 1) Alter restored table to a NO PRIAMRY INDEX table