t3升级U6时报错

johnnypp

环境是XP系统、SQL2000+sp4补丁，U6普及版V3.2
合同管理预置数据，dprd851_cm错误信息：-2147217900插入错误：列名或所提供值得数目与表定义不匹配。
执行如下语句出错：
--合同分组
insert AA_ColumnDic
values('CM_Groupref','cGroupID',Null,0,'合同分组编号',Null,0,1,1600,4,'ASC',0,Null,1,0,Null)
insert AA_ColumnDic
values('CM_Groupref','cGroupName',Null,1,'合同分组名称',Null,0,1,1600,4,Null,0,Null,1,0,Null)
insert AA_ColumnDic
values('CM_Groupref','cRemark',Null,2,'备注',Null,0,0,2000,1,Null,0,Null,0,0,Null)
--类型分类
insert AA_ColumnDic
values('CM_TypeClassref','cClassCode',Null,0,'类型分类编码',Null,0,1,1600,4,'ASC',0,Null,1,0,Null)
insert AA_ColumnDic
values('CM_TypeClassref','cClassName',Null,1,'类型分类名称',Null,0,1,1600,4,Null,0,Null,1,0,Null)
--类型
insert AA_ColumnDic
values('CM_QTyperef','cTypeCode',Null,0,'合同类型编码',Null,0,1,1000,4,'ASC',0,Null,1,0,Null)
insert AA_ColumnDic
values('CM_QTyperef','cTypeName',Null,1,'合同类型名称',Null,0,1,1600,4,Null,0,Null,1,0,Null)
insert AA_ColumnDic
values('CM_QTyperef','cClassCode',Null,2,'分类编码',Null,0,1,1000,4,Null,0,Null,0,0,Null)
insert AA_ColumnDic
values('CM_QTyperef','cClassName',Null,3,'分类名称',Null,0,1,1000,4,Null,0,Null,0,0,Null)
insert AA_ColumnDic
values('CM_QTyperef','cCharacter',Null,4,'合同性质',Null,0,1,1200,4,Null,0,Null,1,0,Null)
insert AA_ColumnDic
values('CM_QTyperef','cDirection',Null,5,'收支方向',Null,0,1,800,4,Null,0,Null,0,0,Null)
insert AA_ColumnDic
values('CM_QTyperef','cControlDot',Null,6,'合同控制点',Null,0,1,1600,4,Null,0,Null,0,0,Null)
insert AA_ColumnDic
values('CM_QTyperef','cControlType',Null,7,'合同控制类型',Null,0,1,3000,4,Null,0,Null,0,0,Null)
insert AA_ColumnDic
values('CM_QTyperef','decPermitError',Null,8,'执行允差',Null,0,1,1000,1,Null,0,Null,0,0,Null)
insert AA_ColumnDic
values('CM_QTyperef','cTemplate',Null,9,'合同模板',Null,0,1,1600,4,Null,0,Null,1,0,Null)
insert AA_ColumnDic
values('CM_QTyperef','cRemark',Null,10,'备注',Null,0,0,2000,1,Null,0,Null,0,0,Null)
--条款分类
insert AA_ColumnDic
values('CM_ClauseClassref','cClassCode',Null,0,'条款分类编码',Null,0,1,1600,4,'ASC',0,Null,1,0,Null)
insert AA_ColumnDic
values('CM_ClauseClassref','cClassName',Null,1,'条款分类名称',Null,0,1,1600,4,Null,0,Null,1,0,Null)
insert AA_ColumnDic
values('CM_ClauseClassref','cRemark',Null,2,'备注',Null,0,0,2000,1,Null,0,Null,0,0,Null)
--条款
insert AA_ColumnDic
values('CM_Clauseref','cClauseCode',Null,0,'条款编码',Null,0,1,1000,4,'ASC',0,Null,1,0,Null)
insert AA_ColumnDic
values('CM_Clauseref','cClauseName',Null,1,'条款名称',Null,0,1,1000,4,Null,0,Null,1,0,Null)
insert AA_ColumnDic
values('CM_Clauseref','cClassCode',Null,2,'条款分类编码',Null,0,0,1600,4,Null,0,Null,0,0,Null)
insert AA_ColumnDic
values('CM_Clauseref','cContent',Null,3,'条款内容',Null,0,1,2000,1,Null,0,Null,0,0,Null)
有遇到过这问题的大虾们帮忙解决下！先谢谢！

hj20762003

应该是少列了，看一下表结构 ，反少的列手工加工，试试

johnnypp

hj20762003 发表于 2013-8-14 08:04

                               
登录/注册后可看大图

应该是少列了，看一下表结构 ，反少的列手工加工，试试

好的谢谢！