从t+12.2升级到t+专属云时，报错

从12.2升级到专属云时，报错，具体看附件。

问题回复：

客户数据库出现损坏的情况，需要针对具体的数据库表中的数据做修复处理。 具体修复脚本如下： ALTER TABLE [dbo].[Eap_ColumnSet] ADD DEFAULT (0) FOR [IsSystem] GO ALTER TABLE [dbo].[Eap_ColumnSet] ADD DEFAULT (2) FOR [DecimalDigits] GO ALTER TABLE [dbo].[Eap_ColumnSet] ADD DEFAULT (0) FOR [NeedReSetBooleanTxt] GO ALTER TABLE [dbo].[Eap_ColumnSet] ADD DEFAULT ('是|否') FOR [BooleanTxt] GO ALTER TABLE [dbo].[Eap_ColumnSet] ADD DEFAULT (1) FOR [PropTitleCanChange] GO ALTER TABLE [dbo].[Eap_ColumnSet] ADD DEFAULT (1) FOR [IsAsSearchCategoryField] GO ALTER TABLE [dbo].[Eap_ColumnSet] ADD DEFAULT ('string') FOR [FieldType] GO ALTER TABLE [dbo].[Eap_ColumnSet] ADD DEFAULT (0) FOR [IsDevField] GO

-- 针对出入库明细的处理 UPDATE ST_RDRecord_b SET createdtime='2017-04-20 00:00:03.000',updated='2017-04-20' WHERE id='19964'; UPDATE ST_RDRecord_b SET createdtime='2018-08-04 00:00:26.000',updated='2018-08-04' WHERE id='69357'; GO

-- 针对销货单明细的处理 UPDATE SA_SaleDelivery_b SET updated = '2017-03-02 16:51:45.810' WHERE ID = 173 UPDATE SA_SaleDelivery_b SET updated = '2017-10-09 20:47:45.337', SingleInvGrossProfit = -18.2700000000000000 WHERE ID = 8297 GO

-- 针对销售订单明细的处理 UPDATE SA_SaleOrder_b SET executedQuantity = 600.00000000000000 WHERE id = 631 UPDATE SA_SaleOrder_b SET executedQuantity = 30.00000000000000, saleOutQuantity = 30.00000000000000 WHERE id = 2999 UPDATE SA_SaleOrder_b SET executedQuantity = 10.00000000000000 WHERE id = 3391 UPDATE SA_SaleOrder_b SET executedQuantity = 45.00000000000000, saleOutQuantity = 45.00000000000000 WHERE id = 3742 UPDATE SA_SaleOrder_b SET executedQuantity = 60.00000000000000 WHERE id = 5787 UPDATE SA_SaleOrder_b SET origDiscountAmount = ROUND(origDiscountPrice * quantity, 2) WHERE id = 15380 UPDATE SA_SaleOrder_b SET origDiscountAmount = 1140.00000000000000, discountAmount = 1140.00000000000000, taxPrice = 19.00000000000000, origTaxPrice = 19.00000000000000, taxRate = 0, discountPrice = 19.00000000000000, origDiscountPrice = 19.00000000000000 WHERE id = 16382 UPDATE SA_SaleOrder_b SET discountAmount = 185.0000000000000, origDiscountAmount = 185.0000000000000, taxAmount = 185.0000000000000, origTaxAmount = 185.0000000000000, tax = 0.00000000000000, origTax = 0.00000000000000, isPresent = 0 WHERE id = 12979 GO

-- 针对销售订单表头的处理 UPDATE SA_SaleOrder SET voucherdate = '2016-12-22 00:00:00.000', madedate = '2016-12-22 00:00:00.000', auditeddate = '2016-12-22 00:00:00.000', createdtime = '2016-12-22 13:36:04.387', updated = '2016-12-22 13:36:04.387' WHERE ID = 253 GO