Replication Error | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Replication Error

Date6/17/2006 7:10:46 PM
LogJob History (ALDB01-LMS_DB-LMS_DB_Pub-ALDB02-LMS_DB-6468C29A-C8DA-4014-948D-460B5D4F1442) Step ID1
ServerALDB02
Job NameALDB01-LMS_DB-LMS_DB_Pub-ALDB02-LMS_DB-6468C29A-C8DA-4014-948D-460B5D4F1442
Step NameRun agent.
Duration1.14:00:47
Sql Severity0
Sql Message ID0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted0 Message
2006-06-19 13:11:32.906 Error executing a batch of commands. Retrying individual commands.
2006-06-19 13:11:33.171 Agent message code 547. The DELETE statement conflicted with the REFERENCE constraint "FK_Enrollment_Proficiencies_SH_Enrollments". The conflict occurred in database "LMS_DB", table "dbo.Enrollment_Proficiencies", column ‘FK_SH_Enrollment_ID’.
2006-06-19 13:11:33.171 Category:COMMAND
Source: Failed Command
Number:
Message: if @@trancount > 0 rollback tran
2006-06-19 13:11:33.187 Category:NULL
Source: Microsoft SQL Native Client
Number: 547
Message: The DELETE statement conflicted with the REFERENCE constraint "FK_Enrollment_Proficiencies_SH_Enrollments". The conflict occurred in database "LMS_DB", table "dbo.Enrollment_Proficiencies", column ‘FK_SH_Enrollment_ID’.
2006-06-19 13:11:33.187 Category:NULL
Source: Microsoft SQL Native Client
Number: 20598
Message: The row was not found at the Subscriber when applying the replicated command. we are getting tons of these errors. i found a site at msdn to have the replication "skip" this error and continue on to its next jobs. but i don’t really understand the error, or know how to go about fixing it. we also noticed that the servers were not synchronizing. we used the tablediff to check enrollment_proficiencies and there were so many inconsistencies. any help on this would be greatly appreciated.
See thishttp://www.replicationanswers.com/NoSyncInitializations.asp is any help. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided �AS IS� with no rights for the sake of knowledge sharing.
]]>