在Orders WebService中初始化架构映射时出错

问题描述

全部好，

我为lineitems表引入了两个扩展属性，即Volume，Weight都是十进制的。这是从我的测试机器执行的，其中安装了商业服务器2007和sql服务器，它工作正常。

I had introduced two extended properties for lineitems table viz Volume, Weight both as decimal. When this is executed from my test machine where both commerce server 2007 and sql server are installed it works fine.

但是当我的生产中使用相同的设置时，Web和db服务器是两台不同的机器，orderswebservice中出现以下问题。你能不能给我一个workaroung ???

But when the same setup is taken to my production where Web and db servers are two different machines, the following problem occurs in orderswebservice. could you pls  sugges me a workaroung for this???

提前谢谢

[MappingException: Error initializing Schema mapping.  Details: Warning O0007 - Unknown XML node: Name='Scale'.
Warning O0008 - Unknown XML attribute Scale=2.
Warning O0007 - Unknown XML node: Name='Scale'.
Warning O0008 - Unknown XML attribute Scale=2.
Error G0032 - Column LineItems.Volume type decimal is not an allowed relational type
Error G0032 - Column LineItems.Weight type decimal is not an allowed relational type
]
   Microsoft.CommerceServer.Runtime.Orders.OrderContext.CreateSchemaAndPipelineMapping(SchemaMapping& schemaMapping, PipelineAdapter& pipelineAdapter, String appRootPath, CommerceOrdersConfiguration ordersConfiguration) +711
   Microsoft.CommerceServer.Runtime.Orders.OrderContext.Initialize(String transactionResourceConnectionString, String transactionConfigResourceConnectionString) +218
   Microsoft.CommerceServer.Runtime.Orders.OrderContext.Create(String transactionResourceConnectionString, String transactionConfigResourceConnectionString) +114
   Microsoft.CommerceServer.Runtime.Orders.CommerceOrderModule.CreateOrderContext() +68
   Microsoft.CommerceServer.Runtime.Orders.CommerceOrderModule.get_OrderContext() +87
   Microsoft.CommerceServer.Runtime.Orders.CommerceOrderModule.OnBeginRequest(Object sender, EventArgs e) +18
   System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +92
   System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +64

问候，

monzur

推荐答案

这篇关于在Orders WebService中初始化架构映射时出错的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！