Error 547 Replication

[ayepiz]

Hi!!

I have a problem with transactional replication.. The replication fails with this error:

DELETE statement conflicted with COLUMN REFERENCE constraint 'FK_Tramit_Regini'. The conflict occurred in database 'ENSENADAREPLICA', table 'Tramit', column 'TMT_CTRL'.

the number of the error is 547

please help me!!

 

[Bernadette]

Hi There

You are violating a foreign key constraint ('FK_Tramit_Regini') when doing the delete ....

do you have any Triggers on your tables ?

example
========
Say I have 3 tables A, B and C.
I have a foreign key constraint from C to B and from B to A.
So if I delete records in table A, the constraint will be violated before the trigger can do its job.


This may be the cause of your problem

Hope This Helps

Bernadette :->
Bernadette

 

[MikeTom]

If this is when replicating then your DB's are not the same because the transaction would have committed on the distributed db without violating the FK constraint but is violating the constraint on the subscribers end. you may need to synchronize the databases schema.