TT-03017
Child table table_name in a foreign key relationship with ON DELETE CASCADE must be replicated if its parent table table_name is replicated
Cause
When a primary key table is included in a replication scheme, its corresponding foreign key table must be included in the replication scheme, as well. This error is returned when an ON DELETE CASCADE operation is attempted on a foreign key table in a replication scheme, but the primary key table is not included in the replication scheme.
Action
Additional Information
This requirement prevents foreign key conflicts from occurring on the standby master tables when a cascade deletion occurs on the active master database.
TT-03017
Child table table_name in a foreign key relationship with ON DELETE CASCADE must be replicated if its parent table table_name is replicated
Cause
When a primary key table is included in a replication scheme, its corresponding foreign key table must be included in the replication scheme, as well. This error is returned when an ON DELETE CASCADE operation is attempted on a foreign key table in a replication scheme, but the primary key table is not included in the replication scheme.
Action
Additional Information
This requirement prevents foreign key conflicts from occurring on the standby master tables when a cascade deletion occurs on the active master database.
TT-03017
Child table table_name in a foreign key relationship with ON DELETE CASCADE must be replicated if its parent table table_name is replicated
Cause
When a primary key table is included in a replication scheme, its corresponding foreign key table must be included in the replication scheme, as well. This error is returned when an ON DELETE CASCADE operation is attempted on a foreign key table in a replication scheme, but the primary key table is not included in the replication scheme.
Action
Additional Information
This requirement prevents foreign key conflicts from occurring on the standby master tables when a cascade deletion occurs on the active master database.