Teradata Database Message 5964 - 5964 - Analytics Database - Teradata Vantage

Message

Session collation does not match PPI collation.

Explanation

An operation on a character partitioned primary index was attempted that is only allowed when the session collation matches the collation of the PPI.

Generated By

OPT modules.

For Whom

End User.

Notes

None

Remedy

Retry the operation using the same session collation as the PPI collation. The PPI collation of a permanent table or join index with a partitioned primary index can be looked up in columns ConstraintCollation and CollationName of DBC.IndexConstraints. When ConstraintCollation is 'C', the collation is CHARSET_COLL with CollationName and CharSetID indicating the character set used for the collation. Set the session collation the same as the PPI collation and retry the operation.