Post reply

Replication Error

  • July 7, 2008 at 1:26 am

    #381514

    Hi ,

    I am getting an error when trying to replicate data from one database to another. I have set up the transactional replication which execute at given time. Now i am getting this error "The row was not found at the Subscriber when applying the replicated command." . and this "{CALL sp_MSdel_misBasic_Info (2532242)}

    Transaction sequence number and command ID of last execution batch are

    0x001C1D4C0000032F002500000000 and 1."

    I have checked table misbasic_info. Record is exist in database 1 for given id 2532242. but not present in second database.

    So my question is-- will all the data from table 1 transfer in database 2 after replication or not and what is the solution for this error.

  • July 15, 2008 at 11:23 pm

    #843516

    Hi, This error occurs when distribution agent attempts to update a row at the Subscriber level, but the row has been deleted or the primary key of the row has been changed and as you said that the row is not present at the subscriber level.

    To rectify this error you can specify the parameter -SkipErrors 20598 for the Distribution Agent. This allows the agent to skip changes that result in error 20598, while allowing other changes to be replicated.

    else you can add the row that has been deleted or removed at the subscriber. also check for the constraints at the publisher level, like primary key.

  • July 16, 2008 at 6:17 am

    #843713

    Thanks dear.

  • July 16, 2008 at 7:41 am

    #843758

    most welcome;)

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply