Teradata Database Message 4360 - 17.10 - 4360 - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Database Messages

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1096-171K
Language
English (United States)
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