Solved

SQL Server Alert System: 'Replication: agent failure'

Posted on 2014-10-01
6
714 Views
Last Modified: 2014-10-08
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?
0
Comment
Question by:enrique_aeo
  • 3
  • 2
6 Comments
 
LVL 46

Assisted Solution

by:Vitor Montalvão
Vitor Montalvão earned 500 total points
ID: 40356801
You are replicating a record that already exists, that's why it raised the PK violation error. It even says the problematic record: (0401 , 02, 20546801471).
0
 

Author Comment

by:enrique_aeo
ID: 40356863
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
0
 
LVL 46

Assisted Solution

by:Vitor Montalvão
Vitor Montalvão earned 500 total points
ID: 40356889
I think you may need to use a Merge Replication (replicates only differences between two tables) instead of Transactional Replication.
0
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 

Author Comment

by:enrique_aeo
ID: 40363956
You have a guide or manual on how to do this configuration?
0
 
LVL 46

Accepted Solution

by:
Vitor Montalvão earned 500 total points
ID: 40365321
Check the tutorial from MSDN.
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 40367455
Or if you prefer the same in Spanish.  No points please.
0

Featured Post

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Viewers will learn how the fundamental information of how to create a table.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

895 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now