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

[步骤]

[13:00:40]  -------------------------------------------------------------
CODE:N1300401
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 (34399577,34399578,34874266,34908484,37489154,37974943,39523349,40380122,40380100,40383984,40384031,40384083,40501827,40384064,40384000,40383997,40384046,40504267,40384080,40384028,40384119,40455447,40384170,40380104,40384130,40393694,40504269,40384019,40380066,40380088,40380064,40380054,40380049,40380063,40384115,40380168,40390732,40384116,40384169,40380043,40504221,40384237,40384226,40384211,40384249,40384274,40384191,40384280,40384279,40380145,40384305,40482210,40384111,40380114,40380095,40380075,40380106,40384344,40384307,40384320,40409607,40482211,40539156,40384338,40495014,40384325,40380094,40384396,40463428,40384406,40384365,40384363,40384347,40525007,40482212,40495015,40425508,40384460,40384362,40384437,40384282,40380126,40380134,40380137,40380166,40380148,40380153,40380139,40381974,40384385,40384498,40380241,40384384,40482215,40384514,40384507,40384335,40384295,40384510,40384584,40380216,40384481,40384509,40384551,40384559,40384560,40384567,40511046,40380198,40380208,40380218,40384535,40380239,40380214,40380251,40380210,40384656,40384102,40384634,40384556,40384600,40384531,40482219,40404326,40384571,40380303,40384654,40380316,40380311,40384620,40541385,40380264,40380233,40380267,40380272,40380224,40380246,40458971,40384671,40384749,40384589,40380298,40380299,40380308,40384751,40380377,40380354,40384820,40384764,40384815,40482221,40479324,40380309,40380304,40380278,40380297,40384731,40384855,40380366,40384808,40384865,40384901,40806962,40384605,40382229,40390245,40384896,40658384,40441231,40497930,40380396,40384962,40384864,40384936,40384903,40380337,40380325,40514918,40384994,40522945,40384739,40384966,40482232,40385048,40384976,40489591,40465628,40380446,40400860,40385016,40384902,40380459,40385030,40385015,40384974,40380442,40385008,40380437,40384996,40390246,40385039,40385001,40384989,40380385,40380391,40380370,40380399,40380386,40385041,40384975,40385072,40385080,40405073,40385138,40426561,40385108,40380411,40380425,40380509,40385240,40385223,40380518,40385199,40380513,40380503,40385176,40385162,40385167,40385224,40525015,40385019,40380406,40380432,40380436,40380417,40518163,40385144,40385148,40444152,40380543,40515153,40385204,40385214,40385343,40385188,40380466,40380453,40380457,40380496,40380475,40380501,40380565,40465633,40380474,40380465,40398421,40380499,40385269,40566631,40385378,40385410,40482245,40385342,40380597,40385423,40385450,40385448,40385338,40380536,40380525,40380530,40380520,40380526,40380539,40380531,40596078,40380609,40385399,40385504,40380562,40380603,40385565,40623158,40385598,40385587,40385489,40385551,40385578,40385518,40380585,40380559,40385568,40482329,40385563,40385594,40385689,40385640,40385584,40382836,40385717,40385638,40385688,40525023,40385662,40385715,40380610,40380620,40380608,40380605,40380661,40380668,40380647,40380635,40380657,40385725,40482256,40385740,40393705,40385690,40385774,40380692,40385816,40385770,40385712,40806964,40385830,40385827,40504300,40380727,40380670,40380637,40380654,40380672,40380673,40380638,40380680,40380677,40385823,40385837,40385849,40617642,40385832,40385898,40385934,40504302,40380737,40425400,40385818,40385803,40380703,40380694,40525026,40385951,40444156,40380690,40380718,40380714,40380775,40385963,40465636,40386039,40385993,40386000,40385900,40386032,40380813,40386015,40385991,40386021,40387345,40385927,40380760,40380765,40380734,40398425,40582159,40380788,40380745,40380784,40386073,40385969,40551181,40525028,40386099,40409621,40380832,40386106,40380799,40380793,40380785,40386112,40386094,40482279,40380855,40380812,40386211,40386152,40386134,40489911,40579795,40380814,40380860,40386200,40386170,40482280,40387386,40386203,40386230,40386233,40380873,40387446,40380861,40387476,40386773,40387458,40386167,40380841,40386238,40560391,40419281,40525342,40386253,40380870,40380867,40386707,40386730,40386752,40386761,40387553,40387561,40387624,40387607,40387487,40387670,40387613,40400887,40386743,40386759,40386739,40386792,40387546,40386835,40387713,40387700,40387687,40387742,40387701,40471331,40421899,40387558,40386786,40386781,40386808,40386799,40386807,40386823,40387783,40387770,40387662,40387744,40387752,40426575,40387320,40387297,40387293,40387343,40387310,40387301,40387323,40387314,40387296,40387490,40387308,40387307,40387295,40387175,40496096,40387507,40387309,40387321,40553900,40387322,40387497,40387292,40387300,40387312,40387351,40387373,40387376,40387486,40387303,40387371,40426545,40387305,40387315,40386856,40387654,40387766,40387681,40387675,40387645,40387703,40386863,40387769,40386844,40386845,40400894,40387740,40387858,40510442,40387888,40386834,40386817,40386812,40386826,40386849,40400884,40518175,40387953,40553901,40387780,40387789,40387786,40387853,40387823,40387842,40387984,40489499,40387981,40386892,40387946,40387935,40387949,40388027,40387898,40387947,40426626,40388004,40388080,40388076,40387909,40386903,40387972,40387963,40388137,40465661,40388092,40388060,40388084,40388097,40388133,40388106,40388154,40388186,40388329,40388279,40386943,40444180,40388217,40386941,40386942,40386948,40386938,40386935,40504329,40387021,40388319,40388245,40423782,40419293,40388351,40388308,40388296,40386963,40386959,40388405,40388440,40388349,40388344,40388321,40510443,40419294,40387282,40426638,40388474,40388407,40463446,40390815,40388514,40388482,40388404,40388509,40388453,40388422,40388435,40465669,40388471,40388464,40465667,40388593,40388494,40388522,40388510,40482312,40400913,40388540,40387001,40388578,40388586,40388577,40387002,40388611,40388610,40390906,40388652,40400916,40388644,40387012,40387008,40495029,40390896,40388675,40388672,40388668,40388679,40387023,40525040,40390884,40390883,40390875,40409632,40390869,40390275,40390291,40390963,40390307,40390924,40390935,40391042,40390309,40391056,40391033,40390987,40390986,40390978,40547737,40419299,40391025,40390295,40391079,40391037,40391047,40391028,40391038,40390259,40391055,40391100,40391142,40391058,40393097,40391194,40391098,40390322,40390311,40479347,40391156,40518183,40391190,40391130,40391123,40391229,40391240,40391140,40390330,40391287,40391274,40391205,40391207,40391210,40391179,40391195,40494766,40391193,40482319,40391216,40393736,40390776,40425538,40391259,40514896,40391268,40391209,40391258,40525051,40391278,40501847,40391276,40391358,40391354,40390359,40390358,40391367,40391298,40504351,40391342,40391303,40391340,40391343,40390370,40390372,40390389,40391400,40391368,40400935,40391362,40533955,40391420,40391436,40391360,40391464,40525052,40391437,40489913,40390374,40390375,40390380,40623162,40391449,40391405,40391408,40391418,40391414,40390764,40391504,40393148,40391495,40391450,40391442,40391443,40391424,40391440,40390398,40393822,40444196,40393838,40393826,40391499,40391476,40511059,40391492,40391485,40393155,40420509,40391478,40391487,40391503,40391501,40391515,40391502,40444198,40393865,40482326,40426668,40426673,40391132,40391030,40426662,40390777,40390773,40390813,40390651,40391090,40390881,40390774,40391185,40390771,40425543,40393897,40393829,40393899,40393805,40393883,40539163,40393188,40393902,40393817,40393194,40393843,40393848,40393161,40393905,40393931,40393916,40393867,40401195,40419316,40393231,40393947,40393977,40782459,40393953,40393980,40393874,40393968,40393232,40393250,40400945,40393960,40393969,40511060,40393895,40393928,40393854,40393182,40393174,40393185,40393196,40393180,40393199,40394037,40394019,40393952,40393956,40394059,40394010,40407244,40394069,40394031,40393922,40394077,40394084,40394032,40393206,40393209,40393207,40393255,40393276,40463450,40394102,40394002,40394008,40398464,40394111,40394099,40426701,40394114,40393304,40394112,40504369,40394055,40393256,40393242,40558303,40394033,40451190,40394074,40394090,40393266,40398490,40504372,40398471,40444202,40398479,40401035,40401049,40401009,40394117,40394116,40419320,40394105,40393305,40393299,40393308,40393297,40393275,40393722,40401041,40401022,40401045,40401082,40401026,40401050,40394124,40393723,40401123,40401115,40401070,40401127,40409638,40419321,40398474,40398526,40401088,40401100,40398528,40401116,40401092,40401017,40401011,40398462,40398442,40398485,40398480,40398486,40398461,40401178,40419322,40401164,40398545,40398559,40550872,40401063,40401074,40518191,40504378,40401188,40398566,40401084,40482344,40401194,40398564,40401122,40398517,40398530,40398494,40398525,40398531,40398511,40398502,40398510,40398515,40425554,40401133,40398651,40401212,40401210,40401202,40401136,40398582,40398578,40504381,40482348,40401269,40411607,40401217,40401284,40401182,40406431,40398532,40398560,40398548,40398570,40398563,40398557,40398575,40426717,40539167,40401326,40401317,40401314,40401208,40411940,40401206,40400914,40398597,40623165,40401354,40465691,40426720,40433342,40401374,40458961,40398583,40398584,40398601,40398600,40398615,40401337,40401350,40398662,40398708,40401405,40482353,40401455,40401416,40401434,40398695,40401422,40398642,40398632,40398631,40398641,40398434,40398621,40398638,40398618,40398652,40401427,40401363,40495035,40401451,40573393,40401456,40401530,40401389,40398436,40401565,40504384,40582167,40401533,40401523,40401498,40401504,40444207,40398654,40398682,40398667,40398673,40398658,40401583,40401578,40401524,40401447,40401418,40401476,40444211,40401606,40610478,40401559,40401642
省略 无数个

)
AND pop.CustomerID = @CustomerID
AND pop.WareHouseID = @WareHouseID
            
PARAMS:@CustomerID = 1 ,@WareHouseID = 5312 ,
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)

[结果]

[期望]

修改成 表值参数  或者 分批次处理