Teradata Database Message 4314 - 17.10 - 4314 - 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
Object %DBID.%TVMID with a primary AMP index is invalid and has limited access.
Explanation
This is only a warning, not an error. An invalid primary AMP index can occur when a nonempty table with a primary AMP index has been restored/copied to a different configuration (that is, a different number of AMPs or a different hash algorithm) than the source system. This can also occur when a nonempty table or a join index with a primary AMP index has been processed by the Reconfig utility. The table or join index cannot be accessed via the primary AMP index. Updates are not allowed and queries may run with degraded performance.
Generated By
GncApply module.
For Whom
End User.
Notes
None
Remedy
For a table, alter the table to have no primary index or copy the table to a new CPPA table. For a join index, drop and recreate the join index and resubmit the request.