[步骤]
[09:11:02] -------------------------------------------------------------
CODE:N0911022
Error:11_-2_0_-2146232060
SQL:
SELECT Count(1) FROM dbo.RB_OrderInfo oi (NOLOCK)
INNER JOIN RB_OrderInfo_BeikuExpand ep (NOLOCK)
ON oi.CustomerID = ep.CustomerID
AND oi.OrderCode = ep.OrderCode
LEFT OUTER JOIN RB_OrderSource (NOLOCK) os
ON oi.OrderSourceID = os.ID
AND oi.CustomerID = os.CustomerID
LEFT OUTER JOIN RB_Transport (NOLOCK) ts
ON oi.TransportID = ts.ID
AND oi.CustomerID = ts.CustomerID
LEFT JOIN dbo.RB_WareHouse (NOLOCK) wh
ON oi.CustomerID = wh.CustomerID
AND oi.WareHouseID = wh.ID
LEFT JOIN dbo.RB_WareHouse (NOLOCK) towh
ON oi.CustomerID = towh.CustomerID
AND oi.ToWareHouseID = towh.ID
LEFT JOIN RB_OrderInfo_Beiku (NOLOCK) beiku
ON beiku.CustomerID = oi.CustomerID
AND beiku.OrderCode = oi.OrderCode
LEFT JOIN RB_OrderInfo_BeikuExpand (NOLOCK) epo ON epo.TransitOrderCode=oi.OrderCode AND epo.CustomerID=oi.CustomerID
LEFT JOIN RB_RestockOrder_ApprovalExecutor(NOLOCK) ae ON ae.CustomerId = oi.CustomerID AND ae.OrderCode = oi.OrderCode
LEFT JOIN RB_FBA_ShipmentInfo(NOLOCK) fbasi ON oi.CustomerID =fbasi.CustomerID AND fbasi.OrderSourceID = oi.OrderSourceID AND oi.AmazonShipmentId=fbasi.ShipmentId
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_Admin frba WITH(nolock) ON frba.CustomerID = os.CustomerID AND frba.ID = os.FBASaleAdminID
LEFT JOIN RB_BusinessTeam fbt WITH(nolock) ON fbt.CustomerID = frba.CustomerID AND fbt.ID = frba.BusinessTeamID
LEFT JOIN RB_STA_InboundShipment(NOLOCK) sta ON sta.InboundPlanId=ep.InboundPlanId AND ep.CustomerID=sta.CustomerID
WHERE oi.CustomerID = @CustomerID
AND oi.IsStockOrder = 1 AND os.OrderSourceType = 1 AND towh.WareHouseType = 3 AND ep.OrderBuildType=2 AND wh.WareHouseType <>1 AND wh.WareHouseType <>3 AND EXISTS
(
SELECT 1
FROM RB_OrderSource_SaleAdmin osa (NOLOCK)
WHERE osa.OrderSourceID = os.ID
AND osa.CustomerID = 1
AND osa.AdminID = 4034
) AND oi.AddTime >=@StartTime AND oi.AddTime<=@EndTime AND oi.OrderState = 0 AND oi.OrderStatus = 1 AND oi.OrderCode IN (SELECT item FROM dbo.CharSplitForIn(@CheckOrderCodeStr,',')) option(recompile,maxdop 16)
PARAMS:@CustomerID = 1 ,@StartTime = 2024/9/15 0:00:00 ,@EndTime = 2024/11/15 23:59:59 ,@CheckOrderCodeStr = 20201014204275355831,202108051341102619231,202401091731162964168,202407041737177114748,202109011746104360480,202312251726161882613,202403011144166860075,202409121822182696244,20210415191794023265,20210624192199860505,202203111522117536941,202404251500171553382,202406120937175329174,202411141419188383337,202404291529171874796,202406200835175965936,202301061112134392052,202303301828139765625,202407251421178792328,20201217193182896343,202112151854112480599,202201141745114584724,202405061509172422797,202408261012181250736,202109171818105466759,202306271136146108983,202411041713187533784,202202221205116697112,202407221007178550812,202407281559179003840,202410121008185371072,20210315094391329270,20210421101494478646,202107161146101331419,202107291607102171243,202201261508115258366,202206131359121843501,202311161010158026775,202401301610164505123,202409091417182420674,202409121057182676399,202112210932113062520,202209191726126679919,202212121703132593781,202308141803149860795,202312121615160672815,202312221411161718707,202406031403174605829,202411141902188396583,202306291000146243776,202405101701172769648,20201216113582711066,20210206092688053391,20210518191996937225,20210531104297906800,202210091559127762681,202311091147157430044,202406281150176639769,202410051512184678272,202410291445187041392,202112301350113657451,202203171427117823527,202205090921120362745,202208051736124527146,202310071408154341122,202404151630170748281,202407011507176868554,202407191633178370494,202408041539179538165,202109171652105463655,202111261002110633567,202208160921125021823,202211041108129486592,202304061714140864117,202404281029171777088,202407121537177707569,202407251559178796274,202408151628180415123,20210308173790736214,20210430185095402054,202304201432141691862,202402291703166791563,202407031636177033893,202411131515188296804,20210122101686499749,20210408154893392055,202206271442122479741,202207301938124237370,202308101613149511784,202308151757149938678,202311211028158485541,202401161410163505821,202409191602183318383,202410031525184512709,202410140826185535198,202410281434186935596,20210302092690186758,20210401200392836651,202207121814123270582,202208301203125693098,202407021425176948321,202407081554177398704,202409181456183188158,202409231733183646027,202111121133109414487,202205091511120369980,202310311755156721113,202406171830175742801,20201218181382976450,20210601101997987901,202207291025124181385,202209200919126719947,202309011534151253754,202402291022166774176,202408081638179857944,202409091407182420172,202409181416183186387,202410261408186742161,20210129094387160725,20210201135087466270,202204070941118824697,202303080953138388662,202310311755156721114,202407071512177317383,202408061123179687079,202410131003185452155,202407151029177904523,202107091613100889391,202110111746107073112,202409281421184072166,202411021325187362449,20210409103193470484,202409231630183642851,20210419141194335198,202305111422143058990,202407080816177376811,202410011707184335676,20210116093685911015,202209290950127180818,202309070935151727215,202403111714167673705,202408301704181602133,202209060915126031939,202308141725149858771,202407171023178124402,202411111534188106726,202411141638188389761,202109171956105472052,202208251139125458194,202401311911164586585,202212141039132774410,202309181610152724281,202402291423166785790,20210505190995848431,202106272106100071022,202308211630150384190,202311071602157273019,202311071622157273716,202401161730163513098,202404091723170056908,202406281919176658330,202407071615177319484,202409291849184159291,202410271729186839434,20210202120587568261,202111231001110392321,202205070941120284500,202210181017128346916,202307061635146742878,202311271753159147684,202404171023170900444,202409111200182591231,202204211102119515526,202211221412130749953,202403120943167754146,202407211539178492716,202411141840188395301,20210317185891535227,202309281601153588055,202411141638188389760,20210410173693568219,202409021827181840517,202409271328183980955,202209161854126536448,202310071545154344694,202311021118156859737,202403111725167674343,202408161639180495623,20201208141281553668,20210108172585170152,20210205154087876271,20210227094689915286,202110111535107067210,202203160948117768072,202209291000127181323,202308281052150922865,202311221136158588400,202111241845110493734,202302161532137152516,202401110921163108575,202406260819176473857,202410161459185754481,202410281740186944717,202110271109108293818,202212121417132586765,202310251344156170527,202405281912174139792,202407280923178991695,202109071924104765587,202205031052120063896,202206090950121671094,202308281528150932951,202310101359154607041,202311151551157956546,202410021541184424023,202411121744188213208,202108300905104198215,202208311130125743609,202310200907155654343,202403141903167935591,202407141228177837172,202409261414183898632,202107051022100590789,202203301619118426315,202208081118124652291,202307061701146744002,202310191849155588682,202411142108188402754,202209081859126149043,202310201402155671113,202407261143178861518,202410080955184920406,202410141017185542803,202110151738107366186,202308211628150383981,202110081549106870434,202204061820118790751,202305051026142657110,202306291442146254464,202312290921162133738,202405221129173671186,202407111558177632151,202408061226179689724,202411101425188014125,202204140908119127732,202302141751137031015,202303061440138263969,202304241717141934793,202403271851169030136,202404151607170746253,202406261841176500885,202407081744177403315,202409021022181817294,202411081434187859509,202209051014125979903,202305260909143992966,202310241030156045283,202404181541171001683,202411051437187613371,202107261749101974815,202406181221175812361,202207130949123351698,202309251842153329302,202311201545158399271,202407151531177917551,202407291811179083002,202408261513181266217,202409041410182009090,20210312191291090913,20210406170293216199,20210407164693304222,202109071024104745267,202203110929117529400,202205271822121132340,202406281919176658324,20210625190899941986,202407011126176858943,202408111535180086347,202109141109105234218,202112101110111961332,202205041007120137790,202208311019125741843,202306201822145666865,202311131020157767497,202404011026169389415,202405061040172410397,202409261308183895313,20210623112399770841,202202151617116351343,202209281727127138251,202210311352129243636,202212221020133491083,202301131406134891478,202311201112158385913,202404221022171288751,202406170825175712181,202110291818108469560,202311130910157762658,202410301448187136188,202204291118119885616,202206091522121678157,202211091139129812623,202404302107171971970,202107011026100334342,202107201642101597386,202202241519116802437,202309111640152123390,202401051800162651329,202409091538182424554,202107261341101965343,202109150955105303680,202208261430125508881,202209281041127127279,202211090935129807916,202406281601176649692,202407161731178006383,202407181537178295420,202408041510179537140,202409061540182180103,20210115100485826438,202108140935103186281,202211211847130678471,202311291645159376086,202409131105182762444,202204021707118594996,202207261147124038940,202208050933124515896,202307311619148749671,202407251559178796280,20210319153091701535,20210417085794159509,202205050918120198679,202301131344134890788,202302080933136632204,202312181147161300333,20210202151887575282,20210615165499093793,202107231052101782868,202311291826159380875,202312041519159840134,202405061727172428802,202409231618183642265,202410131416185462429,20210507112196005286,202209061611126042856,202302171353137209505,202408081459179853619,202409281000184062337,20210114165585750898,202407041603177110518,202408201418180801474,202411141452188385032,202206090958121671515,202307201449147856879,20210408182293401338,202310121827154910327,202310311801156721449,202408261151181256700,20201223145183702018,20210201174887477528,202206271010122448097,202206271439122479509,202208241005125404145,202309111434152114734,202407071511177317080,202409161609183021657,20210412191393756493,202207071049123033644,202303131725138706631,202406111013175248808,202410281734186944237,20210128192187090931,20210303102490280153,20210410104893553201,202204220951119582076,202407011536176869906,20201208152981561033,20210318110191606214,20210329114892542347,20210528181597710175,202403281614169109687,202404111708170339239,202409061652182186770,202410311024187208916,202411091530187939895,202109151654105319106,202204211411119544459,202307241037148113478,202308241407150624681,202309071635151750065,202311031639156951621,202312251746161883092,202403211400168490940,202406061806174877845,202205241942121009342,202310171645155384876,20201217192082894821,202203111606117537853,202211101627129886072,202309011001151240829,20210129114987165579,20210520093197076634,202108161753103320236,202305111143143054398,202309261004153395580,202310091652154519377,202312141113160875755,202404291628171877391,202407171529178151175,202408271722181351518,202411011613187291452,202411071458187777519,202107011123100336260,202107071100100739188,202208301654125699714,202211210922130656152,202403071436167360146,202410160825185732082,202411041509187528103,202108261440103942975,202307211009147917478,202308311727151177971
此处省略很多个参数
202112301427113658409,202303021111138016336,202303231845139331065,202407300956179142146,202109230923105827207,202301050905134318890,202305051805142672202,202308181845150176383,202404101019170160228,20201105102877428730,202107080931100809355,202311100911157502596,202405081453172607922,202408151733180418051,20201228170684096417,202303201420139126674,202312111840160565949,202409061731182187227,202312051037159930073,202401221345163943573,202403071422167359725,202407121816177713611,20210304185890393321,202407221540178566374,202409041600182014511,20210115155085838866,202109061751104687651,202304181047141558881,202405061419172420824,202405171450173297986,202407191528178367858,202411141725188392076,202107141456101201478,202107151959101284235,202108102005102954495,202204211149119528291,202209261634127027548,20201208181581570545,202203101357117489150,202204111604119003016,202311231408158689677,202409301515184240546,202407041604177110774,202409051658182102554,202111091038109177699,202209051114125981406,202209271602127082331,202405291103174199544,202408201411180800909,202409090945182405380,202410111730185308993,202410151130185647044,20210128190487090225,20210428200295236930,202205170937120703785,202209081850126148596,202209191659126678998,202409091607182425952,202410111541185303854,202411141430188383843,20210111093285439791,202108111509103007620,202111121040109412176,202407151528177917312,20210316093391422059,202211031722129433356,202309261416153409200,202406121011175330797,20210310091390892533,202109221800105780879,202209011752125806525,202209261849127032605,202309041459151481580,202205251358121044613,202211141654130157315,202111301635111051734,202404181158170993267,202404221014171288180,202405201639173514421,202407101612177556414,202207041433122870304,202301171413135170255,202303021534138023989,202307131446147365452,202311161648158045395,202407171422178146642,20210325152992210455,202108021505102417902,202209151457126477868,202310231657155956260,202401051753162651267,202409271616183988446,20210305161490472393,202109270918106063679,202207151114123483396,202210211929128578767,202401051051162634152,202407061530177248610,202301291615135953039,202402221416166222637,202404151440170743828,202404221735171307995,202205191810120802907,202305251150143934651,202308311158151164435,202311271654159144284,202403191935168331060,202407151558177918677,202407231839178648605,202107091417100885453,202207251718123996464,202208240952125403667,202405141523173055561,202408081648179858349,20210316103991424836,202204071755118835729,202308171522150089567,202310241122156049486,202410171532185854800,20210202162387578311,20210326095592282891,202403041403167106829,202407170812178110296,202408071655179777759,202306131519145197135,202410162037185771985,202411041030187514661,202411060834187679106,202106301055100262630,202210191734128431698,202405081737172614248,202408140812180312264,202303131829138709614,202304231005141856553,202401021508162402156,202406121933175355690,202409231328183633983,202207041602122872731,202208051152124519311,202208081712124660922,202211071705129684342,202301120945134817828,202301311053136088627,202305051402142663760,202306201021145650247,202307171742147646436,202308311652151176397,202406251506176412100,20210331092992721761,20210505095295821205,202310180953155460166,202404301815171962773,202405101933172776253,202408161037180479691,202411111534188106717,202109221605105776214,202407011120176858544,202408241127181107161,202408271629181348945,202409091607182425957,202410181439185946225,202108041359102553708,202306201914145668786,202308101637149512912,202407110928177615714,202408201420180801480,202409051518182098014,202410231454186444882,202112291657113595071,202309150951152472729,202405100806172746837,20210128151387076715,202108121023103064953,202304061000140848965,202403051355167192667,202407241627178720212,202408121544180170756,202209271022127073891,202211111421129949194,202306291805146262173,202405311355174367545,202407191029178355308,202409091711182428781,202409291546184151451,202411141440188384465,20201110115277912510,202109061344104677829,202209051715125990221,202304271442142131825,202405161356173217971,202407031533177030548,202407071511177317081,202411141422188383646,20201221164983471163,202107081530100821012,20210315101491330720,202110291744108468432,202208081535124657876,202311141347157865655,202406271445176570065,202411011440187287804,202307191443147785756,202401050954162631486,202405071009172501547,202410311024187208914,202308171154150081414,20210218140789170986,202202241136116797861,202308141740149859829,202310231805155960062,202403181347168228741,202303100907138508619,202406200933175968436,20210315091691327623,202109030918104482079,202212070911132111139,202307311559148748715,202308171902150099767,202311081457157353872,202407100933177539056,202408160940180476333,202409060902182164807,202109100942104961793,202401261743164233767,202406271211176563759,202407080815177376798,202407260923178855012,202411061404187693106,20210517135596832107,20210525093697450270,202205131028120540843,202407231422178638705,20210326193392306889,202206101001121715670,202211101556129884870,202309211739153002623,202407011536176869908,20210422212694595373,202202141059116293258,202308221052150460716,202310171114155365014,202311100928157503698,202410281535186938818,202411141702188391139,20210429112795298069,202210181938128365856,202308071811149279413,202311161414158039954,202405161421173218796,202409201537183401585,202209191706126679251,202407241628178720300,202410021001184407075,20210315100391330321,20210331134692731676,202410150937185638992,202107021145100407303,202109011955104366601,202305111036143051679,202311141439157868032,202405061035172409796,202410161809185763789,20201128114880088929,202306081016144841543,202310171535155381737,202311131438157779812,202408191645180722416,202410191329186032999,20210531110697907599,202108171527103381887,202308181131150160722,202406281150176639768,202407221002178550707,202107231446101789616,202107261929101979523,202207051156122935101,202303131407138700693,202311061709157189395,202403081214167434576,202404161018170817557,202405060946172407424,202407041636177112166,202408221725180968634,202107211508101660975,202109161857105397218,202205271822121132338,202308231703150554337,202404071121169876495,202406271445176570066,202406271602176573299,202407151633177920225,202109241104105893252,202111301128111035157,202112291012113583547,202309151008152473537,202409081551182335608,202111261534110645879,202201201903114934324,202312181708161317669,202107201136101586927,202204221626119590116,202404191713171084292,202407031019177016742,202408301633181600840,202206231805122293480,202208110916124799797,202302271541137824902,202307141140147438448,202310161845155277932,202401091825162966371,202406031605174610872,202407300956179142143,202408161921180502216,20210402095992889804,202209191730126680207,202303171602138953583,202407021113176940738,202411142142188405035,202409051625182101028,202410301402187134285,202410061528184756605,20210319160891702988,20210519143297006199,202208301829125702843,202211031553129430397,202308181130150160655,202310091408154512367,202310121845154912949,202405151807173143586,202407251637178797926,202308181914150177687,202411141446188384908,202201151204114631064,202311031645156951703,202409011619181749213,20210203190587691399,202209161822126535424,202305261123143997544,202407011002176854881,202407190826178350088,202108181555103448620,202112151028112455449,202402221825166232018,202410311035187209476,20210316093991422110,202305250927143929178,202306191139145583099,202409221601183553683,20210129125587168138,202109281420106144646,202209070940126084778,202212011857131604485,202308181425150166390,202401291721164433852,202403111724167674334,202410271729186839433,20210619112299378248,202110181516107573585,202207041448122870675,202209161717126533025,202308231042150539102,202310101412154607955,202109141026105232594,202207010934122706733,202308181043150158535,202401121352163197208,20201216175782740586,20210130094687253613,20210218171189178296,202307271749148475934 ,
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.ExecuteScalar()
在 RB.DAL.DBOperator.GetSingle(String SQLString, SqlCommand cmd, Int32 Times, SqlParameter[] cmdParms, Boolean IsWriteDB) 在 RB.DAL.DBOperator.toCommonTipException(SqlException ex, String sql, SqlParameter[] cmdParms)
在 RB.DAL.DBOperator.GetSingle(String SQLString, SqlCommand cmd, Int32 Times, SqlParameter[] cmdParms, Boolean IsWriteDB)
在 RB.DALExtendV2.RB_OrderInfoExtendV2.GetModelListForReStock(CM_FBAShippingScheduleListParam param, Int32& recordCount)
在 PandaBuy.ERP.Web.IrobotBox.Restock.Transfers.FBATransfersStockOrderList.Page_Load(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.ProcessRequest(HttpContext context)
在 ASP.irobotbox_restock_transfers_fbatransfersstockorderlist_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.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)
-------------------------------------------------------------
[结果]
[期望]
优化修复 小黄鸡
开发报告
1.待我审核页面改为表值参数传值