Wednesday, March 21, 2012

Row Not Found Err w/ zero details

SQL 2005 Transactional Repl. Receiving row not found error. In SQL2000 you
could view the error details and see the exact sp call sp_MSUpdxxx command
that was trying to execute w/ param values.
Now in 2005 - this is the most detail I get below: How do I see what row
was missing? tia Chris
Command attempted:
if @.@.trancount > 0 rollback tran
(Transaction sequence number: 0x0019780A0001C586015500000000, Command ID: 1)
Error messages:
The row was not found at the Subscriber when applying the replicated
command. (Source: MSSQLServer, Error number: 20598)
Get help: http://help/20598
The row was not found at the Subscriber when applying the replicated
command. (Source: MSSQLServer, Error number: 20598)
Get help: http://help/20598
Chris - you should be able to use sp_briowsereplcmds which takes an optional
parameter of @.xact_seqno_start (and @.xact_seqno_end)
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
|||sp_browseprelcmds will give all commands to be replicated. I have many pubs
on that server along w/ other servers. Was this detail removed from repl
monitor?
"Paul Ibison" wrote:

> Chris - you should be able to use sp_briowsereplcmds which takes an optional
> parameter of @.xact_seqno_start (and @.xact_seqno_end)
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com .
>
>
|||Chris,
I was recommending using the optional parameters @.xact_seqno_start and
@.xact_seqno_end to filter the results.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .

No comments:

Post a Comment