从OrderTemplatesAndBaskets中删除匿名购物车 [英] Deleting anonymous carts from OrderTemplatesAndBaskets

问题描述

我无法使用清除工具Purgecommercedata.exe。由于该实用程序不起作用，我很想通过SQL查询从OrderTemplatesAndBaskets表中删除记录。我想知道这是否会产生其他问题。

几秒钟后出现错误：

未处理的异常：Microsoft.CommerceServer.Runtime.Orders.SqlSchemaValidation

I was not able to use the purge tool Purgecommercedata.exe. Since the utility is not working, I am tempted to delete records from OrderTemplatesAndBaskets table thru a sql query. I want to know if this will create other issues.


It errors out after few seconds:

Unhandled Exception: Microsoft.CommerceServer.Runtime.Orders.SqlSchemaValidation

例外：订单存储中引用的列Shipments.ShipmentTrackingNumber

Exception: Column Shipments.ShipmentTrackingNumber referenced in Orders storage

映射文件的精度与SQL sch

mapping file has different precision than the corresponding entry in the SQL sch

ema中的相应条目不同。

ema.

推荐答案

在OrderTemplatesAndBaskets上删除带有sql查询的篮子没有问题....显然我建议在夜间进行，以尽量减少使用该网站的客户的问题。会看到他们的篮子被移除并且只删除旧的篮子。

there are no issues deleting baskets with a sql query on the OrderTemplatesAndBaskets.... obviously I would recommend to do it during the night to minimize issues for customers that are using the web site and would see their basket removed and to delete only old baskets.

Stelio

这篇关于从OrderTemplatesAndBaskets中删除匿名购物车的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！