Suppose we have a Warm Standby , ASE 15.5, RS 15.6 with several databases pairs and table cross reference between these different databases, i.e:
Pdb1 -> Stdby1
Pdb2 -> Stdby2
PdbN -> StdbyN
Table T1 is at Pdb1 , table T2 is at Pdb2
T1 has a Pkey , T2 has a Fkey to PKey on T1( for example a master / detail relation ship)
and so on
Some times due to network latency (or other event) table T2 gets replicated before than T1 and replcation stops due to primary constraint violation, even though the PK exists on T1 ( but hasn't been replicated yet).
Q: Is there any way to ensure that T1 would get replicated first in order to avoid the error?