年度结转红叉错误-用友U8

对应版本:用友U8.52对应产品线：公共平台对应模块：系统管理模块问题现象:没打结转补丁之前结转时提示‘销售系统结转失败’，打了结转补丁之后出现红叉错误。问题原因：执行最新hotfix，替换最新年结补丁usgxljz.dll文件。事件跟踪器分析跟踪：SP:StmtCompletedSELECTstatman([id],@PSTATMAN)FROM(SELECTTOP100PERCENT[id]FROM[dbo].[QuoTmp]WITH(READUNCOMMITTED,SAMPLE1.000000e+002PERCENT)ORDERBY[id])AS_MS_UPDSTATS_TBLOPTION(BYPASSOPTIMIZER_QUEUE,MAXDOP1)U8管理软件〖系统管理〗57ExceptionError:547,Severity:16,State:0U8管理软件〖系统管理〗57SQL:BatchCompletedinsertintosa_quomainselectcSTCode,dDate,cCode,cCusCode,cDepCode,cPersonCode,cSCCode,cCusOAddress,cPayCode,cexch_name,iExchRate,iTaxRate,cMemo,cMaker,cVerifier,cCloser,cDefine1,cDefine2,cDefine3,cDefine4,cDefine5,cDefine6,cDefine7,cDefine8,cDefine9,cDefine10,a.ID,iVTid,nullasufts,cBusType,cDefine11,cDefine12,cDefine13,cDefine14,cDefine15,cDefine16fromUFDATA_003_2004..sa_quomainasainnerjoinUFDATA_003_2004..quotmpbona.id=b.idU8管理软件〖系统管理〗57将上述‘insertintosa_quomainselect...’语句在sql查询分析器中执行，返回错误信息如下：服务器:消息547，级别16，状态1，行1INSERT语句与COLUMNFOREIGNKEY约束’SA_QuoMain_cCusCode_FK’冲突。该冲突发生于数据库’UFDATA_003_2005’，表’Customer’,column’cCusCode’。语句已终止。――》表明05年基础档案与上年不符。查询：selectcount(*)fromufdata_003_2004..customer240selectcount(*)fromufdata_003_2005..customer239缺少一条记录。fTransInQuantity,fTransInNum,fTransOutQuantity,fTransOutNum,fPlanQuantity,fPlanNum,fDisableQuantity,fDisableNum,fAvaQuantity,fAvaNum,dMDate,dVDate,iMassDate,bgspstop,bStopFlag)SELECTAA.cWhCode,AA.cInvCode,AA.cFree1,AA.cFree2,AA.cFree3,AA.cFree4,AA.cFree5,AA.cFree6,AA.cFree7,AA.cFree8,AA.cFree9,AA.cFree10,AA.cBatch,AA.iQuantity,AA.iNum,AA.fOutQuantity,AA.fOutNum,AA.fInQuantity,AA.fInNum,AA.fTransInQuantity,AA.fTransInNum,AA.fTransOutQuantity,AA.fTransOutNum,AA.fPlanQuantity,AA.fPlanNum,AA.fDisableQuantity,AA.fDisableNum,AA.fAvaQuantity,AA.fAvaNum,AA.dMDate,AA.dVDate,AA.iMassDate,AA.bgspstop,AA.bStopFlagFROMUFDATA_003_2004..CurrentStockAA将上述红色语句在sql查询分析器中执行，返回错误信息如下：服务器:消息547，级别16，状态1，行1INSERT语句与COLUMNFOREIGNKEY约束’FK__CurrentSt__cInvC__6581EB1C’冲突。该冲突发生于数据库’UFDATA_003_2005’，表’Inventory’,column’cInvCode’。语句已终止。服务器:消息547，级别16，状态1，行1INSERT语句与COLUMNFOREIGNKEY约束’FK__CurrentSt__cWhCo__776B912D’冲突。该冲突发生于数据库’UFDATA_003_2005’，表’Warehouse’,column’cWhCode’。语句已终止。――》表明05年基础档案与上年不符。查询：selectcount(*)fromufdata_003_2004..inventory1160selectcount(*)fromufdata_003_2005..inventory1153缺少7条记录。selectcount(*)fromufdata_003_2004..warehouse12selectcount(*)fromufdata_003_2005..warehouse10缺少2条记录。解决方法：简便起见，直接通过sql企业管理器的dts导入基础档案表inventory、warehouse即可。结转成功！解决方案：简便起见，直接通过sql企业管理器的dts导入基础档案表inventory、warehouse即可。

本文链接：https://www.bbsufida.com/u8/41527.html