Array
(
)

Deadlock ao replicar BD

Pan7
   - 03 out 2006

Tenho um BD fazendo replicação merge de 115 tabelas.

O erro abaixo tem ocorrido com certa frequencia:

{call sp_MSenumchanges(?,?,?,?,?,?,?,?)}

The process could not enumerate changes at the ´Publisher´.
(Source: Merge Replication Provider (Agent); Error number: -2147200999)
---------------------------------------------------------------------------------------------------------------
Transaction (Process ID 86) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
(Source: CARGA_DESENV (Data source); Error number: 1205)
---------------------------------------------------------------------------------------------------------------
The process was successfully stopped.
(Source: Merge Replication Provider (Agent); Error number: -2147200999)
---------------------------------------------------------------------------------------------------------------

Alguém já teve este problema ?

[]s

Psergio.p
   - 20 out 2006

Caro amigo, nunca vi esse problema, sugiro que você chame um consultor SQL Server para acompanhar este problema com você!