[步骤]
[11:09:31] -------------------------------------------------------------
CODE:N1109316
Error:11_-2_0_-2146232060
SQL:
SELECT pop.ID ,
pop.CustomerID ,
pop.MergerPackageNo ,
pop.TrackNumber ,
pop.TurnNumber,
pop.LogisticsOrderNo ,
pop.PackageState ,
pop.SystemWeight ,
pop.PrintBatchNo ,
pop.TransportID ,
pop.GetPackageTraceTime,
pop.PrintType,
popd.SKU ,
popd.DeclarationName ,
popd.DeclarationNameCN ,
p.ClientSKU ,
p.ProductName ,
p.ProductNameCN ,
popd.ProductNum ,
p.ImageUrl,
oi.OrderSourceID,
p.WithBattery,
pop.Country Shorthand,
pop.PrintAddressState,
coun.IsEuropeanUnion,
p.IsNeedCeCertification ,
0 AS OuerOrderSourceID,
pop.IsStockOrderWithPackage,
cast (0 as bit) as IsPrintSelfShipLable,
cast (0 as bit) as IsPrintStockOrderShipLable
FROM RB_Procurement_Order_Package pop ( NOLOCK )
Left JOIN RB_Procurement_Order_Package_Detail popd ( NOLOCK ) ON popd.CustomerID = pop.CustomerID
AND popd.PackageID = pop.ID
Left JOIN dbo.RB_Product p ( NOLOCK ) ON p.CustomerID = pop.CustomerID
AND p.SKU = popd.SKU
Left JOIN E_Country coun ( NOLOCK ) on pop.Country =coun.Shorthand
Left join RB_OrderInfo oi (nolock) on oi.CustomerID=pop.CustomerID and oi.OrderCode =pop.MergerPackageNo
WHERE pop.ID IN (26077848,26923084,30967302,31053217,35875160,35875161,40991673,40990581,40991667,40991702,40991671,41120937,40991731,40991622,41099846,40991756,40991676,40987472,40987486,40987491,40987485,40987473,40987481,40987482,40987463,40987493,40987483,41075463,40991714,40991776,40991712,40991650,40987488,40990073,40990617,40990619,40990622,40990625,40990627,40991794,40991699,40991746,40991810,41099941,40991818,41099940,40991749,40987506,40987503,40991847,40991752,41098590,40991885,40991871,41025674,40991783,41167841,40991941,40991878,41078982,40991898,40987528,40987532,40987533,40987543,40990800,40992001,40991979,41120939,40991997,40991996,40992015,40992000,41025685,40992019,40987555,40987542,41541398,40992035,40987558,40992118,40992122,41025687,40992077,40992152,40992128,40992099,40992171,41123956,40987575,40987564,40987571,40992027,40992084,40992102,40992225,40992202,40992227,40990315,40992189,40992218,40992246,40992283,40987589,40987586,41078962,40992274,40992272,41022370,40992361,40992336,40992387,40992236,40987610,40987619,40987620,40987609,40992354,41143143,41240192,40992331,40992344,40992376,40987621,40987617,40987625,41025692,40992421,40992422,40991087,41097518,40992404,40992416,40992418,40992453,40992399,40992434,40992412,41025693
1062144,61062176,61062142,61062128,61062172,61062138,61062151,61062179,61062163,61062076,61062171,61062139,61062180,61062175,61062186,61062170,61062164,61062148,61062120,61062157,61062209,61062193,61062183,61062207,61062093,61062221,61062201,61062222,61062212,61062215,61062116,61062218,61062188,61062106,61062150,61062158,61062190,61062235,61062234,61062109,61062145,61062103,61062220,61062121,61062118,61062187,61062214,61062232,61062203,61062196,61062117,61062194,61062219,61062216,61061795,61061799,61061780,61061786,61061784,61061791,61061779,61061785,61061804,61061803,61061792,61061802,61061790,61061788,61061783,61061789,61061793,61061809,61061801,61061797,61061796,61061800,61061781,61061794,61061787,61061997,61062033,61062200,61062135,61062236,61062211,61062241,61062239,61062253,61062248,61062250,61062152,61062223,61062257,61062237,61062225,61062271,61062291,61062244,61062304,61062280,61062274,61062178,61062272,61062266,61062265,61062275,61062238,61062204,61062252,61062189,61062308,61062278,61062262,61062162,61062247,61062260,61062165,61062269,61062270,61062273,61062289,61062242,61062268,61062267,61062213,61062324,61062198,61062243,61062294,61062293,61062296,61062306,61062292,61062283,61062264,61062191,61062258,61062302,61061836,61061825,61061813,61061847,61062115,61061833,61061814,61061822,61061842,61061827,61061830,61061832,61061826,61061816,61061838,61061820,61061812,61061834,61061811,61061844,61061817,61061831,61061840,61061846,61061815,61062254,61062318,61062300,61062228,61062345,61062338,61062245,61062322,61062342,61062328,61062297,61062317,61062263,61062313,61062303,61062230,61062246,61062326,61062224,61062341,61062321,61062316,61062227,61062240,61062323,61062361,61062359,61062357,61062385,61062372,61062365,61062373,61062352,61062259,61062325,61062287,61062281,61062290,61062311,61062362,61062377,61062277,61062393,61062392,61062386,61062375,61062370,61062299,61062286,61062282,61062314,61062349,61062343,61062301,61062276,61062364,61062376,61061863,61061850,61061849,61061848,61061872,61061866,61061871,61061864,61061859,61061857,61061874,61061868,61061856,61062382,61062310,61061939,61061940,61061943,61061942,61061937,61061958,61062319,61062340,61062360,61062329,61062384,61062363,61061898,61061906,61061895,61061907,61061883,61061877,61061893,61061886,61061911,61061914,61061917,61061905,61062346,61061900,61061891,61061882,61061880,61061894,61061913,61061909,61061901,61061902,61061884,61061910,61061912,61061904,61061903,61061888,61061892,61061897,61061885,61062387,61062388,61062389,61062399,61062390,61062391,61062395)
AND pop.CustomerID = @CustomerID
AND pop.WareHouseID = @WareHouseID
PARAMS:@CustomerID = 1 ,@WareHouseID = 333 ,
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_Procurement_Order_PackagePrintExtend.GetPackageDetails(CM_GetScanPackParam model)
在 Biz.Irobotbox.Delivery.CsPackagePrint.PackagePrintClass.GetPackageDetails(CM_GetScanPackParam model)
在 RB.WebApi.ApiCode.WmsCs.CsPrint.GetPackagePrintUrl(GetPackagePrintUrlRequest request, Int32 adminId, String userName)
在 System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
在 System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
在 System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
在 RB.WebApi.ApiCode.API_CsEntrance.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)
-------------------------------------------------------------
[结果]
[期望]
排查问题,修复异常
程哥 帮忙看下呢
/// <summary> /// 根据包裹ID获取包裹内产品信息 /// </summary> /// <param name="model"></param> /// <returns></returns> public List<CM_GetScanPackResult> GetPackageDetails(CM_GetScanPackParam model) { using (var hp = new RB.DAL.DALHelper()) { var packageDatas = hp.GET<RB.DALExtend.RB_Procurement_Order_PackagePrintExtend>().GetPackageDetails(model); initPackageLabelSetting(model.CustomerID, packageDatas); return packageDatas; } }