U8 12.1升级12.5 报错

lfyhb

数据库名: UFDATA_002_1999
C:\U8SOFT\Admin\SQLFILE12500\Main\Ufdata\data\NL\data_data_crm_initmk_nl.sql
错误信息:
-2147217873
违反了 PRIMARY KEY 约束 'PK_TC_TYPE'。不能在对象 'dbo.tc_type' 中插入重复键。

执行如下语句时出错:
----DATE 10月19
----预制部门销售计划  业务员销售计划
if not exists(select * from tc_type where obj_type =222)
BEGIN
INSERT INTO tc_type (obj_type,type_id,type_code,type_name,type_intro,arap_flag,create_enable,delivered_close_flag,payed_close_flag,finish_ahead_flag,finish_past_flag,disp_order,stop_flag,identify_code,server_flag,ext_fld,audit_flow_id,bDefault,u8_type_id,u8type,bSample) values(N'222',N'101',N'001',N'周部门销售目标',N'周部门销售目标',N'0',N'0',N'0',N'0',N'0',N'0',N'0',N'0',N'',N'',N'',N'0',N'',N'',N'',N'');
INSERT INTO tc_type (obj_type,type_id,type_code,type_name,type_intro,arap_flag,create_enable,delivered_close_flag,payed_close_flag,finish_ahead_flag,finish_past_flag,disp_order,stop_flag,identify_code,server_flag,ext_fld,audit_flow_id,bDefault,u8_type_id,u8type,bSample) values(N'222',N'102',N'002',N'周业务员销售目标',N'周业务员销售目标',N'0',N'0',N'0',N'0',N'0',N'0',N'0',N'0',N'',N'',N'',N'0',N'',N'',N'',N'');
INSERT INTO tc_type (obj_type,type_id,type_code,type_name,type_intro,arap_flag,create_enable,delivered_close_flag,payed_close_flag,finish_ahead_flag,finish_past_flag,disp_order,stop_flag,identify_code,server_flag,ext_fld,audit_flow_id,bDefault,u8_type_id,u8type,bSample) values(N'222',N'103',N'003',N'月部门销售目标',N'月部门销售目标',N'0',N'0',N'0',N'0',N'0',N'0',N'0',N'0',N'',N'',N'',N'0',N'',N'',N'',N'');
INSERT INTO tc_type (obj_type,type_id,type_code,type_name,type_intro,arap_flag,create_enable,delivered_close_flag,payed_close_flag,finish_ahead_flag,finish_past_flag,disp_order,stop_flag,identify_code,server_flag,ext_fld,audit_flow_id,bDefault,u8_type_id,u8type,bSample) values(N'222',N'104',N'004',N'月业务员销售目标',N'月业务员销售目标',N'0',N'0',N'0',N'0',N'0',N'0',N'0',N'0',N'',N'',N'',N'0',N'',N'',N'',N'');
INSERT INTO tc_type (obj_type,type_id,type_code,type_name,type_intro,arap_flag,create_enable,delivered_close_flag,payed_close_flag,finish_ahead_flag,finish_past_flag,disp_order,stop_flag,identify_code,server_flag,ext_fld,audit_flow_id,bDefault,u8_type_id,u8type,bSample) values(N'222',N'105',N'005',N'季部门销售目标',N'季部门销售目标',N'0',N'0',N'0',N'0',N'0',N'0',N'0',N'0',N'',N'',N'',N'0',N'',N'',N'',N'');
INSERT INTO tc_type (obj_type,type_id,type_code,type_name,type_intro,arap_flag,create_enable,delivered_close_flag,payed_close_flag,finish_ahead_flag,finish_past_flag,disp_order,stop_flag,identify_code,server_flag,ext_fld,audit_flow_id,bDefault,u8_type_id,u8type,bSample) values(N'222',N'106',N'006',N'季业务员销售目标',N'季业务员销售目标',N'0',N'0',N'0',N'0',N'0',N'0',N'0',N'0',N'',N'',N'',N'0',N'',N'',N'',N'');
END

cderpll

hh,,,,,,,,,,,,,,路过，，，，，，，，，，，，，，

无尘123

删除dbo.tc_type表中重复项

cderpll

这是用友U8 一个BUG ，v12.0升级到12.5也有一样的提示，题主解决问题没？

695804083

根本看不懂

hallymm

好像很复杂很厉害哦。。按提示操作呗