应付单审核时报错
金蝶云社区-云社区用户A1891234
云社区用户A1891234
0人赞赏了该文章 714次浏览 未经作者许可,禁止转载编辑于2015年12月03日 09:18:55

Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
语句已终止。

发生时间: 2015-12-03 09:15:39
错误编号: ExecuteBatch
错误信息: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
语句已终止。
Sql语句: INSERT INTO #TM_HS_HookRelation(FSrcBillTypeID,FSrcEntryID,FDesBillTypeID,FDesEntryID,FFlag)
SELECT PAY.FBillTypeID,PAYEntry.FEntryID,STK.FBillTypeID,STKEntry.FEntryID,1
FROM T_AP_PAYABLE_LK LK02
INNER JOIN T_AP_PAYABLEENTRY PAYEntry ON PAYEntry.FEntryID=LK02.FEntryID
INNER JOIN T_AP_PAYABLE PAY ON PAY.FID=PAYEntry.FID
INNER JOIN t_STK_InStockEntry STKEntry ON STKEntry.FEntryID=LK02.FSID
INNER JOIN t_STK_InStock STK ON STK.FID=STKEntry.FID
INNER JOIN #TM_HS_HookPayBillToHook tmp ON tmp.FID=PAYEntry.FEntryID AND tmp.FBillTypeID=PAY.FBillTypeID
WHERE PAYEntry.FHookStatus<>'C' and LK02.FSTABLENAME LIKE 'T_STK_INSTOCKENTRY%'

INSERT INTO #TM_HS_HookRelation(FSrcBillTypeID,FSrcEntryID,FDesBillTypeID,FDesEntryID,FFlag)
SELECT PAY.FBillTypeID,PAYEntry.FEntryID,STK.FBillTypeID,STKEntry.