Teradata Database Message 2728 - 17.10 - 2728 - 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
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 be resulted from the following two cases: (1) The target table or other table which references or 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. For either case, no inserts, updates, or deletes are allowed.
Generated By
SutCK1Rw & SutCKNRw.
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 table and resubmit the request.