删除匿名购物车OrderTemplatesAndBaskets [英] deleting anonymous carts OrderTemplatesAndBaskets

问题描述

我遇到以下错误

purgecommercedata.exe cs_e

store -b -d 20

：

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

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

映射文件的精度与SQL sch中的相应条目不同/ p>

ema。
我很想通过OrderTemplatesAndBaskets上的SQL删除查询删除无聊的购物车记录。我想确保在解决方案

-size：x-small"> OrderTemplatesAndBaskets你可以找到匿名和非匿名客户的所有篮子。
你可以删除该表上的数据，这样做是安全的。
我个人建议你只删除旧的篮子。

Stelio

I get following error running

purgecommercedata.exe cs_e

store -b -d 20

:

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

Exception: Column Shipments.ShipmentTrackingNumber referenced in Orders storage

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

ema.

I am tempted to delete anoymous cart records through a SQL delete query on OrderTemplatesAndBaskets. I want to make sure it is safe to directly delete records.

解决方案

on the OrderTemplatesAndBaskets you will find all the baskets, for either anonymous and non anonymous customers.
you can delete data on that table, and it is safe to do it.
personally I would suggest you to delete only old baskets.

Stelio

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