Teradata Database Message 5312 - 5312 - Analytics Database - 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.