从KIS旗舰版 v2.0升级到k/3 wise v13.1过程中出错,试了几次都出错,附件中有错误信息,请问如何处理解决,谢谢。
(此账套最早是从KIS专业版 V12.2升级到KIS旗舰版 v2.0)
环境:windows2003 sp2 企业版 + sql server 2005 sp4 企业版
环境2:windows2008 r2 sp1 企业版 +sql server 2008 r2 sp2
错误日志文件account.log内容如下:
执行文件C:\PROGRAM FILES (X86)\KINGDEE\K3ERP\KDSYSTEM\KDCOM\SqlSrv\SP_KSEV13.1ICTable.sql出错。
错误描述:违反了 PRIMARY KEY 约束“PK_ICClassTableInfo”。不能在对象“dbo.ICClassTableInfo”中插入重复键。重复键值为 (1024321, FID2)。
错误语句:
--TEAM=SCM,DBA=efeng_zhong TEL=2512
Update ICClassTableInfo SET FClassTypeID=1024321,FCondition='-1',FContainer='',FCtlType=3,FDspColType=500,FDSPFieldName='',FEditlen=255,FEnable=1,FFieldName='FID',FFilter='',FFilterGroup='',FFNDFieldName='',FFrameborder=0,FFrameBorderColor=0,FKey='FID2',FKeyWord='PARENTID',FLabelColor=0,FListClassName=0,FListIndex=104,FLock=24,FLookUpList='',FLookUpType=0,FNeedSave=1,FParentKey='',FPrec=0,FProperty='',FSaveRule='',FScale=0,FSourceType=0,FSRCFieldName='',FSRCTableName='',FSRCTableNameAs='',FStyle=0,FSubKey='',FSum=0,FTabIndex=-1,FTableName='t_PackagedGoodsEntry',FTableNameAs='',FTextColor=0,FUserDefine=1,FValueLocation=1,FCaption_CHS='单据内码',FCaption_CHT='單據內碼',FCaption_EN='Doc ISN',FFont='',FTop=120,FLeft=240,FConditionExt=0,FHeight=350,FLayer=0,FUnControl=12289,FWidth=1800,FVisible=0,FLookUpClassID=0,FValueType=56,FLabelWidth=0,FValuePrecision=4,FMustInput=1,FDefValue='',FAction='',FLoadAction='',FPage=2,FNote='' WHERE FID=20129
执行文件C:\PROGRAM FILES (X86)\KINGDEE\K3ERP\KDSYSTEM\KDCOM\SqlSrv\SP_KSEV13.1ICTable.sql出错。
错误描述:违反了 PRIMARY KEY 约束“PK_ICClassTableInfo”。不能在对象“dbo.ICClassTableInfo”中插入重复键。重复键值为 (1024321, FIndex2)。
错误语句:
--TEAM=SCM,DBA=efeng_zhong TEL=2512
Update ICClassTableInfo SET FClassTypeID=1024321,FCondition='-1',FContainer='',FCtlType=3,FDspColType=500,FDSPFieldName='',FEditlen=255,FEnable=1,FFieldName='FIndex',FFilter='',FFilterGroup='',FFNDFieldName='',FFrameborder=0,FFrameBorderColor=0,FKey='FIndex2',FKeyWord='INDEX',FLabelColor=0,FListClassName=0,FListIndex=105,FLock=-1,FLookUpList='',FLookUpType=0,FNeedSave=1,FParentKey='',FPrec=0,FProperty='',FSaveRule='',FScale=0,FSourceType=0,FSRCFieldName='',FSRCTableName='',FSRCTableNameAs='',FStyle=0,FSubKey='',FSum=0,FTabIndex=-1,FTableName='t_PackagedGoodsEntry',FTableNameAs='',FTextColor=0,FUserDefine=1,FValueLocation=1,FCaption_CHS='行号',FCaption_CHT='行號',FCaption_EN='Row No.',FFont='',FTop=120,FLeft=240,FConditionExt=0,FHeight=350,FLayer=0,FUnControl=12289,FWidth=1800,FVisible=0,FLookUpClassID=0,FValueType=56,FLabelWidth=0,FValuePrecision=4,FMustInput=0,FDefValue='',FAction='',FLoadAction='',FPage=2,FNote='' WHERE FID=20130
推荐阅读