Teradata Database Message 5312 - 17.10 - 5312 - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Database Messages

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Programming Reference
Publication ID
English (United States)
Aborted due to a non-valid reference index on %DBID.%TVMID.
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.
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.