15.00 - 9127 Index violations detected; 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)

9127 Index violations detected; 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 ERRORS logs index violations during index maintenance, and the request is aborted after all index violations are logged. To retrieve the 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.