K/3WISE15.1账套迁移至旗舰版7.0，在迁移基础资料时报错：违反了 PRIMARY KEY 约束“PK_t_SubMessage”

栏目：kis知识作者：金蝶来源：金蝶云社区发布：2024-09-22浏览：1

【问题描述】

K/3WISE15.1账套迁移至旗舰版7.0，在迁移基础资料时报错：违反了 PRIMARY KEY 约束“PK_t_SubMessage”。不能在对象“dbo.t_SubMessage”中插入重复键。重复键值为 (110228)。

【原因分析】

K/3WISE15.1源账套t_SubMessage与旗舰版系统预设数据冲突，导致迁移报错。

【解决方案】

可参考以下脚本执行处理：

delete t_SubMessage where FInterID in (110228,130124,130182,130185,130230,150206,220181,220187,220602,220625,220724,230181,230182,320124,320125,320323,320482,320584,320721,320803,320982,321088,321284,330183,330322,330621,330682,340702,350784,350822,360782,361122,370882,371081,371324,371421,371624,410304,420321,430122,440183,440184,441421,441723,441827,445121,445221,445323,450122,450322,500222,500223,500224,500225,500226,500227,510811,511422,511522,511721,511821,513321,520151,520421,522200,522230,522400,530121,532522,532526,532621,533103,533421,542100,542121,542300,542600,542621,610126,610403,620922,632100,632121,632123,632721,652100,710000,810102)

--请在K/3账套执行以上语句，执行后需要退出迁移工具重新迁移才生效

【注意事项】

正式账套执行脚本前请先做好备份，建议待在测试账套中核实无误后再在正式账套中执行。