采购价目表保存报错
金蝶云社区-LeoGuo
LeoGuo
0人赞赏了该文章 766次浏览 未经作者许可,禁止转载编辑于2015年11月18日 21:22:09


修改了“单价”之后点击保存等了很久,然后就报出这样的错误来了。
请问有人遇到过这样的情况么?怎样解决呢????
价目表明细数据行5000行以上,能监视到有执行数据库,但执行完就会报这样的错误。请大神帮忙帮忙解决一下,谢谢!!

下面数据库执行语句最后的片段:
exec sp_executesql N'UPDATE t_PUR_PriceListEntry SET FMODIFIERID = @FMODIFIERID WHERE FEntryID = @OID',N'@FMODIFIERID bigint,@OID bigint',@FMODIFIERID=180880,@OID=147456
go
exec sp_executesql N'UPDATE t_PUR_PriceListEntry SET FMODIFIERID = @FMODIFIERID WHERE FEntryID = @OID',N'@FMODIFIERID bigint,@OID bigint',@FMODIFIERID=180880,@OID=147457
go
exec sp_executesql N'UPDATE t_PUR_PriceListEntry SET FMODIFIERID = @FMODIFIERID WHERE FEntryID = @OID',N'@FMODIFIERID bigint,@OID bigint',@FMODIFIERID=180880,@OID=147458
go
exec sp_reset_connection
go
SET FMTONLY OFF; SET NO_BROWSETABLE ON;SELECT T_BOS_COMPUTETASK.FExecutorType, T_BOS_COMPUTETASK.FProperties, T_BOS_COMPUTETASK.FBOSContext, T_BOS_COMPUTETASK.FLog, T_BOS_COMPUTETASK.FComputeId, T_BOS_COMPUTETASK.FTitle, T_BOS_COMPUTETASK.FPriority, T_BOS_COMPUTETASK.FStatus, T_BOS_COMPUTETASK.FProgress, T_BOS_COMPUTETASK.FOriginatorId, T_BOS_COMPUTETASK.FComputeSource FROM T_BOS_COMPUTETASK WHERE (T_BOS_COMPUTETASK.FSTATUS = 1 AND T_BOS_COMPUTETASK.FCOMPUTESOURCE = 'WINDOWS-CLKCDIC') SET NO_BROWSETABLE OFF;
go
exec sp_reset_connection
go
exec sp_executesql N' SET FMTONLY OFF; SET NO_BROWSETABLE ON;SELECT SINFO.FSCHEDULEID, SINFO.FSCHEDULETYPEID, SINFO.FEXECUTEINTERVAL, SINFO.FEXECUTEINTERVALUNIT, SINFO.FEXECUTETIME, SINFO.FBEGINTIME, SINFO.FENDTIME, STYPE.FSCHEDULECLASS, SINFO.FISASYNCJOB, SINFO.FSTATUS, SINFO.FPARAMETERFORMID, SINFO.FPARAMETERS FROM T_BAS_SCHEDULEINFO SINFO INNER JOIN T_BAS_SCHEDULETYPE STYPE ON SINFO.FSCHEDULETYPEID = STYPE.FSCHEDULETYPEID WHERE SINFO.FSCHEDULEID = @FSCHEDULEID',N'@FSCHEDULEID varchar(26)',@FSCHEDULEID='BOS_AsyncMessageProcessing'
go
exec sp_reset_connection
go
exec sp_executesql N'UPDATE T_BAS_SCHEDULEINFO SET FSTATUS = ''2'' WHERE (FSCHEDULEID = @FSCHEDULEID AND FSTATUS = @FSTATUS)',N'@FSCHEDULEID varchar(26),@FSTATUS varchar(1)',@FSCHEDULEID='BOS_AsyncMessageProcessing',@FSTATUS='0'
go
exec sp_reset_connection
go
SET FMTONLY OFF; SET NO_BROWSETABLE ON;SELECT TOP 1 FMessageID, FContext, FMessageObj, FServiceType, FSendServerIP FROM T_WF_AsyncSendMessage SET NO_BROWSETABLE OFF;
go
exec sp_reset_connection
go
exec sp_executesql N'UPDATE T_BAS_SCHEDULEINFO SET FEXECUTETIME = @FEXECUTETIME, FSTATUS = @FSTATUS, FNOTES = @FNOTES WHERE FSCHEDULEID = @FSCHEDULEID',N'@FEXECUTETIME datetime,@FSTATUS varchar(1),@FNOTES nvarchar(29),@FSCHEDULEID varchar(26)',@FEXECUTETIME='2015-11-18 21:00:21',@FSTATUS='0',@FNOTES=N'成功执行,完成时间:2015-11-18 20:59:33',@FSCHEDULEID='BOS_AsyncMessageProcessing'
go