Home Forums SQL Server 2005 SS2K5 Replication The row was not found at the Subscriber when applying the replicated command. RE: The row was not found at the Subscriber when applying the replicated command.

  • April 8, 2014 at 10:25 am

    #1704200

    Hi I have the same problem, and I would like to find the error instead of ignoring it with the agent profile option. I have gotten as far as G but I was not clear what to do next to actually find the dml statements so I could pin point what field is not getting updated. This is what i have so far, but need more information to really decipher a source. I ran two queries to get this far and got 28 results like this.

    0x0000024100069D510001NULLNULL530012NULLNULL0x00000000000000000000{CALL [dbo].[sp_MSdel_dbotblCIR_CircularPage] (5559)}1

    0x0000024100069D510001NULLNULL530016NULLNULL0x00000000000000000000{CALL [dbo].[sp_MSdel_dbotblCIR_CircularPage] (5690)}3

    0x0000024100069D510001NULLNULL530019NULLNULL0x00000000000000000000{CALL [dbo].[sp_MSdel_dbotblCIR_CircularPage] (5757)}5

    0x0000024100069D510001NULLNULL530036NULLNULL0x00000000000000000000{CALL [dbo].[sp_MSdel_dbotblCIR_CircularPage] (5519)}7

    0ShopRiteClientHosting1tblCIR_CircularPage5tblCIR_CircularPagedbotblCIR_CircularPageNULLNULL

    0ShopRiteClientHosting5tblCIR_CircularPage16tblCIR_CircularPagedbotblCIR_CircularPageNULLNULL

    0ShopRiteCRM6 tblTypes5tblTypesdbotblTypesNULLNULL

    0ShopRiteS2G2tblBrand5tblBranddbotblBrandNULLNULL

    0ShopRiteS2G2tblSale16tblSaledbotblSaleNULLNULL

    So it seems the issue is in tblCIR_CircularPage but that's as far as I gotten so far..

    Is it possible to find more info, like the actual query?

    Thanks!