Teradata Database Message 9244 - 9244 - Analytics Database - Teradata Vantage

Message

Unable to revalidate PPI table header.

Explanation

While checking the table header of the specified character PPI table or join index during an ALTER TABLE with the REVALIDATE PRIMARY INDEX option, a change in the PPI collation was detected. The PPI collation is the session collation that was in effect at the time the PPI was created, and defines ordering of character data for comparisons within the partitioning expression. With a change in the definition of the PPI collation, it is likely that some rows will be incorrectly partitioned, and must be moved to their correct partitions. If not, incorrect results may result from queries involving partition elimination. This error can also occur upon back-down from a minor release of Teradata to an earlier minor release, when there is a difference in the definition of Unicode character set between the two releases (additional code points are defined in the later release), and the partitioning expression include Unicode character expressions or literals.

Generated By

OPT modules.

For Whom

End User and System Support Representative.

Notes

None

Remedy

Re-run ALTER TABLE ... REVALIDATE PRIMARY INDEX with the option to correct partitioning errors in the table, namely, adding either the 'WITH DELETE' or 'WITH INSERT [INTO]' phrase. These options will move incorrectly partitioned rows into their correct partitions and either delete or save rows that belong to no partition (are undefined by the partitioning expression). If the error is due to a difference in the Unicode character set definition, then the 'WITH DELETE' option must be used. If the partitioning expression contains character literals that are undefined at the current release, then revalidation is not an option, and this error will still occur when the 'WITH DELETE' option is specified. If full revalidation in this manner is not an option, an INSERT ... SELECT with no WHERE clause predicates into a new table may be done.