虚拟目录重建问题 [英] Virtual Catalog Rebuild Problem

问题描述

大家好，

我有一个2009 R2安装，它在虚拟目录重建方面表现出一些奇怪的行为。方案如下：

• 用户使用Catalog Manager在我们的基本目录中打开产品，并对一个产品进行更改它的属性（例如，显示名称）
• 用户保存并关闭产品编辑对话框。
• 然后，用户单击包含已编辑产品的虚拟目录，提示重建目录。
• 用户点击"是"。
• 用户在虚拟目录中打开产品，并可以验证基本目录中更改的属性是否反映在虚拟目录中。

所有这一切都是应该的。

但是，重建通知似乎取决于WHICH字段在基础目录。用户更改的某些字段似乎不会触发重新构建虚拟目录的需要。另一个有趣的事情是，如果
用户更改了至少一个触发重建的字段，那么所有相关字段都会在虚拟目录中更新。

我找到了Commerce Server产品目录 数据库中名为"dbo.VirtualProperties"的表，它有两列：CatalogName和PropertyName。当我查询此表时，我发现不会触发虚拟
目录重建需要的产品属性在表中，并且那些触发重建的字段不是。 

该表似乎记录了直接在虚拟目录中修改的字段。有没有人知道这是否正确？如果是这样的话，很明显，在某些时候，给我们悲伤的字段无意中直接在虚拟目录中编辑了
，现在因此而不是允许在基本目录中编辑相同字段时触发重建。我可以从"dbo.VirtualProperties"中删除有问题的字段吗？手动表恢复它们
到正常运行？

这是基于我在系统中观察到的所有猜想，所以我希望有人可以告诉我是否我在我的假设中是正确的，还是我应该在其他地方寻找。

问候并感谢，

唐

 

解决方案

唐，

我认为下面的文章将解答您的问题。

http://microsoftblog.co.in / commerceserver /重装碱基目录数据 - 到 - 虚拟目录/

Hello all,

I have a 2009 R2 installation that's exhibiting some strange behavior in regards to virtual catalog rebuilds. The scenario is as follows:

• A user opens a product in our base catalog using Catalog Manager and makes a change to one of it's properties (Display Name, for example)
• The user Saves and Closes the product edit dialog.
• The user then clicks on a virtual catalog that contains the edited product, and is prompted to rebuild the catalog.
• The user clicks "Yes" and the catalog is rebuilt.
• The user opens the product in the virtual catalog and can verify that the property changed in the base catalog is reflected in the virtual catalog.

All of this is as it should be.

However, it appears that the rebuild notice is dependant upon WHICH fields are changed in the base catalog. Certain fields that the user changes DO NOT seem to trigger a need for the virtual catalog to be re-built. Another interesting thing is that if the user changes at least one field that triggers a rebuild, then all of the fields in question get updated in the Virtual catalog.

I have found a table in the Commerce Server product catalog database called "dbo.VirtualProperties", which has two columns: CatalogName and PropertyName. When I query this table I see that the product properties that do not trigger a need for a virtual catalog rebuild are in the table, and, those fields that do trigger a rebuild are not. 

It seems that this table is holding a record of the fields that have been modified directly in the Virtual catalogs. Does anyone know if this is correct? If so, it's apparent that, at some point, the fields that are giving us grief have been inadvertently edited directly in the virtual catalogs and are now, as a result, not allowing a rebuild to be triggered when those same fields are edited in the base catalog. Can I remove the offending fields from the "dbo.VirtualProperties" table manually to restore them to normal operation?

This is all conjecture based on what I'm observing in our system, so I'm hoping someone can tell me whether I'm correct in my assumptions or whether I should be looking elsewhere.

Regards and thanks,

Don

 

解决方案

Don,

I think below article will address your questions.
http://microsoftblog.co.in/commerceserver/reload-base-catalog-data-into-virtual-catalog/

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