Solved

SQL Server Alert System: 'Replication: agent failure'

Posted on 2014-10-01
6
761 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
6 Comments
 
LVL 49

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 49

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
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 

Author Comment

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

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

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
I have a large data set and a SSIS package. How can I load this file in multi threading?
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

733 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