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.
