Teradata Database Message 9101 - 9101 - Analytics Database - Teradata Vantage

Message

Referencing 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 RI violations detects an RI 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.

Notes

None

Remedy

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