[步骤]
[16:33:21] -------------------------------------------------------------
CODE:N16332123
Error:11_-2_0_-2146232060
SQL:-- 清理临时表
IF OBJECT_ID('Tempdb..#tb_warehouseid') IS NOT NULL
DROP TABLE #tb_warehouseid;
IF OBJECT_ID('Tempdb..#tb_buyerid') IS NOT NULL
DROP TABLE #tb_buyerid;
IF OBJECT_ID('Tempdb..#temp_single_list') IS NOT NULL
DROP TABLE #temp_single_list;
create table #temp_single_list
(
ID int,
WareHouseID int,
BuyerID int,
CustomerID int
)
CREATE TABLE #tb_warehouseid (WarehouseID INT PRIMARY KEY) -- 加主键/索引
INSERT INTO #tb_warehouseid
EXEC dbo.proc_string_split @WareHouseID,N','
CREATE TABLE #tb_buyerid (BuyerID INT PRIMARY KEY) -- 加主键/索引
INSERT INTO #tb_buyerid
EXEC dbo.proc_string_split @BuyerID,N','
declare @CurrentWhId int
declare cur cursor
for
SELECT WarehouseID FROM #tb_warehouseid
open cur
FETCH NEXT FROM cur INTO @CurrentWhId
WHILE (@@fetch_status = 0)
begin
insert into #temp_single_list(ID,WarehouseID,BuyerID,CustomerID)
select top 1 pds.ID AS ID,
pl.WareHouseID,
pds.BuyerID,
pds.CustomerID
FROM RB_Procurement_Detail_SingleList pds WITH (NOLOCK)
INNER JOIN RB_Procurement_List pl WITH (NOLOCK)
ON pds.CustomerID = pl.CustomerID
AND pds.P_Code = pl.P_Code
WHERE
pds.CustomerID = @CustomerID
AND pds.IsNewFlow = 1
AND pds.IsAlibabaSingle = 1
AND pds.StepState = 9
AND pds.BuyerID IN (SELECT BuyerID FROM #tb_buyerid) AND (pl.IsSample = 0 OR pl.IsSample IS NULL)
AND pl.WareHouseID=@CurrentWhId
order by pds.ID desc
FETCH NEXT FROM cur INTO @CurrentWhId
end
CLOSE cur
DEALLOCATE cur
SELECT
alis.Alibaba_Address,
alis.Alibaba_AddressID,
alis.AlibabaNickName,
pll.WareHouseID,
pll.BuyerID,
alis.AlibabaID,
pdsl.AddTime
FROM RB_Procurement_Detail_SingleList pdsl WITH (NOLOCK)
INNER JOIN #temp_single_list t
ON t.ID = pdsl.ID
INNER JOIN RB_Alibaba_SingleList alis WITH (NOLOCK)
ON pdsl.CustomerID = alis.CustomerID
AND pdsl.ID = alis.SingleID
INNER JOIN RB_Procurement_List pll WITH (NOLOCK)
ON pdsl.CustomerID = pll.CustomerID
AND pdsl.P_Code = pll.P_Code
WHERE pdsl.CustomerID = @CustomerID
PARAMS:@CustomerID = 1 ,@WareHouseID = 5312 ,@BuyerID = 1027 ,
MESSAGE:执行超时已过期。完成操作之前已超时或服务器未响应。
TRACE: 在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
在 System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
在 System.Data.SqlClient.SqlDataReader.get_MetaData()
在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
在 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
在 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
在 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable)
在 RB.DAL.DBOperator.Query(String SQLString, SqlCommand cmd, Int32 Times, SqlParameter[] cmdParms, Boolean IsWriteDB) 在 RB.DAL.DBOperator.toCommonTipException(SqlException ex, String sql, SqlParameter[] cmdParms)
在 RB.DAL.DBOperator.Query(String SQLString, SqlCommand cmd, Int32 Times, SqlParameter[] cmdParms, Boolean IsWriteDB)
在 RB.DALExtend.RB_Alibaba_SingleListExtend.GetLastWareHouseSingleAddress(Int32 customerID, List`1 listWareHouseIDs, List`1 listBuyerID)
在 PandaBuy.ERP.Web.IrobotBox.ProcurementV2.Procurement.ProcurementSingleAlibaba.InitData()
在 System.Web.UI.Control.OnLoad(EventArgs e)
在 System.Web.UI.Control.LoadRecursive()
在 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
在 System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
在 System.Web.UI.Page.ProcessRequest()
在 System.Web.UI.Page.ProcessRequest(HttpContext context)
在 ASP.irobotbox_procurementv2_procurement_procurementsinglealibaba_aspx.ProcessRequest(HttpContext context)
在 System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
在 System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step)
在 System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
在 System.Web.HttpApplication.PipelineStepManager.ResumeSteps(Exception error)
在 System.Web.HttpApplication.BeginProcessRequestNotification(HttpContext context, AsyncCallback cb)
在 System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context)
在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)
在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)
在 System.Web.Hosting.UnsafeIISMethods.MgdIndicateCompletion(IntPtr pHandler, RequestNotificationStatus& notificationStatus)
在 System.Web.Hosting.UnsafeIISMethods.MgdIndicateCompletion(IntPtr pHandler, RequestNotificationStatus& notificationStatus)
在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)
在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)
[结果]
[期望]
建议延长 超时时长，减少用户报错，提升体验