Teradata Database Message 5312 - 5312 - 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
- Aborted due to a non-valid reference index on %DBID.%TVMID.
- Explanation
- The table being accessed has a reference index that is not valid. This could have resulted from one of the following two cases: (1) The target table or other table which references or is being referenced by the target table was rollforward/back or restored. (2) The target table has some unresolved references because it is referencing some non-existent tables. (3) The referenced index subtable is marked down by the file system fault isolation logic. For either case, no inserts, updates, or deletes are allowed.
- Generated By
- OPT modules.
- For Whom
- End User.
- Notes
- None
- Remedy
- For the Roll and Restore case, drop the corresponding referential constraint and resubmit the request. For the unresolved references case, create all the missing referenced tables and resubmit the request. For the down RI subtable, resolve the down subtable by using the ALTER TABLE RESET SQL to clear the down status from the table header.