Teradata Database Message 5964 - 17.10 - 5964 - 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
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.