| Update with Replication is not OK!!! [message #75402] |
Mon, 03 November 2003 05:40  |
pg
Messages: 12
Registered: May 2002
|
Junior Member |
|
|
I have a problem with the replication. I have two table (A1 site A and A1 site B) in replication of type sync. When I do insert into A1 of B the replication do insert in A1 of A. In A1 of site A there is a trigger that it do a update in other table A2 (site A) that is replicate in site B in mode async. The update on A2 site A is OK but in A2 of site B is non OK.
Why?
Can you help me?
Thank you
|
|
|
|
| Re: Update with Replication is not OK!!! [message #75405 is a reply to message #75402] |
Tue, 04 November 2003 12:54  |
James
Messages: 120
Registered: June 2000
|
Senior Member |
|
|
|
I suspect you are getting a mutating table error. This is caused because the status of the first transaction is still in flux (until the commit of the trigger/rep on the second table). It would also help to know if this is an after or before trigger. In either case, you best bet is to seperate the transactions, and allow the first transaction to complete before attempting the second one.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
