Teradata Database Message 5441 - 17.10 - 5441 - 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
Replicated table status cannot be INITIATED for Define Role statement.
Explanation
RS Define Role statement requires the replicated table status to be either "Not Initiated, Not Suspended" or "Suspended". In other words, users can either define the role before the replicated table is initiated, or alter the role after the replicated table has been suspended. The role of a replicated table cannot be altered unless the table is in the appropriate state. Otherwise, an error is returned.
Generated By
RES modules.
For Whom
RCT/End User.
Notes
None
Remedy
Check table status. In order to change the role of a replicated table, make sure the status of the table is "Suspended" via a SUSPEND statement.