Deadlock ao replicar BD
03/10/2006
0
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
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
Curtir tópico
+ 0
Responder
Posts
20/10/2006
Psergio.p
Caro amigo, nunca vi esse problema, sugiro que você chame um consultor SQL Server para acompanhar este problema com você!
Responder
Gostei + 0
Clique aqui para fazer login e interagir na Comunidade :)