asked on

SQL Server Alert System: 'Replication: agent failure'

Hi experts:

I have this error:
SQL Server Alert System: 'Replication: agent failure' occurred on \\LZ-SRVBD
1 Recibidos x
Alertas del Servidor LZ-SRVBD1 <no_reply@2b5u ednea svepnt.u (rhaa.pcee> 4 días)
para guillermo.caba., mí
inglés español Traducir mensaje Desactivar para: inglés
DATE/TIME: 9/25/2014 8:45:29 AM
DESCRIPTION: Replication-Replication Distribution Subsystem: agent LZ-SRVBD1-
SIGM-Publicacion SIGM-L-SRVBD-15 failed. Violation of PRIMARY KEY constraint
'PK_CONTUP'. Cannot insert duplicate key in object 'dbo.CONTUP'. The duplicate key
value is (0401 , 02, 20546801471).
COMMENT: (None)
JOB RUN: (None)

I need to continue replication, to do?

SOLUTION

Vitor Montalvão

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

enrique_aeo

ASKER

How can I fix it?
I detail more about the scenario:
It is a transactional replication; replicates certain data Lima province to province and some data coming to Lima; the code that sets it apart for consistency is the province code so no collision data.
However we have problems with the information recorded in the systems; if inserted in duplicate (Lima and province) jumps replica errors.
That tool could capture the transactions made in the tables; eg I want to register that user made a particular transaction or to modify or delete data.
We use sql server 2008 r2
Thanks for the support

SOLUTION

Vitor Montalvão

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

enrique_aeo

ASKER

You have a guide or manual on how to do this configuration?

ASKER CERTIFIED SOLUTION

Vitor Montalvão

membership