Teradata Database Message 9334 - 9334 - Analytics Database - Teradata Vantage

Message

Invalid constraint definition.

Explanation

This error can occur for any of the following reasons: 1) A hard RI is being defined on a temporal table. Hard RI is not allowed on temporal tables. 2) The constraint definition is specifying a ValidTime qualifier option and the table does not support ValidTime 3) The constraint definition is specifying a TransactionTime qualifier option and the table does not support TransactionTime.

Generated By

OPD modules.

For Whom

End user.

Notes

None

Remedy

Correct the temporal qualifier used in the constraint and Soft RI can be defined instead of hard RI. Fix and resubmit the request.