Teradata Database Message 9127 - 9127 - Analytics Database - Teradata Vantage

Message

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.

Notes

None

Remedy

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