KIS 专业版 9.2升级至KIS 专业版14.1提示如下
金蝶云社区-YYKDWGS
YYKDWGS
0人赞赏了该文章 724次浏览 未经作者许可,禁止转载编辑于2015年10月26日 11:37:13

KIS 专业版升级的时候 提示这一个:数据库升级失败!SQL文件不全或SQL语句有误!
错误描述:违反了 PRIMARY KEY 约束 'PK_ICSelbills'。不能在对象 'ICSelbills' 中插入重复键。
Sql文件名:d:\Program Files\Kingdee\KIS\Profession\Common\SqlSrv\SP_KISV91_IndustryData.sql
Sql内容:--BT177708--070313--End
--BT179288--20070319--Begin
--主管
Insert Into ICSelBills Values('A97','FRSCBillInterID','FManagerID',2,0,'FManagerID','FManagerID','ICStockBill','v1','',0,0)
Insert Into ICSelBills Values('A97','FRSCBillInterID','FManagerID',2,1,'FManagerIDName','FName','t_Emp','t14_2','',0,0)
Insert Into ICSelBills Values('A97','FRSCBillInterID','FManagerID',2,2,'FManagerIDNumber','FNumber','t_Emp','t14_2','',0,0)
Insert Into ICTableRelation Values(0,53,'ICStockBill','v1','FManagerID','t_Emp','t14_2','FItemID','*=','A97','FRSCBillInterID',0,0,'','','','=',0,0,'')
--业务员
Insert Into ICSelBills Values('A97','FRSCBillInterID','FEmpID',2,0,'FEmpID','FEmpID','ICStockBill','v1','',0,0)
Insert Into ICSelBills Values('A97','FRSCBillInterID','FEmpID',2,1,'FEmpIDName','FName','t_Emp','t14_3','',0,0)
Insert Into ICSelBills Values('A97','FRSCBillInterID','FEmpID',2,2,'FEmpIDNumber','FNumber','t_Emp','t14_3','',0,0)
Insert Into ICTableRelation Values(0,54,'ICStockBill','v1','FEmpID','t_Emp','t14_3','FItemID','*=','A97','FRSCBillInterID',0,0,'','','','=',0,0,'')