Teradata Database Message 9486 - 9486 - Analytics Database - Teradata Vantage
Analytics Database Messages
- Deployment
- VantageCloud
- VantageCore
- Edition
- Enterprise
- IntelliFlex
- VMware
- Product
- Analytics Database
- Teradata Vantage
- Release Number
- 15.xx,16.xx,17.xx
- Published
- June 2022
- ft:locale
- en-US
- ft:lastEdition
- 2023-01-05
- dita:mapPath
- sfx1628096178347.ditamap
- dita:ditavalPath
- ft:empty
- dita:id
- B035-1096
- lifecycle
- latest
- Product Category
- Teradata Vantage™
- Message
- Object %DBID.%TVMID with a primary AMP index is invalid and cannot be accessed via the primary AMP index.
- Explanation
- 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 join index with a primary AMP index has been processed by the Reconfig utility. The table or join index cannot be accessed via the invalid primary AMP index.
- Generated By
- AMP modules
- 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.