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

[步骤]

[15:20:31]  -------------------------------------------------------------
CODE:N152031839
Error:11_-2_0_-2146232060
SQL:SELECT   DISTINCT Top 200 
                                                   oi.CustomerID,
                                                   oi.OrderCode,
                                                   ttr.FilePath
                                            FROM   RB_OrderInfo oi WITH(NOLOCK)
                                                   LEFT JOIN RB_Transport ts WITH(NOLOCK)
                                                      ON oi.CustomerID = ts.CustomerID
                                                      AND oi.TransportID = ts.ID
                                                   LEFT JOIN RB_Transport_API api WITH(NOLOCK)
                                                      ON ts.CustomerID = api.CustomerID
                                                      AND ts.Transport_API_ID = api.ID
                                                   LEFT JOIN RB_TempTransportRequest ttr WITH(NOLOCK)
                                                      ON ttr.OrderCode = oi.OrderCode
                                                      AND ttr.CustomerID = oi.CustomerID  WHERE oi.CustomerID = @CustomerID AND oi.IsStockOrder = @IsStockOrder AND api.Transport_API_Class = @TransportAPIClass AND ttr.FilePath <>''  AND NOT EXISTS (SELECT 1 FROM RB_OrderDetailsCuttingSurface ocs (NOLOCK)  
                                                        WHERE ocs.CustomerID = oi.CustomerID
                                                              AND ocs.OrderCode = oi.OrderCode)
PARAMS:@CustomerID = 1 ,@IsStockOrder = False ,@TransportAPIClass = 278 ,
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.DALExtendV2.RB_OrderInfoExtendV2.GetNeedCuttingSurfaces(Int32 CustomerId, List`1 transportAPIClassIds)
   在 Biz.Irobotbox.Order.CuttingSurfaceSheetService.Execute()
   在 ChinaDownLoadImage.Task.Order.Task_CuttingSurfaceSheetService.Execute()
   在 RB.Utility.SystemTask.<doTask>b__43_0()
   在 System.Threading.Tasks.Task.Execute()
   在 System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   在 System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   在 System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot)
   在 System.Threading.Tasks.Task.ExecuteEntry(Boolean bPreventDoubleExecution)
   在 System.Threading.ThreadPoolWorkQueue.Dispatch()

[结果]

[期望]

优化SQL业务 提升性能