SQL Server Performance

Replication Error

Discussion in 'SQL Server 2005 Replication' started by itznfb, Jun 19, 2006.

  1. itznfb New Member

    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.
  2. satya Moderator

Share This Page