_tracking表的问题 [英] Problem with _tracking table

问题描述

您好，

        我有一个表'order_details'，它包括两个范围（scope1 - 在列orderid和amp; scope2上有过滤器 - 在列产品上有过滤器）。服务器将scope1与client1同步，scope2
与client2同步。

我配置了scope1没有问题。但试图配置范围2但遇到麻烦。它表示如果SetCreateDefaultTracking是Skip，_tracking表已经存在。当我将SetCreateDefaultTracking
设置为Create时，它表示无效的列'product'（我知道它将抛出此错误，因为已存在的_tracking表不包含列'product'）。

是否可以将单个表包含在具有两个不同filtercolumns的两个不同作用域中？

如果是，我如何在_tracking表中添加product列并设置scope2？

 

-Ajinath

解决方案

嗨Ajinath，

 

您可以使用SAME过滤器列（具有不同的子句）在两个不同的范围中包含单个表。  但是，配置API不支持在现有配置表上配置新的筛选器列，因此您不能为同一个表上的每个范围设置
不同的筛选器列。  这将在下一个版本中得到支持。

与此同时，如果您跳过第二个范围上的跟踪表创建但仍保留过滤器，则可能会自行破解它列集并设置创建附加枚举过程标志。  然后在完成Apply之后（假设
它实际工作）在跟踪表上手动创建过滤器列并填充它。

-Jesse

Hello,

         I have one table 'order_details' which includes in two scopes (scope1 - with filter on column orderid & scope2 - with filter on column product). The server syncronizes scope1 with client1 and the scope2 with client2.

I provisioned the scope1 with no problem. But trying to provision the scope2 but getting into trouble. It says _tracking table already exists if SetCreateDefaultTracking is Skip. It says invalid column 'product' when I set the SetCreateDefaultTracking to Create (I understand that it will throw this error as _tracking table that already exists does not contain the column 'product').

Is it possible to have single table included in two different scopes with two different filtercolumns?

If yes, How can I add the product column in _tracking table and provision the scope2?

 

-Ajinath

解决方案

Hi Ajinath,

 

You CAN have a single table included in two different scopes with the SAME filter column (with different clauses).  However the provisioning API does NOT support provisioning a new filter column on an existing provisioned table, so you cannot have a different filter column for each scope on the same table.  This will be supported in the next release.

In the mean time you might be able to hack it up yourself if you skip the tracking table creation on the second scope but keep the filter column set and set the create additional enumeration procedures flag.  Then after finishing the Apply (assuming it actually worked) manually create the filter column on the tracking table and populate it.

-Jesse

这篇关于_tracking表的问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！