修改了
重现步骤,旧值为 "
{"content":"[23:19:48] -------------------------------------------------------------\r\nCODE:N2319482\r\nError:11_-2_0_-2146232060\r\nSQL:SELECT COUNT(1) FROM ( SELECT alias.[ID],alias.[CustomerID],alias.[OrderSourceID],alias.[CancelId],alias.[MarketplaceId],alias.[LegacyOrderId],alias.[RequestorType],alias.[CancelReason],alias.[CancelState],alias.[CancelStatus],alias.[CancelCloseReason],alias.[PaymentStatus],alias.[ResponseDueDate],alias.[RequestRefundAmountPrice],alias.[RequestRefundAmountCurrency],alias.[CancelRequestDate],alias.[CancelCloseDate],alias.[AddAdminId],alias.[AddUserName],alias.[AddTime],alias.[UpdateAdminId],alias.[UpdateUserName],alias.[UpdateTime],alias.[Remarks],\r\n os.OrderSourceName,\r\n os.OrderSourceCountry,\r\n RB_Department.DepartmentName,\r\n os.ServiceAdminID,\r\n os.ServiceAdminName,\r\n oi.ClientOrderCode,\r\n oi.OrderCode,\r\n oi.OrderState\r\n FROM RB_EbayCancellation alias WITH(NOLOCK)\r\n LEFT JOIN RB_OrderSource os WITH(NOLOCK)\r\n ON os.ID = alias.OrderSourceID\r\n AND os.CustomerID = alias.CustomerID\r\n LEFT JOIN RB_Admin (nolock)\r\n ON RB_Admin.CustomerID = alias.CustomerID\r\n AND os.ServiceAdminID = RB_Admin.ID\r\n LEFT JOIN RB_Department (nolock)\r\n ON RB_Admin.CustomerID = RB_Department.CustomerID\r\n AND RB_Admin.DepartmentID = RB_Department.ID\r\n LEFT JOIN (SELECT ec.ID,\r\n oi.CustomerID,\r\n oi.ClientOrderCode,\r\n oi.OrderCode,\r\n oi.SellerOrderId,\r\n oi.OrderState\r\n FROM RB_EbayCancellation ec WITH(NOLOCK)\r\n LEFT JOIN RB_OrderInfo oi WITH(NOLOCK)\r\n ON ec.CustomerID = oi.CustomerID\r\n AND ec.LegacyOrderId = oi.ClientOrderCode\r\n WHERE ec.CustomerID = 1\r\n AND ec.CancelRequestDate >= '2023/8/26 0:00:00'\r\n UNION\r\n SELECT ec.ID,\r\n oi.CustomerID,\r\n oi.ClientOrderCode,\r\n oi.OrderCode,\r\n oi.SellerOrderId,\r\n oi.OrderState\r\n FROM RB_EbayCancellation ec WITH(NOLOCK)\r\n LEFT JOIN RB_OrderInfo oi WITH(NOLOCK)\r\n ON ec.CustomerID = oi.CustomerID\r\n AND ec.LegacyOrderId = oi.SellerOrderId\r\n WHERE ec.CustomerID = 1\r\n AND ec.CancelRequestDate >= '2023/8/26 0:00:00')oi\r\n ON oi.ID = alias.ID\r\n AND oi.CustomerID = alias.CustomerID\r\n WHERE alias.CustomerID = 1 AND alias.CancelRequestDate >= '2023/8/26 0:00:00' AND alias.CancelRequestDate <= '2023/11/26 0:00:00' ) AS PagerTable\r\nPARAMS:\r\nMESSAGE:执行超时已过期。完成操作之前已超时或服务器未响应。 \r\nTRACE: 在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)\r\n 在 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)\r\n 在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)\r\n 在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)\r\n 在 System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()\r\n 在 System.Data.SqlClient.SqlDataReader.get_MetaData()\r\n 在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)\r\n 在 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)\r\n 在 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)\r\n 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)\r\n 在 System.Data.SqlClient.SqlCommand.ExecuteScalar()\r\n 在 RB.DAL.DBOperator.GetSingle(String SQLString, SqlCommand cmd, Int32 Times, SqlParameter[] cmdParms, Boolean IsWriteDB) 在 RB.DAL.DBOperator.toCommonTipException(SqlException ex, String sql, SqlParameter[] cmdParms)\r\n 在 RB.DAL.DBOperator.GetSingle(String SQLString, SqlCommand cmd, Int32 Times, SqlParameter[] cmdParms, Boolean IsWriteDB)\r\n 在 RB.DAL.DBOperator.QueryPager(String SQLString, String strOrder, Int32 pageIndex, Int32 pageSize, Int32& recordCount, Int32 times, SqlParameter[] cmdParms)\r\n 在 RB.DALExtend.RB_EbayCancellationExtend.GetPagerList(RB_EbayCancellation_PSParameters parameters, Int32& recordCount)\r\n 在 PandaBuy.ERP.Web.IrobotBox.Ebay.EbayCancellationList.Page_Load(Object sender, EventArgs e)\r\n 在 System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e)\r\n 在 System.EventHandler.Invoke(Object sender, EventArgs e)\r\n 在 System.Web.UI.Control.OnLoad(EventArgs e)\r\n 在 System.Web.UI.Control.LoadRecursive()\r\n 在 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)\r\n 在 System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)\r\n 在 System.Web.UI.Page.ProcessRequest()\r\n 在 System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context)\r\n 在 System.Web.UI.Page.ProcessRequest(HttpContext context)\r\n 在 ASP.irobotbox_ebay_ebaycancellationlist_aspx.ProcessRequest(HttpContext context)\r\n 在 System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()\r\n 在 System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step)\r\n 在 System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)\r\n 在 System.Web.HttpApplication.PipelineStepManager.ResumeSteps(Exception error)\r\n 在 System.Web.HttpApplication.BeginProcessRequestNotification(HttpContext context, AsyncCallback cb)\r\n 在 System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context)\r\n 在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)\r\n 在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)\r\n 在 System.Web.Hosting.UnsafeIISMethods.MgdIndicateCompletion(IntPtr pHandler, RequestNotificationStatus& notificationStatus)\r\n 在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)\r\n 在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)\r\n\r\n-------------------------------------------------------------\r\n\n\n\r","__pack_meta__":"1|MTY5Mzk4NTkyMDU0MTYwMDU0MQ==|1|0","__topic__":"","__source__":"172.23.43.160","__tag__:__hostname__":"hwy-zh-gz-iis-erpweb02","__tag__:__path__":"D:\\Irobotbox\\Log\\DBError_2023-10-26.txt","__tag__:__pack_id__":"892E741584B4A7E8-63","__tag__:__client_ip__":"139.9.60.64","__tag__:__receive_time__":"1698333592","__time__":"1698333589"}
",新值为 "
{"content":"[23:19:48] -------------------------------------------------------------\r\nCODE:N2319482\r\nError:11_-2_0_-2146232060\r\nSQL:SELECT COUNT(1) FROM ( SELECT alias.[ID],alias.[CustomerID],alias.[OrderSourceID],alias.[CancelId],alias.[MarketplaceId],alias.[LegacyOrderId],alias.[RequestorType],alias.[CancelReason],alias.[CancelState],alias.[CancelStatus],alias.[CancelCloseReason],alias.[PaymentStatus],alias.[ResponseDueDate],alias.[RequestRefundAmountPrice],alias.[RequestRefundAmountCurrency],alias.[CancelRequestDate],alias.[CancelCloseDate],alias.[AddAdminId],alias.[AddUserName],alias.[AddTime],alias.[UpdateAdminId],alias.[UpdateUserName],alias.[UpdateTime],alias.[Remarks],\r\n os.OrderSourceName,\r\n os.OrderSourceCountry,\r\n RB_Department.DepartmentName,\r\n os.ServiceAdminID,\r\n os.ServiceAdminName,\r\n oi.ClientOrderCode,\r\n oi.OrderCode,\r\n oi.OrderState\r\n FROM RB_EbayCancellation alias WITH(NOLOCK)\r\n LEFT JOIN RB_OrderSource os WITH(NOLOCK)\r\n ON os.ID = alias.OrderSourceID\r\n AND os.CustomerID = alias.CustomerID\r\n LEFT JOIN RB_Admin (nolock)\r\n ON RB_Admin.CustomerID = alias.CustomerID\r\n AND os.ServiceAdminID = RB_Admin.ID\r\n LEFT JOIN RB_Department (nolock)\r\n ON RB_Admin.CustomerID = RB_Department.CustomerID\r\n AND RB_Admin.DepartmentID = RB_Department.ID\r\n LEFT JOIN (SELECT ec.ID,\r\n oi.CustomerID,\r\n oi.ClientOrderCode,\r\n oi.OrderCode,\r\n oi.SellerOrderId,\r\n oi.OrderState\r\n FROM RB_EbayCancellation ec WITH(NOLOCK)\r\n LEFT JOIN RB_OrderInfo oi WITH(NOLOCK)\r\n ON ec.CustomerID = oi.CustomerID\r\n AND ec.LegacyOrderId = oi.ClientOrderCode\r\n WHERE ec.CustomerID = 1\r\n AND ec.CancelRequestDate >= '2023/8/26 0:00:00'\r\n UNION\r\n SELECT ec.ID,\r\n oi.CustomerID,\r\n oi.ClientOrderCode,\r\n oi.OrderCode,\r\n oi.SellerOrderId,\r\n oi.OrderState\r\n FROM RB_EbayCancellation ec WITH(NOLOCK)\r\n LEFT JOIN RB_OrderInfo oi WITH(NOLOCK)\r\n ON ec.CustomerID = oi.CustomerID\r\n AND ec.LegacyOrderId = oi.SellerOrderId\r\n WHERE ec.CustomerID = 1\r\n AND ec.CancelRequestDate >= '2023/8/26 0:00:00')oi\r\n ON oi.ID = alias.ID\r\n AND oi.CustomerID = alias.CustomerID\r\n WHERE alias.CustomerID = 1 AND alias.CancelRequestDate >= '2023/8/26 0:00:00' AND alias.CancelRequestDate <= '2023/11/26 0:00:00' ) AS PagerTable\r\nPARAMS:\r\nMESSAGE:执行超时已过期。完成操作之前已超时或服务器未响应。 \r\nTRACE: 在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)\r\n 在 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)\r\n 在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)\r\n 在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)\r\n 在 System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()\r\n 在 System.Data.SqlClient.SqlDataReader.get_MetaData()\r\n 在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)\r\n 在 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)\r\n 在 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)\r\n 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)\r\n 在 System.Data.SqlClient.SqlCommand.ExecuteScalar()\r\n 在 RB.DAL.DBOperator.GetSingle(String SQLString, SqlCommand cmd, Int32 Times, SqlParameter[] cmdParms, Boolean IsWriteDB) 在 RB.DAL.DBOperator.toCommonTipException(SqlException ex, String sql, SqlParameter[] cmdParms)\r\n 在 RB.DAL.DBOperator.GetSingle(String SQLString, SqlCommand cmd, Int32 Times, SqlParameter[] cmdParms, Boolean IsWriteDB)\r\n 在 RB.DAL.DBOperator.QueryPager(String SQLString, String strOrder, Int32 pageIndex, Int32 pageSize, Int32& recordCount, Int32 times, SqlParameter[] cmdParms)\r\n 在 RB.DALExtend.RB_EbayCancellationExtend.GetPagerList(RB_EbayCancellation_PSParameters parameters, Int32& recordCount)\r\n 在 PandaBuy.ERP.Web.IrobotBox.Ebay.EbayCancellationList.Page_Load(Object sender, EventArgs e)\r\n 在 System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e)\r\n 在 System.EventHandler.Invoke(Object sender, EventArgs e)\r\n 在 System.Web.UI.Control.OnLoad(EventArgs e)\r\n 在 System.Web.UI.Control.LoadRecursive()\r\n 在 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)\r\n 在 System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)\r\n 在 System.Web.UI.Page.ProcessRequest()\r\n 在 System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context)\r\n 在 System.Web.UI.Page.ProcessRequest(HttpContext context)\r\n 在 ASP.irobotbox_ebay_ebaycancellationlist_aspx.ProcessRequest(HttpContext context)\r\n 在 System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()\r\n 在 System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step)\r\n 在 System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)\r\n 在 System.Web.HttpApplication.PipelineStepManager.ResumeSteps(Exception error)\r\n 在 System.Web.HttpApplication.BeginProcessRequestNotification(HttpContext context, AsyncCallback cb)\r\n 在 System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context)\r\n 在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)\r\n 在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)\r\n 在 System.Web.Hosting.UnsafeIISMethods.MgdIndicateCompletion(IntPtr pHandler, RequestNotificationStatus& notificationStatus)\r\n 在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)\r\n 在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)\r\n\r\n-------------------------------------------------------------\r\n\n\n\r","__pack_meta__":"1|MTY5Mzk4NTkyMDU0MTYwMDU0MQ==|1|0","__topic__":"","__source__":"172.23.43.160","__tag__:__hostname__":"hwy-zh-gz-iis-erpweb02","__tag__:__path__":"D:\\Irobotbox\\Log\\DBError_2023-10-26.txt","__tag__:__pack_id__":"892E741584B4A7E8-63","__tag__:__client_ip__":"139.9.60.64","__tag__:__receive_time__":"1698333592","__time__":"1698333589"}
"。