Error number: 20598 The row was not found at the Subscriber when applying the replicated command.
来源:互联网 发布:重庆邮电大学人工智能 编辑:程序博客网 时间:2024/06/11 06:30
今天测试Replication遇到下面的错误:
The row was not found at the Subscriber when applying the replicatedcommand.(Source: MSSQLServer, Error number: 20598)
if @@trancount > 0 rollback tran
(Transaction sequence number: 0x0000004100000162000400000000, Command ID: 1)
这个错误说明了当发布服务器上执行的语句在订阅服务器上执行时无法在订阅服务器找到对应的数据,所以出错。在默认情况下,发布代理遇到错误时就会停止,所以后影响后面的发布执行。
解决这个问题的根本原因首先要查出那些数据不同步,可以使用DATADIFF工具验证两边数据,然后同步数据(或者重新初始化)。
查询是哪个Article出了问题可以使用下面的语句:
USE [distribution]
select * from dbo . MSarticles
where article_idIN(SELECT Article_idfrom MSrepl_commands
where xact_seqno= 0x0000004100000162000400000000)
结果如下(这个例子test表数据有问题):
但是发现那些数据不同步可能会花比较长的时间,为了能够让发布尽快同步,我们可以跳过事务复制中的错误。对于事务复制,有两种方法可以跳过在分发过程中遇到的错误:
· 分发代理的-SkipErrors参数,可用来跳过某种类型的错误。有错误的事务将不提交,但后续的事务将提交。
· sp_setsubscriptionxactseqno存储过程,可用来跳过一个或多个导致错误的事务。非SQL Server的订阅服务器没有此选项。
使用-SkipErrors参数,可以让代理将错误记录下来,而Agent继续运行。通常的做法是在DistributionAgent profile中使用“Continue On Data ConsistencyErrors”。如图:
注意:代理参数更改将在下次启动代理时生效。如果代理连续运行,您必须停止并重新启动代理。
更多详细信息参考:SkippingErrors in Transactional Replication:http://technet.microsoft.com/en-us/library/ms151331(v=sql.105).aspx
- Error number: 20598 The row was not found at the Subscriber when applying the replicated command.
- Error: HttpServlet was not found on the Java
- the error was not handled
- the disk was not found(Altiris)
- HttpServlet was not found on the Java
- HttpServlet was not found on the Java
- HttpServlet was not found on the Java
- no row with the given identifier was found: 200
- more than one row with the given identifier was found
- Multiple annotations found at this line: - The superclass "javax.servlet.http.HttpServlet" was not
- Install Hotfix for WSS(KB974989 x86) ERROR:The expected version of the product was not found on the system
- the zipalign tool was not found in the sdk
- the zipalign tool was not found in the sdk
- the zipalign tool was not found in the sdk
- the zipalign tool was not found in the sdk
- the zipalign tool was not found in the sdk
- the zipalign tool was not found in the sdk
- The requested URL was not found on the server
- 整合Struts2+JasperReport Web报表应用示例
- unity3d webplayer 截图实现
- 云计算还有哪些隐性成本?
- UML总结(对九种图的认识和如何使用Rational Rose 画图)
- Android Launcher——ui框架
- Error number: 20598 The row was not found at the Subscriber when applying the replicated command.
- ASP.Net中RadDatePicker控件对选中时间的判断
- tcgetattr函数的说明
- Flex内阴影实现
- 探讨Ilist<>与List<>
- Mongo官方文档翻译 (四)
- 深入解析MFC -- 句柄与对象的关系
- 用C语言实现面向对象程序设计(三)
- Struts1中动态actionForm的配置