15.00 - 9100 Unique index violation; errors logged in %TVMID where ETC_dbql_qid = %FSTR. - 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)

9100 Unique index violation; errors logged in %TVMID where ETC_dbql_qid = %FSTR.

Explanation:

This error is returned when a MERGE-INTO or INSERT-SELECT statement that specified LOGGING of errors other than USI violations detects a USI error during index maintenance. To retrieve error rows logged for this request, query the error table with the following search condition displayed at the end of the error message: where ETC_dbql_qid = <Query Id>

Generated By:

AMP Steps.

For Whom:

End User.

Remedy:

Analyse the logged errors and, if necessary, correct the source rows that caused the errors and re-load the corrected rows.