由于时间戳和排队事务，无法创建 sql server 复制订阅，但这是不对的
在Sql Server 2005 中，我们发布了一些表。 该出版物有 3 个 DB2 数据库推送订阅（使用 HIS2009 的连接器），并且已经订阅了几个月。 尝试添加另一个订阅，该订阅实际上与现有订阅相同，只是它是一个不同的服务器，我们得到：
SQL Server could not create a subscription for Subscriber 'MY-DATABASE-2'.
An exception occurred while executing a Transact-SQL statement or batch.
OLE DB or ODBC Subscribers cannot subscribe to article 'my_table_1' in publication
'my_publication' because the article has a timestamp column and the publication is
'allow_queued_tran' (allows queued updating subscriptions).
The subscription could not be found.
Microsoft SQL Server, Error 21249
但是：
- my_table_1 不包含时间戳列
- 该发布具有allow_queued_tran = False
- 该发布上还有其他成功的 OLE-DB DB2 订阅
- 其他发布中的表不包含时间戳。其中一些包含日期列，其 DB2 等效类型是“timestamp”，但 DB2 中的“timestamp”仅意味着（日期和时间），而不是系统生成的时间标记。
In Sql Server 2005, we have a publication of a few tables.
This publication has 3 push subscriptions to DB2 databases (using connector from HIS2009) and has had for several months.
Attempting to add another subscription, virtually identical to the existing ones except it's a distinct server, we get:
SQL Server could not create a subscription for Subscriber 'MY-DATABASE-2'.
An exception occurred while executing a Transact-SQL statement or batch.
OLE DB or ODBC Subscribers cannot subscribe to article 'my_table_1' in publication
'my_publication' because the article has a timestamp column and the publication is
'allow_queued_tran' (allows queued updating subscriptions).
The subscription could not be found.
Microsoft SQL Server, Error 21249
However:
- my_table_1 does not contain a timestamp column
- The publication has allow_queued_tran = False
- There are other successful OLE-DB DB2 subscriptions on this publication
- The other tables in the publication do not contain timestamp. Some of them contain date columns, for which the DB2-equivalent type is "timestamp", but "timestamp" in DB2 just means (a date and time) - not a system-generated time marker.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
奇怪的是，我们能够使用相同的表、过滤器等创建一个新的发布，并向其添加新的订阅。
所以，虽然没有真正得到答案，但已经解决了。
Curiously, we were able to create a new publication with the same tables, filters etc, and add new subscriptions to it.
So, it's resolved, though not really answered.
我今天遇到了同样的问题，但找不到解决方案。我删除了现有的订阅和发布，重新开始，然后它就起作用了。很奇怪的问题。
I had the same issue today, but could not find solution. I removed existing subscription and publication, started over and then it worked. Very strange issue.