迷你版11.0升级15.0,往来单位报错升级失败

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

迷你版11.0升级15.0,往来单位报错升级失败

迷你版11.0升级专业版15.0往来单位升级失败,提示:升级失败,原因: 用于插入T_Organization客户数据的SQL语句执行错误: INSERT INTO T_Organization(FShortNumber,FItemID,FNumber,FName,FAddress,FPostalCode,FFax,FPhone,FContact,FTaxNum,Fbank,Faccount,FStatus,FValueAddRate) SELECT T1.FShortNumber,T1.FItemID,T1.FNumber,T1.FName,T2.FAddress,T2.FZip,T2.FFax,T2.FPhone,T2.FContact,T2.FTax,T2.FBank,T2.FBank,1072,17 FROM T_Item T1,AIS_GLCust T2,AIS_GLObj T3 WHERE T1.FShortNumber = T3.FObjID AND T2.FObjID = T3.FObjID AND T1.FItemClassID = 1 AND T1.FDetail=1 AND T3.FClsID = 1 AND T1.FItemID NOT IN (SELECT FItemID FROM T_Organization)用于插入T_Supplier供应商数据的SQL语句执行错误: INSERT INTO T_Supplier(FShortNumber,FItemID,FNumber,FName,FAddress,FPostalCode,FFax,FPhone,FContact,FTaxNum,Fbank,Faccount,FStatus,FValueAddRate) SELECT T1.FShortNumber,T1.FItemID,T1.FNumber,T1.FName,T2.FAddress,T2.FZip,T2.FFax,T2.FPhone,T2.FContact,T2.FTax,T2.FBank,T2.FBank,1072,17 FROM T_Item T1,AIS_GLCust T2,AIS_GLObj T3 WHERE T1.FShortNumber = T3.FObjID AND T2.FObjID = T3.FObjID AND T1.FItemClassID = 8 AND T1.FDetail=1 AND T3.FClsID = 1 AND T1.FItemID NOT IN (SELECT FItemID FROM T_Supplier) 如图:

哪位能帮忙解决下这个问题,谢谢

一样的问题,这个怎么解决的?



请问下是在32位数据库中升级执行报错么,是什么版本的数据库
方便把源账套账套发送至xingchi_zhou@kingdee.com

迷你版11.0升级15.0,往来单位报错升级失败

迷你版11.0升级专业版15.0往来单位升级失败,提示:升级失败,原因: 用于插入T_Organization客户数据的SQL语句执行错误: INSERT INTO ...
点击下载文档
分享:
确认删除?
回到顶部
客服QQ
  • 客服QQ点击这里给我发消息