Teradata Database Message 9570 - 17.10 - 9570 - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Database Messages

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1096-171K
Language
English (United States)
Message
A constraint defined in the table is invalid.
Explanation
This can happen when a constraint is dropped or recreated after a table defined with the constraint is archived. When the archived table is restored, the referenced constraint's internal id is not associated with an existing constraint in DBC.SecConstraints.
Generated By
RES module.
For Whom
End User.
Notes
None
Remedy
The restored table is inaccessible because of a dropped or recreated constraint. Identify the constraint that was dropped or recreated after the archive was taken. Drop the constraint column and add back the constraint if it was recreated, then resubmit the request. For further help, contact your Support Representative.