账套升级报错【零售(RE)】模块的SQL脚本DATA DSTR RE Mix NL-16678 出错:已在列上绑定了 DEFAULT

问题现象 :账套升级报错“DATA DSTR RE Mix NL-16678 出错:已在列上绑定了 DEFAULT”

原因分析: 客户数据有问题

解决方案:

（注：执行脚本前请做好数据备份！！！）

1、帐套库执行脚本 SELECT dc.name AS DefaultConstraintName FROM sys.default_constraints AS dc JOIN sys.columns AS c ON dc.parent_object_id = c.object_id AND dc.parent_column_id = c.column_id WHERE c.object_id = OBJECT_ID('RE_Retail_b') AND c.name = 'iscancel';

2.用步骤1中查询出来的结果替换DF_RE_Retailiscan_54EDF2A5后,再在帐套库执行以下脚本 ALTER TABLE [dbo].[RE_Retail_b] DROP CONSTRAINT DF_RE_Retailiscan_54EDF2A5;

3.重新升级即可