工业版10.2，结转上年数据时出错。请教达人！

testfirst

工业版10.2，结转上年数据时出错。请教达人！

testfirst

log系统日志

[2009.1.15 13:18:10]strstr("GL,CS,IM,CV",szSub) == NULL
[2009.1.15 13:18:10]enter countsubsys
[2009.1.15 13:18:10]szsub = DP
[2009.1.15 13:18:10]strstr("GL,CS,IM,CV",szSub) == NULL
[2009.1.15 13:18:10](zzd) 2 TRUE szCom (SERVER@0) szsub = (DP) nCount=1
[2009.1.15 13:18:10]enter countsubsys
[2009.1.15 13:18:10]szsub = DP
[2009.1.15 13:18:10]strstr("GL,CS,IM,CV",szSub) == NULL
[2009.1.15 13:18:10](zzd) 2 FALSE szCom (SERVER@0) szsub = (DP) nCount=1
[2009.1.15 13:18:10]mdg 检查没有加密狗时nSubCount = 1
[2009.1.15 13:18:10]penghao  add computer=SERVER@0 subsys=DP
[2009.1.15 13:18:14](zzd1) 3  nCount=41
[2009.1.15 13:19:29]strstr("GL,CS,IM,CV",szSub) == NULL
[2009.1.15 13:19:29]enter countsubsys
[2009.1.15 13:19:29]szsub = AS
[2009.1.15 13:19:29]strstr("GL,CS,IM,CV",szSub) == NULL
[2009.1.15 13:19:29](zzd) 2 TRUE szCom (SERVER@0) szsub = (AS) nCount=0
[2009.1.15 13:19:29]enter countsubsys
[2009.1.15 13:19:29]szsub = AS
[2009.1.15 13:19:29]strstr("GL,CS,IM,CV",szSub) == NULL
[2009.1.15 13:19:29](zzd) 2 FALSE szCom (SERVER@0) szsub = (AS) nCount=0
[2009.1.15 13:19:29]mdg 检查没有加密狗时nSubCount = 0
[2009.1.15 13:19:29]penghao  add computer=SERVER@0 subsys=AS

jimmy851228

后面的图也要看下，后面应该是数据表名,看看哪个表出错了，
然后用跟踪看以下，是什么记录有错

testfirst

出错前的最后一段sql
select * from  CREATE   View [dbo].[zpurRkdTail] AS SELECT RdRecords.AutoID, RdRecords.ID, RdRecords.cInvCode, Inventory.cInvAddCode, Inventory.cInvName, Inventory.cInvStd, Inventory.cInvM_Unit,        Inventory.cInvA_Unit, Inventory.bService, Inventory.cInvCCode,        (CASE WHEN (RdRecords.iNum=0 Or RdRecords.iNum IS NULL) THEN null ELSE RdRecords.iInvExchRate END) AS iInvExchRate, Inventory.bInvBatch,        (CASE WHEN RdRecords.iNum=0 then null else RdRecords.iNum end ) as iNum, RdRecords.iQuantity, RdRecords.iUnitCost, RdRecords.iPrice, RdRecords.iAPrice, RdRecords.iPUnitCost, RdRecords.iPPrice, RdRecords.cBatch,        RdRecords.cVouchCode, RdRecords.cFree1, RdRecords.cFree2, RdRecords.iFlag, RdRecords.dSDate,        RdRecords.iTax,          RdRecords.iSNum,RdRecords.iSQuantity, RdRecords.iMoney, RdRecords.iSOutQuantity,        RdRecords.iSOutNum, RdRecords.iFNum, RdRecords.iFQuantity, RdRecords.dVDate, Inventory.cReplaceItem, RdRecords.cPosition, Inventory.cInvDefine1,         Inventory.cInvDefine2,Inventory.cInvDefine3,Inventory.bInvType, Inventory.iInvMPCost,        RdRecords.cDefine22,RdRecords.cDefine23,RdRecords.cDefine24,RdRecords.cDefine25,RdRecords.cDefine26,RdRecords.cDefine27,RdRecords.cItem_class,        RdRecords.cItemCode,RdRecords.iPosID,RdRecords.fACost,RdRecords.cName,RdRecords.cItemCName,RdRecords.cBlueID        FROM RdRecords LEFT JOIN Inventory ON RdRecords.cInvCode = Inventory.cInvCode
go
IF @@TRANCOUNT > 0 ROLLBACK TRAN
go

testfirst

好了，的确是2009年度的补丁问题。

yang_0901

恩 我也遇到过 不打补丁就没事了

falcon2008

看了下 来学习一下经验
补丁万不得已，还是不打的好