Deadlock ao replicar BD

SQL Server

03/10/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


Pan7

Pan7

Curtidas 0

Respostas

Psergio.p

Psergio.p

03/10/2006

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


GOSTEI 0
POSTAR