15.00 - 2728 Aborted due to a non-valid reference index on %DBID.%TVMID. - Teradata Database

Teradata Database Messages

Product
Teradata Database
Release Number
15.00
Content Type
Programming Reference
Publication ID
B035-1096-015K
Language
English (United States)

2728 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.

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.