深圳智汇创想科技有限公司

详细错误信息：

 CODE:N1125159
Error:11_-2_0_-2146232060
SQL:
                SELECT * FROM (
                    SELECT ROW_NUMBER() OVER (ORDER BY AddTime DESC) AS [PageIndex] ,* FROM (SELECT oi.ID,
                oi.OrderCode,
                oi.ClientOrderCode,
                oi.MainOrderCode,
                oi.MergeOrderCode,
                oi.SalesRecordNumber,
                oi.OrderSourceID,
                oi.ClientUserAccount,
                oi.OrderStatus,
                oi.OrderState,
                oi.IsFirstDeliver,
                ( CASE
                    WHEN oi.IsPriority > 0 THEN oi.IsPriority
                    ELSE Isnull(os.PriorityNum, 0)
                END )                    AS IsPriority,
                oi.PackagedIDs,
                oi.IsASingleInTheEnd,
                oi.PayerId,
                oi.Email,
                oi.SellerOrderId,
                oi.IsPay,
                oi.CommentType,
                oi.TransactionId,
                oi.PaymentType,
                isnull(oi.RefundPrice,0) as RefundPrice,
                isnull(oi.ThrowingRate,0) as ThrowingRate,
                oi.TotalPrice,
                oi.ExchangeRMB,
                oi.ExchangeUSD,
                oi.TransportPay,
                oi.OtherPayPrice,
                oi.ProductTotalPrice,
                oi.PromotionDiscountAmount,
                oi.CouponCode,
                oi.CouponMinusPrice,
                oi.DiscountMinusPrice,
                oi.AddPayPrice,
                oi.AddOrderReasonType,
                oi.ShareType,
                oi.ShareCustomerID,
                oi.IsAccount,
                oi.AccountTime,
                oi.ShareTotalPrice,
                oi.SynchronousTime,
                oi.IsSynchronous,
                oi.IsTogeInvoice,
                ISNULL(oi.Encrypted,0) as Encrypted, 
                oi.FirstName,
                oi.LastName,
                oi.Address,
                oi.District,
                oi.CabinetNO,
                oi.City,
                oi.Province,
                oi.Country,
                oi.PostCode,
                oi.Telephone,
                oi.ShippingService,
                oi.DownLoadUpdateTime,
                oi.PromotionType,
                oi.TrackNumberTemp,
                oi.TrackNumbers,
                oi.UpdatePlatformTime,
                oi.MarkDeliveryState,
                oi.EMPSDeliveryState,
                oi.LogisticsOrderNo,
                oi.LogisticsOrderNo1,
                oi.ShipTime,
                oi.OrderDescription,
                oi.ISsynchOverseas,
                oi.ProductNumber,
                oi.ProductVolume,
                oi.ProductWeight,
                oi.PayTime,
                oi.AddTime,
                oi.UpdateTime,
                oi.LatestShipDate,
                oi.ServiceAdminName,
                oi.SKUNumber,
                oi.LatestDeliveryDate,
                oi.VipDiscount,
                Isnull(oi.IsTaxFree, 0) IsTaxFree,
                oi.Currency,
                os.ServiceAdminName        AS ServiceOSAdminName,
                Isnull(oi.IsFBATransit, 0) IsFBATransit,
                oi.WareHouseID,
                wh.WareHouseName,
                os.OrderSourceName,
                os.OrderSourceType,
                os.OrderSourceCountry,
                e.Country_cn,
                t.TransportName,
                t.PMSTransport,
                tapi.Transport_API_Class,
                wh.WareHouseType,
                oi.Token,
                os.SaleAdminName,
                os.VATNumber,
                os.VATRate,
                oi.SaveTrackNumbersTime,
                t.TrackingNumberValidDays,
                ISNULL(t.TrackNumbersIsNaturalDay,1) AS TrackNumbersIsNaturalDay,
                datediff(day,getdate(),(dateadd(day,TrackingNumberValidDays,SaveTrackNumbersTime))) as TrackNumbersDiffDay,
                bt.BusinessTeamName,
                t.ID AS TransportID,
                e.ID AS CountryID,
                oi.Oaid,
                api.CertIDAccessKeyId,
                ISNULL(cexpand.BillPdfUrl, '') BillPdfUrl,att1.IsAttachMail AS IsAttachMail   FROM RB_OrderInfo oi WITH(nolock) LEFT JOIN  RB_OrderSource os WITH(nolock)
                ON oi.CustomerID = os.CustomerID AND oi.OrderSourceID = os.ID
            LEFT JOIN E_Country e WITH(nolock)
                ON oi.Country = e.Shorthand
            LEFT JOIN RB_Transport t WITH(nolock)
                ON oi.CustomerID = t.CustomerID AND oi.TransportID = t.ID 
            LEFT JOIN RB_Transport_API tapi WITH(nolock)       
                ON t.Transport_API_ID = tapi.ID AND t.CustomerID = tapi.CustomerID
            LEFT JOIN RB_WareHouse wh WITH(nolock)
                ON oi.CustomerID = wh.CustomerID AND oi.WareHouseID = wh.ID
            LEFT JOIN RB_Admin rba WITH(nolock)
                ON rba.CustomerID = os.CustomerID AND rba.ID = os.SaleAdminID
            LEFT JOIN RB_BusinessTeam bt WITH(nolock)
                ON bt.CustomerID = os.CustomerID AND bt.ID = rba.BusinessTeamID
            LEFT JOIN RB_OrderSource_EbayAmazonAPI api WITH(nolock)
                ON os.CustomerID = api.CustomerID AND os.ID = api.OrderSourceID
            LEFT JOIN RB_OrderInfo_ClientExpand (NOLOCK) cexpand
                                        ON oi.CustomerID = cexpand.CustomerID
                                           AND oi.OrderCode = cexpand.OrderCode outer apply (SELECT Count(1) IsAttachMail
                        FROM   RB_OrderInfo_Attach att(nolock)
                        WHERE  att.CustomerID = oi.CustomerID
                               AND att.OrderCode = oi.OrderCode) att1   WHERE  oi.CustomerID = @CustomerID
                                        AND oi.IsStockOrder = 0 AND oi.AddTime >= @StartTime AND oi.AddTime <= @EndTime ) AS TempTable 
                ) AS  PagerTable
                WHERE PagerTable.[PageIndex] BETWEEN 1 AND 20 option(recompile,maxdop 8) 
PARAMS:@CustomerID = 1 ,@StartTime = 2022/12/16 0:00:00 ,@EndTime = 2023/2/16 23:59:59 ,
MESSAGE:执行超时已过期。完成操作之前已超时或服务器未响应。 
TRACE:   在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   在 System.Data.SqlClient.SqlInternalConnection.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.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   在 System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
   在 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.DAL.DBOperator.Query(String SQLString, SqlParameter[] cmdParms, Boolean IsWriteDB)
   在 RB.DALExtend.RB_OrderInfoExtend.GetOrderInfoV2PagerList(CM_GetOrderInfo_PageListV2Param parameters, Int32& recordCount, String& sqlQueryCriteria, List`1& sqlParameterArray, Int32 isEncrypt)
   在 PandaBuy.ERP.Web.IrobotBox.Order.OrderInfoListV2.BindData(Int32 isEncrypt)
   在 PandaBuy.ERP.Web.IrobotBox.Order.OrderInfoListV2.Page_Load(Object sender, EventArgs e)
   在 System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e)
   在 System.EventHandler.Invoke(Object sender, EventArgs e)
   在 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.ProcessRequestWithNoAssert(HttpContext context)
   在 System.Web.UI.Page.ProcessRequest(HttpContext context)
   在 ASP.irobotbox_order_orderinfolistv2_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.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)
   在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)

-------------------------------------------------------------

    

这个问题是在客户订单高级搜索页面，操作了重置搜索按钮后自动将搜索条件清空了，导致点击搜索超时，并非人为设置的条件为空，再看下

设置了默认一些条件不清除

svn提交记录

客户订单--高级搜索，点击重置按钮后，列表默认查询条件不清空

点击搜索后，正常查询出匹配的数据