Solved

SQL Server Alert System: 'Replication: agent failure'

Posted on 2014-10-01
6
666 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 45

Assisted Solution

by:Vitor Montalvão
Vitor Montalvão earned 500 total points
Comment Utility
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
Comment Utility
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 45

Assisted Solution

by:Vitor Montalvão
Vitor Montalvão earned 500 total points
Comment Utility
I think you may need to use a Merge Replication (replicates only differences between two tables) instead of Transactional Replication.
0
How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

 

Author Comment

by:enrique_aeo
Comment Utility
You have a guide or manual on how to do this configuration?
0
 
LVL 45

Accepted Solution

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

Expert Comment

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

Featured Post

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.

Join & Write a Comment

Suggested Solutions

Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

772 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

11 Experts available now in Live!

Get 1:1 Help Now