從12.2升級(jí)到專(zhuān)屬云時(shí)，報(bào)錯(cuò)，具體看附件。

問(wèn)題回復(fù)：

客戶數(shù)據(jù)庫(kù)出現(xiàn)損壞的情況，需要針對(duì)具體的數(shù)據(jù)庫(kù)表中的數(shù)據(jù)做修復(fù)處理。 具體修復(fù)腳本如下： 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

-- 針對(duì)出入庫(kù)明細(xì)的處理 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

-- 針對(duì)銷(xiāo)貨單明細(xì)的處理 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

-- 針對(duì)銷(xiāo)售訂單明細(xì)的處理 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

-- 針對(duì)銷(xiāo)售訂單表頭的處理 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