重现步骤

[步骤]



[10:40:51]  -------------------------------------------------------------
CODE:N10405119
Error:11_-2_0_-2146232060
SQL: drop table if exists #tabStr0;
                                     drop table if exists #tabStr1;declare @CheckOrderCodeStr0 varchar(max)= '101227,101228,107376,107377,107378,107379,107380,111478,111479,111480,111481,111482,111483,111484,111485,111486,111487,111488,111489,111490,111577,111602,111603,111604,111605,111606,111607,111827,112176,112552,112553,112554,112555,112556,112557,112558,112559,112560,112561,112562,112563,112564,112565,112566,112567,112568,112569,112570,112571,112572,112573,112574,112575,112576,112577,112578,112579,112580,112581,112582,112583,112584,112585,112586,112587,112588,112589,112590,112591,112592,112593,112594,112595,112596,112597,112598,112599,112600,112601,112602,112603,112604,112605,112606,112607,112608,112609,112610,112611,112612,112613,112614,112615,112616,112617,112618,112619,112620,112621,112622,112623,112624,112625,112626,112627,112628,112629,112630,112631,112632,112633,112634,112635,112636,112637,112638,112639,112640,112641,112642,112643,113038,115495,115496,115497,115498,115499,115500,115501,115502,115503,115504,115505,115506,115507,115508,115509,115510,115511,115519,115520,115521,115522,115523,115524,115525,115526,115527,115528,116977,116978,116979,116980,116981,117030,117043,119356,119357,119358,119359,119360,119361,121252,121253,121254,121255,121256,121257,121258,121259,121260,121261,121262,121263,121264,121265,121308,121309,121310,121311,121312,121313,122182,122183,122184,122185,122186,122187,122188,122189,122190,122191,122192,122193,122194,122195,122196,122197,122198,122199,122200,122201,122202,122203,122204,122205,122206,122207,122208,122209,122210,122211,122212,122213,122214,122215,122216,122217,123242,123243,123244,124917,124918,124919,124920,124921,124922,125551,125552,125553,125554,125555,125556,125557,125558,125559,125560,125561,125562,125563,125564,125565,125566,125693,126137,126327,126652,126723,127587,127588,127589,127590,127591,127592,127593,128254,128255,128268,128269,128270,128271,128272,128276,128306,128307,128347,128348,128349,128350,128351,128352,128353,128354,128355,128356,128357,128362,128384,128452,128467,128468,128469,128471,128474,128475,128476,128477,128478,128479,128480,128481,128763,128764,128765,129105,129106,129107,129108,129109,129110,129112,129113,129114,129116,129131,129132,129135,129136,129137,129138,129139,129141,129142,129143,129144,129262,129279,129280,129286,129287,129288,129289,129290,129291,129450,129451,129452,129453,129454,129455,129456,129457,129458,129459,129460,129463,129464,129465,129466,129467,129468,130916,131624,131625,131626,131627,131628,132573,132574,132575,132576,133265,133266,133267,133268,133269,133270,133271,133272,133273,133274,134895,134896,134897,134898,134899,134900,134902,134903,135018,135019,135020,135021,135022,135023,135024,135051,135052,135053,135054,135055,135056,135057,135058,135059,135060,135061,135062,135063,135064,135065,135066,135067,135068,135069,135094,135785,140464,140749,140750,140751,140752,140753,140754,140755,140756,140757,140758,140759,140760,140761,140762,140763,140764,140765,140898,143854,143855,143856,143857,143858,144246,144247,144248,144249,144250,144251,144252,144253,144498,144499,149099,149100,149101,149102,149135,149136,149868,149869,149870,149871,149872,149873,149874,149875,149876,149877,149878,149879,149880,149881,149882,149883,150090,150091,150092,150589,150590,150591,150592,150593,150594,150595,150596,150597,150598,150605,150606,150607,150608,150609,150610,150611,150612,150613,150614,150631,150632,150633,150634,150635,150636,150637,150638,150639,150640,150646,150647,150648,150649,150650,150651,150652,150655,150656,150658,150659,150660,150661,150662,150663,150664,150665,150666,150667,150668,150669,150670,150671,150672,150673,150674,150675,150676,150677,150678,150679,150680,150681,150682,150683,150684,150685,150686,150687,150696,150697,150698,150699,150700,150701,150702,150703,150704,150705,150710,150711,150934,150935,151451,151452,151453,151454,151455,151476,151477,151478,151479,151480,151481,151482,151483,151484,151789,151790,151791,151792,151793,151794,151795,151796,151797,151804,151805,151806,151807,151808,151809,151810,151811,151812,151861,151862,151863,151864,151865,151866,151867,151868,151869,151870,151871,151872,151873,151874,151875,151876,151877,151878,151879,152015,152016,152017,152018,152019,152020,152021,152022,152023,152024,152025,152026,152027,152028,152029,152030,152031,152032,152033,152034,152035,152036,152037,152038,152039,152040,152041,152042,152043,152044,152045,152046,152047,152048,152049,152050,152051,152052,152053,152054,152055,152056,152089,152090,152091,154821,155874,155875,155876,155877,155878,155879,156436,156437,156438,156439,156440,156483,156484,156485,156486,156983,157062,157063,157072,157073,157074,157075,157076,157077,157078,157079,157080,157081,157082,157083,157648,157649,157650,157651,157652,163418,164797,164798,164799,164800,164801,164802,164803,164804,164805,164806,164807,164808,164809,164869,164958,164959,164960,165076,165077,165078,165079,165080,165081,166136,166137,166138,166139,166140,166141,166142,166143,166144,166973,167083,167084,167085,167086,167087,167428,168800,168801,168802,168803,168804,168805,168806,168807,168808,172012,172013,172014,172015,172016,172017,172018,172019,172020,172021,172871,172872,172873,172877,172878,172879,173277,173278,173279,173280,173281,173282,173283,173284,173797,173798,173799,173800,173801,173835,173836,173837,173838,174013,174014,174015,174016,174017,174018,174019,174020,174021,174022,174023,174024,174025,174026,174027,174028,174029,174030,174031,174032,174033,174034,174035,174036,174037,174038,174039,174040,174041,174042,174043,174044,174045,174046,175650,175651,175652,175653,175654,175655,175656,175657,175658,175659,175660,175661,175662,175663,175664,175665,175666,175667,175668,175669,175670,175671,175672,175673,175674,175675,175676,175677,175678,175679,175680,175681,175820,175821,175822,175823,175824,175825,175826,175827,175828,175834,175842,177631,180897,180898,180899,180900,180901,180902,180903,180904,180905,180908,180909,180910,180911,180912,180913,180914,180969,180970,180971,180972,180973,180974,180975,180976,180977,180978,180979,180980,180981,180982,180983,180984,180985,180986,180987,180988,180989,180990,180991,180992,180993,180994,180995,180996,180997,180998,180999,181000,181001,181002,181003,181004,181005,181006,181007,181008,181009,181010,181011,181012,181013,181014,181015,181016,181017,181018,181019,181020,181021,181022,181023,181024,181507,181892,181893,181894,181895,181896,182986,183051,183071,188159,188160,188161,188162,188163,188164,188165,188166,188167,188168,188891,188892,188893,189478,190148,190180,190181,190182,191422,191423,191424,191463,191464,191465,191466,191467,191468,191469,191470,191471,191472,191484,191487,191488,191489,191490,191491,191492,192679,192680,192681,193169,193971,193972,193973,193974,195272,195273,195274,195275,195276,195277,195278,195279,195280,195281,199204,199205,199416,199417,199418,199419,199420,199421,199422,199423,199424,199425,199426,199427,199428,199429,199430,199431,199432,199433,199434,199435,199436,199437,199438,199439,199440,199441,199442,199443,199444,199445,199446,199447,199514,199515,199516,199517,199518,199519,199520,199521,199522,199523,199524,199525,199526,199527,199528,199529,199530,199531,199532,199533,199543,199544,199545,199546,199547,199548,199549,199550,199551,199552,199553,199554,199555,199556,199557,199558,199559,199560,199561,199562,199563,199564,199565,199570,199571,199572,199573,199574,199575,199576,199577,199578,199579,199580,199581,199582,199583,199584,199585,199586,199587,199588,199589,199590,199591,199722,199723,199724,199963,199964,200454,200455,200456,200457,200458,200459,200460,201254,201255,201256,201257,201258,201259,201260,201855,201987,201992,201993,201994,201995,201996,201997,201998,201999,202000,202013,202014,204031,204032,204033,204034,204035,204837,204838,205288,205289,205290,205291,205292,205293,205294,205295,205928,205929,205930,205931,205932,205933,205934,205935,205936,205937,205938,205939,205940,205953,205954,205955,205956,205957,205958,205959,205960,205961,205962,205963,205964,205965,205966,205967,205968,205969,205970,205971,205972,205973,205974,205975,205976,205977,205978,206249,206250,206251,206252,206253,206254,206255,206256,206257,206258,206259,206260,206261,206262,206263,206264,206265,206266,206267,206268,206269,206270,206271,206272,206273,206274,206275,206276,206277,206278,206279,206280,206281,206282,206283,206284,206285,206286,206287,206288,206316,206317,206318,206319,206320,206321,206322,206779,206780,206781,206782,206783,206784,206785,206786,206787,206788,206789,206790,206791,206792,206793,206794,206795,206796,206797,206798,206799,206800,206801,206802,206803,206804,206805,206806,206807,206808,206809,206810,206811,206812,206813,206814,206815,206816,206817,206818,206819,206820,206821,206822,206823,206824,206825,206826,206827,206828,206829,206830,206831,206832,206833,206834,206835,206836,206837,206838,206839,206840,206841,206842,206843,206844,206845,206846,206847,206848,206849,206850,206851,206852,206853,206854,206855,206856,206857,206858,206859,206860,206861,206862,206863,206864,206865,206866,206867,206868,206869,206870,206871,206872,206873,206874,206875,206876,206877,206878,206879,206880,206881,206882,206883,206884,206885,206886,206887,206888,206889,206890,206891,206892,206893,206894,206895,206896,206897,206898,206899,206900,206901,206902,206903,206904,206905,206906,206907,206908,206909,206910,206911,206912,206913,206914,206915,206916,206917,206918,206919,206920,206921,206922,206923,206924,206925,206926,206927,206928,206929,206930,206931,206932,206933,206934,206935,206936,206937,206938,206939,206940,206941,206942,206943,206944,206945,206946,206947,206948,206949,206950,206951,206952,206953,206954,206955,206956,206957,206958,206959,206960,206961,206962,206963,206964,206965,206966,206967,206968,206969,206970,206971,206972,206973,206974,206975,206976,206977,206978,206979,206980,206981,206982,206983,206984,206985,206986,206987,206988,206989,206990,206991,206992,206993,206994,206995,206996,206997,206998,206999,207000,207001,207002,207003,207004,207005,207006,207007,207008,207009,207010,207011,207012,207013,207014,207015,207016,207017,207018,207019,207020,207021,207022,207023,207024,207025,207026,207027,207028,207029,207030,207031,207032,207033,207034,207035,207036,207037,207038,207039,207040,207041,207042,207043,207044,207045,207046,207047,207048,207049,207050,207051,207052,207053,207054,207055,207056,207057,207058,207059,207060,207061,207062,207063,207064,207065,207066,207067,207068,207069,207070,207071,207072,207073,207074,207075,207076,207077,207078,207079,207080,207081,207082,207083,207084,207085,207086,207087,207088,207089,207090,207091,207092,207093,207094,207095,207096,207097,207098,207099,207100,207101,207102,207103,207104,207105,207106,207107,207108,207109,207110,207111,207112,207113,207114,207115,207116,207117,207136,207137,207910,208731,208732,208754,208860,208861,208862,208863,208864,208865,208866,208867,208868,208869,208870,208871,208872,211100,211285,211286,211287,211288,211289,211375,211376,211377,211378,211379,211380,211381,212680,214038,216555,216556,216557,216558,216559,216560,216561,217958,217959,217960,217961,217962,217963,217964,217965,217966,217967,217968,217969,217970,217971,217972,217973,217974,217975,217976,217977,217978,217979,217980,217981,217982,217983,217984,217985,218098,218099,218100,218101,218102,218103,218104,218105,218106,218107,218108,218109,218110,218111,218112,218113,218114,218115,218116,218117,218118,218119,219290,219291,219292,219293,219294,219295,219296,219484,219485,219487,219489,219490,219491,219492,219544,219545,219546,219547,219548,219549,219550,219629,219630,219825,221601,221602,221603,221604,221605,221606,221607,221608,221609,221610,221611,221612,221617,221618,221619,221620,221621,221622,221623,221624,221625,221626,221627,221628,221629,221630,221631,221632,221633,221634,221635,222707,222977,222980,222982,222984,223005,223034,223035,223043,223128,223129,223130,223131,223157,223158,223159,223160,223162,223163,223164,223165,223166,223763,225577,227523,227525,227526,227529,227530,227531,227533,227595,227603,227606,227858,229157,229158,229159,229160,229161,229162,229163,229164,229206,229782,229783,229784,229785,229799,229809,229810,229881,229894,232027,232029,232418,232420,232452,232455,232456,232457,232458,232459,234093,234094,234795,234796,235413,235414,235415,235416,235417,235418,235419,235420,235421,235422,235441,235442,235443,235444,235445,235446,235561,235562,235563,235564,235565,235566,235567,235568,235569,235570,235571,235572,235573,235574,235575,235576,235577,235578,235579,236128,236129,236130,236131,236132,236133,236134,236135,236136,236137,236138,236139,236140,236141,236142,236143,236144,236145,236146,236147,236148,236149,236150,236151,236152,236153,236154,236155,236156,236157,236158,236159,236160,236161,236714,236715,236723,236724,236725,237043,237044,237045,237046,237047,237048,237049,237050,237051,237052,237053,237235,237510,237979,237980,237981,237982,237985,237986,237987,237989,237990,237991,237992,237993,237994,237995,238019,238020,238021,238027,238028,238029,238030,238031,238033,238618,238619,238620,238621,238622,238623,239178,239179,239180,239181,239182,239183,239184,239185,239186,239187,239188,239189,239190,239191,239192,239193,239194,239195,239196,239197,239198,239199,239200,239201,239202,239203,239204,239205,239206,239207,239208,239209,239210,239211,239212,239213,239214,239215,239216,239217,239218,239219,239220,239221,239222,239223,239224,239225,239226,239227,239228,239229,239230,239231,239232,239233,239234,239235,239236,239237,239238,239239,239240,239241



create table #tabStr0(id int);
                                     insert into #tabStr0
                                     exec proc_string_split @CheckOrderCodeStr0,',';
                                     create index idx_id on #tabStr0(id);
                                     create table #tabStr1(id int);
                                     insert into #tabStr1
                                     exec proc_string_split @CheckOrderCodeStr1,',';
                                     create index idx_id on #tabStr1(id);  SELECT COUNT(1) FROM ( SELECT DISTINCT
                                      0 AS Source,
                                      os.OrderSourceName, 
                                      isnull(os.SourceStatus,0) SourceStatus,
                                      dp.DepartmentName,
                                      rocrsi.ID,
                                      rocr.OrderSourceID,
                                      rocr.RemovalOrderType,
                                      rocr.RemovalOrderCode,
                                      rocrsi.MNSKU,
                                      rocrsi.FNSKU,
                                      rocrsi.SKU,
                                      rocrsi.SellableQuantity,
                                      rocrsi.UnsellableQuantity,
                                      rocrsi.CostDestroyed,
                                      rocrsi.DestroyedAdminName,
                                      rocrsi.JobNo,
                                      rocrsi.Remark,
                                      ISNULL(arod.RequestedQuantity, 0) AS RequestedQuantity, 
                                      ISNULL(arod.CancelledQuantity, 0) AS CancelledQuantity,
                                      ISNULL(arod.DisposedQuantity, 0) AS DisposedQuantity,
                                      ISNULL(arod.ShippedQuantity, 0) AS ShippedQuantity,
                                      ISNULL(arod.InProcessQuantity, 0) AS InProcessQuantity,
                                      arod.Disposition,
                                      
                                      ISNULL(rrd.ReceivedQty, 0) AS ReceivedQty,
                                      '' AS Carrier,
                                      '' AS TrackingNumber,
                                      ISNULL(rocrsi.DestructionReason,'') AS DestroyedReason,
                                      ISNULL(( CASE  WHEN pro.LastBuyPrice > 0 THEN pro.LastBuyPrice
                                               ELSE pro.LastSupplierPrice
                                               END ), 0) * (arod.DisposedQuantity + arod.ShippedQuantity) AS TotalProcessedPurchasePrice,
                                      ISNULL(( CASE  WHEN pro.LastBuyPrice > 0 THEN pro.LastBuyPrice
                                               ELSE pro.LastSupplierPrice
                                      END ), 0) * (rocrsi.SellableQuantity + rocrsi.UnsellableQuantity) AS TotalPurchasePrice,
                                      ISNULL(( CASE  WHEN pro.LastBuyPrice > 0 THEN pro.LastBuyPrice
                                               ELSE pro.LastSupplierPrice
                                      END ), 0) * (rocrsi.SellableQuantity + rocrsi.UnsellableQuantity)  * (ISNULL(rocrsi.CostDestroyed, 0)/100) AS DestroyAllocatedAmount,
                                      pro.ImageUrl,
                                      pro.ProductNameCN,
                                      isnull( wh.WareHouseName,'')  OverseaWareHouseName,pro.ProductProperty
                               FROM RB_RemovalOrderCreateRecordSkuItems rocrsi (NOLOCK) 
                                    LEFT JOIN RB_RemovalOrderCreateRecord rocr (NOLOCK) 
                                           ON rocrsi.CustomerID = rocr.CustomerID
                                          AND rocrsi.RecordID = rocr.ID
                                    LEFT JOIN RB_Product pro (NOLOCK) 
                                           ON rocrsi.CustomerID = pro.CustomerID
                                          AND rocrsi.SKU = pro.SKU
                                    LEFT JOIN RB_Amazon_Removal_Order_Detail arod with (NOLOCK)
                                           ON rocr.CustomerID = arod.CustomerID
                                          AND rocr.OrderSourceID = arod.OrderSourceID
                                          AND rocr.RemovalOrderCode = arod.OrderID
                                          AND rocrsi.MNSKU = arod.SKU 
                                          AND rocrsi.FNSKU  = arod.FnSKU
                                    LEFT JOIN RB_Removeorder_ReceiveDetail rrd with (NOLOCK) 
                                           ON arod.OrderID = rrd.OrderID 
                                          AND arod.OrderSourceID = rrd.OrderSourceID 
                                          AND arod.CustomerID = rrd.CustomerID
                                          AND arod.SKU  = rrd.SellerSKU
                                          AND arod.FnSKU = rrd.FNSKU
                                     
                                    LEFT JOIN RB_OrderSource (NOLOCK) os
                                           ON os.CustomerID = rocr.CustomerID 
                                          AND os.ID = rocr.OrderSourceID
                                    LEFT JOIN RB_RemovalOrder_BusinessExpand robe (NOLOCK)    
                                           ON robe.CustomerID = rocr.CustomerID
                                          AND robe.OrderSourceID = rocr.OrderSourceID
                                          AND robe.RemovalOrderCode = rocr.RemovalOrderCode
                                    LEFT JOIN RB_RemovalOrder_SkuItem_AuditSatusExtend (NOLOCK) rsase
                                           ON rsase.CustomerID = rocrsi.CustomerID 
                                          AND rsase.ReportID = rocrsi.ID
                                    LEFT JOIN RB_Admin (NOLOCK) ra
                                           ON rocrsi.CustomerID = ra.CustomerID
                                          AND rocrsi.DestroyedAdminID = ra.ID
                                    LEFT JOIN RB_Department (nolock) dp
                                           ON ra.CustomerID = dp.CustomerID
                                          AND ra.DepartmentID = dp.ID
                                    left join  RB_WareHouse (nolock) wh
                                           on  rocr.CustomerID = wh.CustomerID
                                          and  rocr.OverseaWareHouseId = wh.ID INNER JOIN #tabStr0 t0 on t0.id = rocrsi.ID  WHERE rocrsi.CustomerID = @CustomerID   AND rsase.ProcessArrivalTime >= @StartDate AND rsase.ProcessArrivalTime < @EndDate  AND rsase.AuditSatus = 2  and exists(select  1
                                                 from  RB_OrderSource_SaleAdmin osa (NOLOCK)
                                                where  osa.OrderSourceID = rocr.OrderSourceID
                                                  and  osa.CustomerID = rocr.CustomerID
                                                  and  osa.AdminID = 3908
                                               ) union all SELECT  DISTINCT
                                       1 AS Source,
                                       os.OrderSourceName, 
                                       isnull(os.SourceStatus,0) SourceStatus,
                                       dp.DepartmentName,
                                       arod.ID,
                                       arod.OrderSourceID,
                                       arod.OrderType AS RemovalOrderType,
                                       arod.OrderID AS RemovalOrderCode,
                                       arod.SKU AS MNSKU,
                                       arod.FnSKU AS FNSKU,
                                       pro.SKU AS SKU,
                                       0 AS SellableQuantity,
                                       0 AS UnsellableQuantity,
                                       ISNULL(arod.CostDestroyed, 0) AS CostDestroyed,
                                       arod.DestroyedAdminName AS DestroyedAdminName,
                                       arod.JobNo AS JobNo,
                                       arod.Remark AS Remark,
                                       ISNULL(arod.RequestedQuantity, 0) AS RequestedQuantity, 
                                       ISNULL(arod.CancelledQuantity, 0) AS CancelledQuantity,
                                       ISNULL(arod.DisposedQuantity, 0) AS DisposedQuantity,
                                       ISNULL(arod.ShippedQuantity, 0) AS ShippedQuantity,
                                       ISNULL(arod.InProcessQuantity, 0) AS InProcessQuantity,
                                       arod.Disposition,
                                       
                                       ISNULL(rrd.ReceivedQty, 0) AS ReceivedQty,
                                       '' AS Carrier,
                                       '' AS TrackingNumber,
                                       arod.DestructionReason AS DestroyedReason,
                                       ISNULL(( CASE  WHEN pro.LastBuyPrice > 0 THEN pro.LastBuyPrice
                                                ELSE pro.LastSupplierPrice
                                                END ), 0) * (arod.DisposedQuantity + arod.ShippedQuantity) AS TotalProcessedPurchasePrice,
                                       ISNULL(( CASE  WHEN pro.LastBuyPrice > 0 THEN pro.LastBuyPrice
                                                ELSE pro.LastSupplierPrice
                                                END ), 0) * (arod.RequestedQuantity) AS TotalPurchasePrice,
                                        ISNULL(( CASE  WHEN pro.LastBuyPrice > 0 THEN pro.LastBuyPrice
                                                ELSE pro.LastSupplierPrice
                                                END ), 0) * (arod.RequestedQuantity)* (ISNULL(arod.CostDestroyed, 0)/100) AS DestroyAllocatedAmount,
                                       pro.ImageUrl,
                                       pro.ProductNameCN,
                                       ISNULL(wh.WareHouseName,'') as OverseaWareHouseName,pro.ProductProperty
                                    FROM RB_Amazon_Removal_Order_Detail arod with (NOLOCK)
                                         LEFT JOIN RB_Removeorder_ReceiveDetail rrd with (NOLOCK) 
                                                ON arod.OrderID = rrd.OrderID 
                                               AND arod.OrderSourceID = rrd.OrderSourceID 
                                               AND arod.CustomerID = rrd.CustomerID
                                               AND arod.SKU  = rrd.SellerSKU
                                               AND arod.FnSKU = rrd.FNSKU
                                         
                                         LEFT JOIN RB_RemovalOrder_BusinessExpand robe (NOLOCK)    
                                                ON robe.CustomerID = arod.CustomerID
                                               AND robe.OrderSourceID = arod.OrderSourceID
                                               AND robe.RemovalOrderCode = arod.OrderID
                                         LEFT JOIN RB_OrderSource (nolock) os
                                                ON os.CustomerID = arod.CustomerID 
                                               AND os.ID = arod.OrderSourceID
                                         left join  RB_WareHouse (nolock) wh
                                               on  os.CustomerID = wh.CustomerID
                                               and  os.RemovalOrderDefaultWareHouseID = wh.ID
                                         LEFT JOIN RB_Product_OrderSourceSKU orsku with (NOLOCK) 
                                                ON arod.CustomerID = orsku.CustomerID
                                               AND arod.OrderSourceID = orsku.OrderSourceID 
                                               AND arod.SKU = orsku.OrderSourceSKU 
                                         LEFT JOIN RB_Product pro with (NOLOCK) 
                                                ON orsku.SKU = pro.SKU 
                                               AND orsku.CustomerID = pro.CustomerID
                                         LEFT JOIN RB_RemovalOrder_SkuItem_AuditSatusExtend (NOLOCK) rsase
                                                ON rsase.CustomerID = arod.CustomerID
                                               AND rsase.ReportID = arod.ID
                                         LEFT JOIN RB_Admin (nolock) ra
                                                ON arod.CustomerID = ra.CustomerID
                                               AND arod.DestroyedAdminID = ra.ID
                                         LEFT JOIN RB_Department (nolock) dp
                                                ON ra.CustomerID = dp.CustomerID
                                               AND ra.DepartmentID = dp.ID INNER JOIN #tabStr1 t1 on t1.id = arod.ID  WHERE arod.CustomerID = @CustomerID  AND rsase.ProcessArrivalTime >= @StartDate AND rsase.ProcessArrivalTime < @EndDate  AND NOT EXISTS (SELECT 1 FROM  RB_RemovalOrderCreateRecord (nolock) rocr1 
                                                              WHERE rocr1.CustomerID = arod.CustomerID
                                                                    AND rocr1.OrderSourceID = arod.OrderSourceID 
                                                                    AND rocr1.RemovalOrderCode = arod.OrderID) AND rsase.AuditSatus = 2  and exists(select  1
                                                 from  RB_OrderSource_SaleAdmin osa (NOLOCK)
                                                where  osa.OrderSourceID = arod.OrderSourceID
                                                  and  osa.CustomerID = arod.CustomerID
                                                  and  osa.AdminID = 3908
                                               ) ) AS PagerTable
PARAMS:@CustomerID = 1 ,@StartDate = 2026-04-27 ,@EndDate = 2026/5/12 0:00:00 ,@SnapshotDate = 2026/5/9 10:40:17 ,
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.DAL.DBOperator.QueryPager(String SQLTemporary, String SQLClearTemporary, String SQLString, String strOrder, Int32 pageIndex, Int32 pageSize, Int32& recordCount, Int32 times, SqlParameter[] cmdParms)
   在 RB.DALExtendV2.RB_Amazon_Removal_Order_DetailExtendV2.GetRemoveOrderSKUDetail(CM_GetRemovalOrderCreateRecordSkuItemsParam para, Boolean IsAutoSubmit, Int32& recordCount)
   在 PandaBuy.ERP.Web.IrobotBox.RemoveOrder.RemoveOrderSKUList.GetBatchAuditCount()
   在 PandaBuy.ERP.Web.IrobotBox.RemoveOrder.RemoveOrderSKUList.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_removeorder_removeorderskulist_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. 2026-05-11 14:26:07, 由 袁慧斌 创建。
  2. 2026-05-11 14:29:50, 由 李乐同 指派给 程伟。
    修改了 指派给，旧值为 "liletong"，新值为 "chengwei"。
  3. 2026-05-11 14:34:10, 由 程伟 指派给 鞠智明。
    修改了 指派给，旧值为 "chengwei"，新值为 "juzhiming"。
  4. 2026-05-12 11:12:28, 由 鞠智明 解决，方案为 性能问题 。
    修改了 解决方案，旧值为 ""，新值为 "performance"。
    修改了 解决版本，旧值为 ""，新值为 "trunk"。
    修改了 解决日期，旧值为 ""，新值为 "2026-05-12 11:12:05"。
    修改了 指派给 ，旧值为 "juzhiming"，新值为 "liuchao"。
    修改了 Bug状态 ，旧值为 "active"，新值为 "resolved"。
    修改了 是否确认，旧值为 "0"，新值为 "1"。
    修改了 解决者 ，旧值为 ""，新值为 "juzhiming"。
    已优化
  5. 2026-05-14 09:33:25, 由 刘超 编辑。
    修改了 测试责任人，旧值为 ""，新值为 "yuanhuibin"。
    修改了 解决时效 ，旧值为 "0"，新值为 "20.77"。
    修改了 重现步骤 ，区别为：
    002- [10:40:51] -------------------------------------------------------------CODE:N10405119Error:11_-2_0_-2146232060SQL: drop table if exists #tabStr0; drop table if exists #tabStr1;declare @CheckOrderCodeStr0 varchar(max)= '101227,101228,107376,107377,107378,107379,107380,111478,111479,111480,111481,111482,111483,111484,111485,111486,111487,111488,111489,111490,111577,111602,111603,111604,111605,111606,111607,111827,112176,112552,112553,112554,112555,112556,112557,112558,112559,112560,112561,112562,112563,112564,112565,112566,112567,112568,112569,112570,112571,112572,112573,112574,112575,112576,112577,112578,112579,112580,112581,112582,112583,112584,112585,112586,112587,112588,112589,112590,112591,112592,112593,112594,112595,112596,112597,112598,112599,112600,112601,112602,112603,112604,112605,112606,112607,112608,112609,112610,112611,112612,112613,112614,112615,112616,112617,112618,112619,112620,112621,112622,112623,112624,112625,112626,112627,112628,112629,112630,112631,112632,112633,112634,112635,112636,112637,112638,112639,112640,112641,112642,112643,113038,115495,115496,115497,115498,115499,115500,115501,115502,115503,115504,115505,115506,115507,115508,115509,115510,115511,115519,115520,115521,115522,115523,115524,115525,115526,115527,115528,116977,116978,116979,116980,116981,117030,117043,119356,119357,119358,119359,119360,119361,121252,121253,121254,121255,121256,121257,121258,121259,121260,121261,121262,121263,121264,121265,121308,121309,121310,121311,121312,121313,122182,122183,122184,122185,122186,122187,122188,122189,122190,122191,122192,122193,122194,122195,122196,122197,122198,122199,122200,122201,122202,122203,122204,122205,122206,122207,122208,122209,122210,122211,122212,122213,122214,122215,122216,122217,123242,123243,123244,124917,124918,124919,124920,124921,124922,125551,125552,125553,125554,125555,125556,125557,125558,125559,125560,125561,125562,125563,125564,125565,125566,125693,126137,126327,126652,126723,127587,127588,127589,127590,127591,127592,127593,128254,128255,128268,128269,128270,128271,128272,128276,128306,128307,128347,128348,128349,128350,128351,128352,128353,128354,128355,128356,128357,128362,128384,128452,128467,128468,128469,128471,128474,128475,128476,128477,128478,128479,128480,128481,128763,128764,128765,129105,129106,129107,129108,129109,129110,129112,129113,129114,129116,129131,129132,129135,129136,129137,129138,129139,129141,129142,129143,129144,129262,129279,129280,129286,129287,129288,129289,129290,129291,129450,129451,129452,129453,129454,129455,129456,129457,129458,129459,129460,129463,129464,129465,129466,129467,129468,130916,131624,131625,131626,131627,131628,132573,132574,132575,132576,133265,133266,133267,133268,133269,133270,133271,133272,133273,133274,134895,134896,134897,134898,134899,134900,134902,134903,135018,135019,135020,135021,135022,135023,135024,135051,135052,135053,135054,135055,135056,135057,135058,135059,135060,135061,135062,135063,135064,135065,135066,135067,135068,135069,135094,135785,140464,140749,140750,140751,140752,140753,140754,140755,140756,140757,140758,140759,140760,140761,140762,140763,140764,140765,140898,143854,143855,143856,143857,143858,144246,144247,144248,144249,144250,144251,144252,144253,144498,144499,149099,149100,149101,149102,149135,149136,149868,149869,149870,149871,149872,149873,149874,149875,149876,149877,149878,149879,149880,149881,149882,149883,150090,150091,150092,150589,150590,150591,150592,150593,150594,150595,150596,150597,150598,150605,150606,150607,150608,150609,150610,150611,150612,150613,150614,150631,150632,150633,150634,150635,150636,150637,150638,150639,150640,150646,150647,150648,150649,150650,150651,150652,150655,150656,150658,150659,150660,150661,150662,150663,150664,150665,150666,150667,150668,150669,150670,150671,150672,150673,150674,150675,150676,150677,150678,150679,150680,150681,150682,150683,150684,150685,150686,150687,150696,150697,150698,150699,150700,150701,150702,150703,150704,150705,150710,150711,150934,150935,151451,151452,151453,151454,151455,151476,151477,151478,151479,151480,151481,151482,151483,151484,151789,151790,151791,151792,151793,151794,151795,151796,151797,151804,151805,151806,151807,151808,151809,151810,151811,151812,151861,151862,151863,151864,151865,151866,151867,151868,151869,151870,151871,151872,151873,151874,151875,151876,151877,151878,151879,152015,152016,152017,152018,152019,152020,152021,152022,152023,152024,152025,152026,152027,152028,152029,152030,152031,152032,152033,152034,152035,152036,152037,152038,152039,152040,152041,152042,152043,152044,152045,152046,152047,152048,152049,152050,152051,152052,152053,152054,152055,152056,152089,152090,152091,154821,155874,155875,155876,155877,155878,155879,156436,156437,156438,156439,156440,156483,156484,156485,156486,156983,157062,157063,157072,157073,157074,157075,157076,157077,157078,157079,157080,157081,157082,157083,157648,157649,157650,157651,157652,163418,164797,164798,164799,164800,164801,164802,164803,164804,164805,164806,164807,164808,164809,164869,164958,164959,164960,165076,165077,165078,165079,165080,165081,166136,166137,166138,166139,166140,166141,166142,166143,166144,166973,167083,167084,167085,167086,167087,167428,168800,168801,168802,168803,168804,168805,168806,168807,168808,172012,172013,172014,172015,172016,172017,172018,172019,172020,172021,172871,172872,172873,172877,172878,172879,173277,173278,173279,173280,173281,173282,173283,173284,173797,173798,173799,173800,173801,173835,173836,173837,173838,174013,174014,174015,174016,174017,174018,174019,174020,174021,174022,174023,174024,174025,174026,174027,174028,174029,174030,174031,174032,174033,174034,174035,174036,174037,174038,174039,174040,174041,174042,174043,174044,174045,174046,175650,175651,175652,175653,175654,175655,175656,175657,175658,175659,175660,175661,175662,175663,175664,175665,175666,175667,175668,175669,175670,175671,175672,175673,175674,175675,175676,175677,175678,175679,175680,175681,175820,175821,175822,175823,175824,175825,175826,175827,175828,175834,175842,177631,180897,180898,180899,180900,180901,180902,180903,180904,180905,180908,180909,180910,180911,180912,180913,180914,180969,180970,180971,180972,180973,180974,180975,180976,180977,180978,180979,180980,180981,180982,180983,180984,180985,180986,180987,180988,180989,180990,180991,180992,180993,180994,180995,180996,180997,180998,180999,181000,181001,181002,181003,181004,181005,181006,181007,181008,181009,181010,181011,181012,181013,181014,181015,181016,181017,181018,181019,181020,181021,181022,181023,181024,181507,181892,181893,181894,181895,181896,182986,183051,183071,188159,188160,188161,188162,188163,188164,188165,188166,188167,188168,188891,188892,188893,189478,190148,190180,190181,190182,191422,191423,191424,191463,191464,191465,191466,191467,191468,191469,191470,191471,191472,191484,191487,191488,191489,191490,191491,191492,192679,192680,192681,193169,193971,193972,193973,193974,195272,195273,195274,195275,195276,195277,195278,195279,195280,195281,199204,199205,199416,199417,199418,199419,199420,199421,199422,199423,199424,199425,199426,199427,199428,199429,199430,199431,199432,199433,199434,199435,199436,199437,199438,199439,199440,199441,199442,199443,199444,199445,199446,199447,199514,199515,199516,199517,199518,199519,199520,199521,199522,199523,199524,199525,199526,199527,199528,199529,199530,199531,199532,199533,199543,199544,199545,199546,199547,199548,199549,199550,199551,199552,199553,199554,199555,199556,199557,199558,199559,199560,199561,199562,199563,199564,199565,199570,199571,199572,199573,199574,199575,199576,199577,199578,199579,199580,199581,199582,199583,199584,199585,199586,199587,199588,199589,199590,199591,199722,199723,199724,199963,199964,200454,200455,200456,200457,200458,200459,200460,201254,201255,201256,201257,201258,201259,201260,201855,201987,201992,201993,201994,201995,201996,201997,201998,201999,202000,202013,202014,204031,204032,204033,204034,204035,204837,204838,205288,205289,205290,205291,205292,205293,205294,205295,205928,205929,205930,205931,205932,205933,205934,205935,205936,205937,205938,205939,205940,205953,205954,205955,205956,205957,205958,205959,205960,205961,205962,205963,205964,205965,205966,205967,205968,205969,205970,205971,205972,205973,205974,205975,205976,205977,205978,206249,206250,206251,206252,206253,206254,206255,206256,206257,206258,206259,206260,206261,206262,206263,206264,206265,206266,206267,206268,206269,206270,206271,206272,206273,206274,206275,206276,206277,206278,206279,206280,206281,206282,206283,206284,206285,206286,206287,206288,206316,206317,206318,206319,206320,206321,206322,206779,206780,206781,206782,206783,206784,206785,206786,206787,206788,206789,206790,206791,206792,206793,206794,206795,206796,206797,206798,206799,206800,206801,206802,206803,206804,206805,206806,206807,206808,206809,206810,206811,206812,206813,206814,206815,206816,206817,206818,206819,206820,206821,206822,206823,206824,206825,206826,206827,206828,206829,206830,206831,206832,206833,206834,206835,206836,206837,206838,206839,206840,206841,206842,206843,206844,206845,206846,206847,206848,206849,206850,206851,206852,206853,206854,206855,206856,206857,206858,206859,206860,206861,206862,206863,206864,206865,206866,206867,206868,206869,206870,206871,206872,206873,206874,206875,206876,206877,206878,206879,206880,206881,206882,206883,206884,206885,206886,206887,206888,206889,206890,206891,206892,206893,206894,206895,206896,206897,206898,206899,206900,206901,206902,206903,206904,206905,206906,206907,206908,206909,206910,206911,206912,206913,206914,206915,206916,206917,206918,206919,206920,206921,206922,206923,206924,206925,206926,206927,206928,206929,206930,206931,206932,206933,206934,206935,206936,206937,206938,206939,206940,206941,206942,206943,206944,206945,206946,206947,206948,206949,206950,206951,206952,206953,206954,206955,206956,206957,206958,206959,206960,206961,206962,206963,206964,206965,206966,206967,206968,206969,206970,206971,206972,206973,206974,206975,206976,206977,206978,206979,206980,206981,206982,206983,206984,206985,206986,206987,206988,206989,206990,206991,206992,206993,206994,206995,206996,206997,206998,206999,207000,207001,207002,207003,207004,207005,207006,207007,207008,207009,207010,207011,207012,207013,207014,207015,207016,207017,207018,207019,207020,207021,207022,207023,207024,207025,207026,207027,207028,207029,207030,207031,207032,207033,207034,207035,207036,207037,207038,207039,207040,207041,207042,207043,207044,207045,207046,207047,207048,207049,207050,207051,207052,207053,207054,207055,207056,207057,207058,207059,207060,207061,207062,207063,207064,207065,207066,207067,207068,207069,207070,207071,207072,207073,207074,207075,207076,207077,207078,207079,207080,207081,207082,207083,207084,207085,207086,207087,207088,207089,207090,207091,207092,207093,207094,207095,207096,207097,207098,207099,207100,207101,207102,207103,207104,207105,207106,207107,207108,207109,207110,207111,207112,207113,207114,207115,207116,207117,207136,207137,207910,208731,208732,208754,208860,208861,208862,208863,208864,208865,208866,208867,208868,208869,208870,208871,208872,211100,211285,211286,211287,211288,211289,211375,211376,211377,211378,211379,211380,211381,212680,214038,216555,216556,216557,216558,216559,216560,216561,217958,217959,217960,217961,217962,217963,217964,217965,217966,217967,217968,217969,217970,217971,217972,217973,217974,217975,217976,217977,217978,217979,217980,217981,217982,217983,217984,217985,218098,218099,218100,218101,218102,218103,218104,218105,218106,218107,218108,218109,218110,218111,218112,218113,218114,218115,218116,218117,218118,218119,219290,219291,219292,219293,219294,219295,219296,219484,219485,219487,219489,219490,219491,219492,219544,219545,219546,219547,219548,219549,219550,219629,219630,219825,221601,221602,221603,221604,221605,221606,221607,221608,221609,221610,221611,221612,221617,221618,221619,221620,221621,221622,221623,221624,221625,221626,221627,221628,221629,221630,221631,221632,221633,221634,221635,222707,222977,222980,222982,222984,223005,223034,223035,223043,223128,223129,223130,223131,223157,223158,223159,223160,223162,223163,223164,223165,223166,223763,225577,227523,227525,227526,227529,227530,227531,227533,227595,227603,227606,227858,229157,229158,229159,229160,229161,229162,229163,229164,229206,229782,229783,229784,229785,229799,229809,229810,229881,229894,232027,232029,232418,232420,232452,232455,232456,232457,232458,232459,234093,234094,234795,234796,235413,235414,235415,235416,235417,235418,235419,235420,235421,235422,235441,235442,235443,235444,235445,235446,235561,235562,235563,235564,235565,235566,235567,235568,235569,235570,235571,235572,235573,235574,235575,235576,235577,235578,235579,236128,236129,236130,236131,236132,236133,236134,236135,236136,236137,236138,236139,236140,236141,236142,236143,236144,236145,236146,236147,236148,236149,236150,236151,236152,236153,236154,236155,236156,236157,236158,236159,236160,236161,236714,236715,236723,236724,236725,237043,237044,237045,237046,237047,237048,237049,237050,237051,237052,237053,237235,237510,237979,237980,237981,237982,237985,237986,237987,237989,237990,237991,237992,237993,237994,237995,238019,238020,238021,238027,238028,238029,238030,238031,238033,238618,238619,238620,238621,238622,238623,239178,239179,239180,239181,239182,239183,239184,239185,239186,239187,239188,239189,239190,239191,239192,239193,239194,239195,239196,239197,239198,239199,239200,239201,239202,239203,239204,239205,239206,239207,239208,239209,239210,239211,239212,239213,239214,239215,239216,239217,239218,239219,239220,239221,239222,239223,239224,239225,239226,239227,239228,239229,239230,239231,239232,239233,239234,239235,239236,239237,239238,239239,239240,239241
    002+ [10:40:51] -------------------------------------------------------------CODE:N10405119Error:11_-2_0_-2146232060SQL: drop table if exists #tabStr0; drop table if exists #tabStr1;declare @CheckOrderCodeStr0 varchar(max)= '101227,101228,107376,107377,107378,107379,107380,111478,111479,111480,111481,111482,111483,111484,111485,111486,111487,111488,111489,111490,111577,111602,111603,111604,111605,111606,111607,111827,112176,112552,112553,112554,112555,112556,112557,112558,112559,112560,112561,112562,112563,112564,112565,112566,112567,112568,112569,112570,112571,112572,112573,112574,112575,112576,112577,112578,112579,112580,112581,112582,112583,112584,112585,112586,112587,112588,112589,112590,112591,112592,112593,112594,112595,112596,112597,112598,112599,112600,112601,112602,112603,112604,112605,112606,112607,112608,112609,112610,112611,112612,112613,112614,112615,112616,112617,112618,112619,112620,112621,112622,112623,112624,112625,112626,112627,112628,112629,112630,112631,112632,112633,112634,112635,112636,112637,112638,112639,112640,112641,112642,112643,113038,115495,115496,115497,115498,115499,115500,115501,115502,115503,115504,115505,115506,115507,115508,115509,115510,115511,115519,115520,115521,115522,115523,115524,115525,115526,115527,115528,116977,116978,116979,116980,116981,117030,117043,119356,119357,119358,119359,119360,119361,121252,121253,121254,121255,121256,121257,121258,121259,121260,121261,121262,121263,121264,121265,121308,121309,121310,121311,121312,121313,122182,122183,122184,122185,122186,122187,122188,122189,122190,122191,122192,122193,122194,122195,122196,122197,122198,122199,122200,122201,122202,122203,122204,122205,122206,122207,122208,122209,122210,122211,122212,122213,122214,122215,122216,122217,123242,123243,123244,124917,124918,124919,124920,124921,124922,125551,125552,125553,125554,125555,125556,125557,125558,125559,125560,125561,125562,125563,125564,125565,125566,125693,126137,126327,126652,126723,127587,127588,127589,127590,127591,127592,127593,128254,128255,128268,128269,128270,128271,128272,128276,128306,128307,128347,128348,128349,128350,128351,128352,128353,128354,128355,128356,128357,128362,128384,128452,128467,128468,128469,128471,128474,128475,128476,128477,128478,128479,128480,128481,128763,128764,128765,129105,129106,129107,129108,129109,129110,129112,129113,129114,129116,129131,129132,129135,129136,129137,129138,129139,129141,129142,129143,129144,129262,129279,129280,129286,129287,129288,129289,129290,129291,129450,129451,129452,129453,129454,129455,129456,129457,129458,129459,129460,129463,129464,129465,129466,129467,129468,130916,131624,131625,131626,131627,131628,132573,132574,132575,132576,133265,133266,133267,133268,133269,133270,133271,133272,133273,133274,134895,134896,134897,134898,134899,134900,134902,134903,135018,135019,135020,135021,135022,135023,135024,135051,135052,135053,135054,135055,135056,135057,135058,135059,135060,135061,135062,135063,135064,135065,135066,135067,135068,135069,135094,135785,140464,140749,140750,140751,140752,140753,140754,140755,140756,140757,140758,140759,140760,140761,140762,140763,140764,140765,140898,143854,143855,143856,143857,143858,144246,144247,144248,144249,144250,144251,144252,144253,144498,144499,149099,149100,149101,149102,149135,149136,149868,149869,149870,149871,149872,149873,149874,149875,149876,149877,149878,149879,149880,149881,149882,149883,150090,150091,150092,150589,150590,150591,150592,150593,150594,150595,150596,150597,150598,150605,150606,150607,150608,150609,150610,150611,150612,150613,150614,150631,150632,150633,150634,150635,150636,150637,150638,150639,150640,150646,150647,150648,150649,150650,150651,150652,150655,150656,150658,150659,150660,150661,150662,150663,150664,150665,150666,150667,150668,150669,150670,150671,150672,150673,150674,150675,150676,150677,150678,150679,150680,150681,150682,150683,150684,150685,150686,150687,150696,150697,150698,150699,150700,150701,150702,150703,150704,150705,150710,150711,150934,150935,151451,151452,151453,151454,151455,151476,151477,151478,151479,151480,151481,151482,151483,151484,151789,151790,151791,151792,151793,151794,151795,151796,151797,151804,151805,151806,151807,151808,151809,151810,151811,151812,151861,151862,151863,151864,151865,151866,151867,151868,151869,151870,151871,151872,151873,151874,151875,151876,151877,151878,151879,152015,152016,152017,152018,152019,152020,152021,152022,152023,152024,152025,152026,152027,152028,152029,152030,152031,152032,152033,152034,152035,152036,152037,152038,152039,152040,152041,152042,152043,152044,152045,152046,152047,152048,152049,152050,152051,152052,152053,152054,152055,152056,152089,152090,152091,154821,155874,155875,155876,155877,155878,155879,156436,156437,156438,156439,156440,156483,156484,156485,156486,156983,157062,157063,157072,157073,157074,157075,157076,157077,157078,157079,157080,157081,157082,157083,157648,157649,157650,157651,157652,163418,164797,164798,164799,164800,164801,164802,164803,164804,164805,164806,164807,164808,164809,164869,164958,164959,164960,165076,165077,165078,165079,165080,165081,166136,166137,166138,166139,166140,166141,166142,166143,166144,166973,167083,167084,167085,167086,167087,167428,168800,168801,168802,168803,168804,168805,168806,168807,168808,172012,172013,172014,172015,172016,172017,172018,172019,172020,172021,172871,172872,172873,172877,172878,172879,173277,173278,173279,173280,173281,173282,173283,173284,173797,173798,173799,173800,173801,173835,173836,173837,173838,174013,174014,174015,174016,174017,174018,174019,174020,174021,174022,174023,174024,174025,174026,174027,174028,174029,174030,174031,174032,174033,174034,174035,174036,174037,174038,174039,174040,174041,174042,174043,174044,174045,174046,175650,175651,175652,175653,175654,175655,175656,175657,175658,175659,175660,175661,175662,175663,175664,175665,175666,175667,175668,175669,175670,175671,175672,175673,175674,175675,175676,175677,175678,175679,175680,175681,175820,175821,175822,175823,175824,175825,175826,175827,175828,175834,175842,177631,180897,180898,180899,180900,180901,180902,180903,180904,180905,180908,180909,180910,180911,180912,180913,180914,180969,180970,180971,180972,180973,180974,180975,180976,180977,180978,180979,180980,180981,180982,180983,180984,180985,180986,180987,180988,180989,180990,180991,180992,180993,180994,180995,180996,180997,180998,180999,181000,181001,181002,181003,181004,181005,181006,181007,181008,181009,181010,181011,181012,181013,181014,181015,181016,181017,181018,181019,181020,181021,181022,181023,181024,181507,181892,181893,181894,181895,181896,182986,183051,183071,188159,188160,188161,188162,188163,188164,188165,188166,188167,188168,188891,188892,188893,189478,190148,190180,190181,190182,191422,191423,191424,191463,191464,191465,191466,191467,191468,191469,191470,191471,191472,191484,191487,191488,191489,191490,191491,191492,192679,192680,192681,193169,193971,193972,193973,193974,195272,195273,195274,195275,195276,195277,195278,195279,195280,195281,199204,199205,199416,199417,199418,199419,199420,199421,199422,199423,199424,199425,199426,199427,199428,199429,199430,199431,199432,199433,199434,199435,199436,199437,199438,199439,199440,199441,199442,199443,199444,199445,199446,199447,199514,199515,199516,199517,199518,199519,199520,199521,199522,199523,199524,199525,199526,199527,199528,199529,199530,199531,199532,199533,199543,199544,199545,199546,199547,199548,199549,199550,199551,199552,199553,199554,199555,199556,199557,199558,199559,199560,199561,199562,199563,199564,199565,199570,199571,199572,199573,199574,199575,199576,199577,199578,199579,199580,199581,199582,199583,199584,199585,199586,199587,199588,199589,199590,199591,199722,199723,199724,199963,199964,200454,200455,200456,200457,200458,200459,200460,201254,201255,201256,201257,201258,201259,201260,201855,201987,201992,201993,201994,201995,201996,201997,201998,201999,202000,202013,202014,204031,204032,204033,204034,204035,204837,204838,205288,205289,205290,205291,205292,205293,205294,205295,205928,205929,205930,205931,205932,205933,205934,205935,205936,205937,205938,205939,205940,205953,205954,205955,205956,205957,205958,205959,205960,205961,205962,205963,205964,205965,205966,205967,205968,205969,205970,205971,205972,205973,205974,205975,205976,205977,205978,206249,206250,206251,206252,206253,206254,206255,206256,206257,206258,206259,206260,206261,206262,206263,206264,206265,206266,206267,206268,206269,206270,206271,206272,206273,206274,206275,206276,206277,206278,206279,206280,206281,206282,206283,206284,206285,206286,206287,206288,206316,206317,206318,206319,206320,206321,206322,206779,206780,206781,206782,206783,206784,206785,206786,206787,206788,206789,206790,206791,206792,206793,206794,206795,206796,206797,206798,206799,206800,206801,206802,206803,206804,206805,206806,206807,206808,206809,206810,206811,206812,206813,206814,206815,206816,206817,206818,206819,206820,206821,206822,206823,206824,206825,206826,206827,206828,206829,206830,206831,206832,206833,206834,206835,206836,206837,206838,206839,206840,206841,206842,206843,206844,206845,206846,206847,206848,206849,206850,206851,206852,206853,206854,206855,206856,206857,206858,206859,206860,206861,206862,206863,206864,206865,206866,206867,206868,206869,206870,206871,206872,206873,206874,206875,206876,206877,206878,206879,206880,206881,206882,206883,206884,206885,206886,206887,206888,206889,206890,206891,206892,206893,206894,206895,206896,206897,206898,206899,206900,206901,206902,206903,206904,206905,206906,206907,206908,206909,206910,206911,206912,206913,206914,206915,206916,206917,206918,206919,206920,206921,206922,206923,206924,206925,206926,206927,206928,206929,206930,206931,206932,206933,206934,206935,206936,206937,206938,206939,206940,206941,206942,206943,206944,206945,206946,206947,206948,206949,206950,206951,206952,206953,206954,206955,206956,206957,206958,206959,206960,206961,206962,206963,206964,206965,206966,206967,206968,206969,206970,206971,206972,206973,206974,206975,206976,206977,206978,206979,206980,206981,206982,206983,206984,206985,206986,206987,206988,206989,206990,206991,206992,206993,206994,206995,206996,206997,206998,206999,207000,207001,207002,207003,207004,207005,207006,207007,207008,207009,207010,207011,207012,207013,207014,207015,207016,207017,207018,207019,207020,207021,207022,207023,207024,207025,207026,207027,207028,207029,207030,207031,207032,207033,207034,207035,207036,207037,207038,207039,207040,207041,207042,207043,207044,207045,207046,207047,207048,207049,207050,207051,207052,207053,207054,207055,207056,207057,207058,207059,207060,207061,207062,207063,207064,207065,207066,207067,207068,207069,207070,207071,207072,207073,207074,207075,207076,207077,207078,207079,207080,207081,207082,207083,207084,207085,207086,207087,207088,207089,207090,207091,207092,207093,207094,207095,207096,207097,207098,207099,207100,207101,207102,207103,207104,207105,207106,207107,207108,207109,207110,207111,207112,207113,207114,207115,207116,207117,207136,207137,207910,208731,208732,208754,208860,208861,208862,208863,208864,208865,208866,208867,208868,208869,208870,208871,208872,211100,211285,211286,211287,211288,211289,211375,211376,211377,211378,211379,211380,211381,212680,214038,216555,216556,216557,216558,216559,216560,216561,217958,217959,217960,217961,217962,217963,217964,217965,217966,217967,217968,217969,217970,217971,217972,217973,217974,217975,217976,217977,217978,217979,217980,217981,217982,217983,217984,217985,218098,218099,218100,218101,218102,218103,218104,218105,218106,218107,218108,218109,218110,218111,218112,218113,218114,218115,218116,218117,218118,218119,219290,219291,219292,219293,219294,219295,219296,219484,219485,219487,219489,219490,219491,219492,219544,219545,219546,219547,219548,219549,219550,219629,219630,219825,221601,221602,221603,221604,221605,221606,221607,221608,221609,221610,221611,221612,221617,221618,221619,221620,221621,221622,221623,221624,221625,221626,221627,221628,221629,221630,221631,221632,221633,221634,221635,222707,222977,222980,222982,222984,223005,223034,223035,223043,223128,223129,223130,223131,223157,223158,223159,223160,223162,223163,223164,223165,223166,223763,225577,227523,227525,227526,227529,227530,227531,227533,227595,227603,227606,227858,229157,229158,229159,229160,229161,229162,229163,229164,229206,229782,229783,229784,229785,229799,229809,229810,229881,229894,232027,232029,232418,232420,232452,232455,232456,232457,232458,232459,234093,234094,234795,234796,235413,235414,235415,235416,235417,235418,235419,235420,235421,235422,235441,235442,235443,235444,235445,235446,235561,235562,235563,235564,235565,235566,235567,235568,235569,235570,235571,235572,235573,235574,235575,235576,235577,235578,235579,236128,236129,236130,236131,236132,236133,236134,236135,236136,236137,236138,236139,236140,236141,236142,236143,236144,236145,236146,236147,236148,236149,236150,236151,236152,236153,236154,236155,236156,236157,236158,236159,236160,236161,236714,236715,236723,236724,236725,237043,237044,237045,237046,237047,237048,237049,237050,237051,237052,237053,237235,237510,237979,237980,237981,237982,237985,237986,237987,237989,237990,237991,237992,237993,237994,237995,238019,238020,238021,238027,238028,238029,238030,238031,238033,238618,238619,238620,238621,238622,238623,239178,239179,239180,239181,239182,239183,239184,239185,239186,239187,239188,239189,239190,239191,239192,239193,239194,239195,239196,239197,239198,239199,239200,239201,239202,239203,239204,239205,239206,239207,239208,239209,239210,239211,239212,239213,239214,239215,239216,239217,239218,239219,239220,239221,239222,239223,239224,239225,239226,239227,239228,239229,239230,239231,239232,239233,239234,239235,239236,239237,239238,239239,239240,239241
    002- <p><br /><br />[10:40:51] -------------------------------------------------------------<br />CODE:N10405119<br />Error:11_-2_0_-2146232060<br />SQL: drop table if exists #tabStr0;<br /> drop table if exists #tabStr1;declare @CheckOrderCodeStr0 varchar(max)= '101227,101228,107376,107377,107378,107379,107380,111478,111479,111480,111481,111482,111483,111484,111485,111486,111487,111488,111489,111490,111577,111602,111603,111604,111605,111606,111607,111827,112176,112552,112553,112554,112555,112556,112557,112558,112559,112560,112561,112562,112563,112564,112565,112566,112567,112568,112569,112570,112571,112572,112573,112574,112575,112576,112577,112578,112579,112580,112581,112582,112583,112584,112585,112586,112587,112588,112589,112590,112591,112592,112593,112594,112595,112596,112597,112598,112599,112600,112601,112602,112603,112604,112605,112606,112607,112608,112609,112610,112611,112612,112613,112614,112615,112616,112617,112618,112619,112620,112621,112622,112623,112624,112625,112626,112627,112628,112629,112630,112631,112632,112633,112634,112635,112636,112637,112638,112639,112640,112641,112642,112643,113038,115495,115496,115497,115498,115499,115500,115501,115502,115503,115504,115505,115506,115507,115508,115509,115510,115511,115519,115520,115521,115522,115523,115524,115525,115526,115527,115528,116977,116978,116979,116980,116981,117030,117043,119356,119357,119358,119359,119360,119361,121252,121253,121254,121255,121256,121257,121258,121259,121260,121261,121262,121263,121264,121265,121308,121309,121310,121311,121312,121313,122182,122183,122184,122185,122186,122187,122188,122189,122190,122191,122192,122193,122194,122195,122196,122197,122198,122199,122200,122201,122202,122203,122204,122205,122206,122207,122208,122209,122210,122211,122212,122213,122214,122215,122216,122217,123242,123243,123244,124917,124918,124919,124920,124921,124922,125551,125552,125553,125554,125555,125556,125557,125558,125559,125560,125561,125562,125563,125564,125565,125566,125693,126137,126327,126652,126723,127587,127588,127589,127590,127591,127592,127593,128254,128255,128268,128269,128270,128271,128272,128276,128306,128307,128347,128348,128349,128350,128351,128352,128353,128354,128355,128356,128357,128362,128384,128452,128467,128468,128469,128471,128474,128475,128476,128477,128478,128479,128480,128481,128763,128764,128765,129105,129106,129107,129108,129109,129110,129112,129113,129114,129116,129131,129132,129135,129136,129137,129138,129139,129141,129142,129143,129144,129262,129279,129280,129286,129287,129288,129289,129290,129291,129450,129451,129452,129453,129454,129455,129456,129457,129458,129459,129460,129463,129464,129465,129466,129467,129468,130916,131624,131625,131626,131627,131628,132573,132574,132575,132576,133265,133266,133267,133268,133269,133270,133271,133272,133273,133274,134895,134896,134897,134898,134899,134900,134902,134903,135018,135019,135020,135021,135022,135023,135024,135051,135052,135053,135054,135055,135056,135057,135058,135059,135060,135061,135062,135063,135064,135065,135066,135067,135068,135069,135094,135785,140464,140749,140750,140751,140752,140753,140754,140755,140756,140757,140758,140759,140760,140761,140762,140763,140764,140765,140898,143854,143855,143856,143857,143858,144246,144247,144248,144249,144250,144251,144252,144253,144498,144499,149099,149100,149101,149102,149135,149136,149868,149869,149870,149871,149872,149873,149874,149875,149876,149877,149878,149879,149880,149881,149882,149883,150090,150091,150092,150589,150590,150591,150592,150593,150594,150595,150596,150597,150598,150605,150606,150607,150608,150609,150610,150611,150612,150613,150614,150631,150632,150633,150634,150635,150636,150637,150638,150639,150640,150646,150647,150648,150649,150650,150651,150652,150655,150656,150658,150659,150660,150661,150662,150663,150664,150665,150666,150667,150668,150669,150670,150671,150672,150673,150674,150675,150676,150677,150678,150679,150680,150681,150682,150683,150684,150685,150686,150687,150696,150697,150698,150699,150700,150701,150702,150703,150704,150705,150710,150711,150934,150935,151451,151452,151453,151454,151455,151476,151477,151478,151479,151480,151481,151482,151483,151484,151789,151790,151791,151792,151793,151794,151795,151796,151797,151804,151805,151806,151807,151808,151809,151810,151811,151812,151861,151862,151863,151864,151865,151866,151867,151868,151869,151870,151871,151872,151873,151874,151875,151876,151877,151878,151879,152015,152016,152017,152018,152019,152020,152021,152022,152023,152024,152025,152026,152027,152028,152029,152030,152031,152032,152033,152034,152035,152036,152037,152038,152039,152040,152041,152042,152043,152044,152045,152046,152047,152048,152049,152050,152051,152052,152053,152054,152055,152056,152089,152090,152091,154821,155874,155875,155876,155877,155878,155879,156436,156437,156438,156439,156440,156483,156484,156485,156486,156983,157062,157063,157072,157073,157074,157075,157076,157077,157078,157079,157080,157081,157082,157083,157648,157649,157650,157651,157652,163418,164797,164798,164799,164800,164801,164802,164803,164804,164805,164806,164807,164808,164809,164869,164958,164959,164960,165076,165077,165078,165079,165080,165081,166136,166137,166138,166139,166140,166141,166142,166143,166144,166973,167083,167084,167085,167086,167087,167428,168800,168801,168802,168803,168804,168805,168806,168807,168808,172012,172013,172014,172015,172016,172017,172018,172019,172020,172021,172871,172872,172873,172877,172878,172879,173277,173278,173279,173280,173281,173282,173283,173284,173797,173798,173799,173800,173801,173835,173836,173837,173838,174013,174014,174015,174016,174017,174018,174019,174020,174021,174022,174023,174024,174025,174026,174027,174028,174029,174030,174031,174032,174033,174034,174035,174036,174037,174038,174039,174040,174041,174042,174043,174044,174045,174046,175650,175651,175652,175653,175654,175655,175656,175657,175658,175659,175660,175661,175662,175663,175664,175665,175666,175667,175668,175669,175670,175671,175672,175673,175674,175675,175676,175677,175678,175679,175680,175681,175820,175821,175822,175823,175824,175825,175826,175827,175828,175834,175842,177631,180897,180898,180899,180900,180901,180902,180903,180904,180905,180908,180909,180910,180911,180912,180913,180914,180969,180970,180971,180972,180973,180974,180975,180976,180977,180978,180979,180980,180981,180982,180983,180984,180985,180986,180987,180988,180989,180990,180991,180992,180993,180994,180995,180996,180997,180998,180999,181000,181001,181002,181003,181004,181005,181006,181007,181008,181009,181010,181011,181012,181013,181014,181015,181016,181017,181018,181019,181020,181021,181022,181023,181024,181507,181892,181893,181894,181895,181896,182986,183051,183071,188159,188160,188161,188162,188163,188164,188165,188166,188167,188168,188891,188892,188893,189478,190148,190180,190181,190182,191422,191423,191424,191463,191464,191465,191466,191467,191468,191469,191470,191471,191472,191484,191487,191488,191489,191490,191491,191492,192679,192680,192681,193169,193971,193972,193973,193974,195272,195273,195274,195275,195276,195277,195278,195279,195280,195281,199204,199205,199416,199417,199418,199419,199420,199421,199422,199423,199424,199425,199426,199427,199428,199429,199430,199431,199432,199433,199434,199435,199436,199437,199438,199439,199440,199441,199442,199443,199444,199445,199446,199447,199514,199515,199516,199517,199518,199519,199520,199521,199522,199523,199524,199525,199526,199527,199528,199529,199530,199531,199532,199533,199543,199544,199545,199546,199547,199548,199549,199550,199551,199552,199553,199554,199555,199556,199557,199558,199559,199560,199561,199562,199563,199564,199565,199570,199571,199572,199573,199574,199575,199576,199577,199578,199579,199580,199581,199582,199583,199584,199585,199586,199587,199588,199589,199590,199591,199722,199723,199724,199963,199964,200454,200455,200456,200457,200458,200459,200460,201254,201255,201256,201257,201258,201259,201260,201855,201987,201992,201993,201994,201995,201996,201997,201998,201999,202000,202013,202014,204031,204032,204033,204034,204035,204837,204838,205288,205289,205290,205291,205292,205293,205294,205295,205928,205929,205930,205931,205932,205933,205934,205935,205936,205937,205938,205939,205940,205953,205954,205955,205956,205957,205958,205959,205960,205961,205962,205963,205964,205965,205966,205967,205968,205969,205970,205971,205972,205973,205974,205975,205976,205977,205978,206249,206250,206251,206252,206253,206254,206255,206256,206257,206258,206259,206260,206261,206262,206263,206264,206265,206266,206267,206268,206269,206270,206271,206272,206273,206274,206275,206276,206277,206278,206279,206280,206281,206282,206283,206284,206285,206286,206287,206288,206316,206317,206318,206319,206320,206321,206322,206779,206780,206781,206782,206783,206784,206785,206786,206787,206788,206789,206790,206791,206792,206793,206794,206795,206796,206797,206798,206799,206800,206801,206802,206803,206804,206805,206806,206807,206808,206809,206810,206811,206812,206813,206814,206815,206816,206817,206818,206819,206820,206821,206822,206823,206824,206825,206826,206827,206828,206829,206830,206831,206832,206833,206834,206835,206836,206837,206838,206839,206840,206841,206842,206843,206844,206845,206846,206847,206848,206849,206850,206851,206852,206853,206854,206855,206856,206857,206858,206859,206860,206861,206862,206863,206864,206865,206866,206867,206868,206869,206870,206871,206872,206873,206874,206875,206876,206877,206878,206879,206880,206881,206882,206883,206884,206885,206886,206887,206888,206889,206890,206891,206892,206893,206894,206895,206896,206897,206898,206899,206900,206901,206902,206903,206904,206905,206906,206907,206908,206909,206910,206911,206912,206913,206914,206915,206916,206917,206918,206919,206920,206921,206922,206923,206924,206925,206926,206927,206928,206929,206930,206931,206932,206933,206934,206935,206936,206937,206938,206939,206940,206941,206942,206943,206944,206945,206946,206947,206948,206949,206950,206951,206952,206953,206954,206955,206956,206957,206958,206959,206960,206961,206962,206963,206964,206965,206966,206967,206968,206969,206970,206971,206972,206973,206974,206975,206976,206977,206978,206979,206980,206981,206982,206983,206984,206985,206986,206987,206988,206989,206990,206991,206992,206993,206994,206995,206996,206997,206998,206999,207000,207001,207002,207003,207004,207005,207006,207007,207008,207009,207010,207011,207012,207013,207014,207015,207016,207017,207018,207019,207020,207021,207022,207023,207024,207025,207026,207027,207028,207029,207030,207031,207032,207033,207034,207035,207036,207037,207038,207039,207040,207041,207042,207043,207044,207045,207046,207047,207048,207049,207050,207051,207052,207053,207054,207055,207056,207057,207058,207059,207060,207061,207062,207063,207064,207065,207066,207067,207068,207069,207070,207071,207072,207073,207074,207075,207076,207077,207078,207079,207080,207081,207082,207083,207084,207085,207086,207087,207088,207089,207090,207091,207092,207093,207094,207095,207096,207097,207098,207099,207100,207101,207102,207103,207104,207105,207106,207107,207108,207109,207110,207111,207112,207113,207114,207115,207116,207117,207136,207137,207910,208731,208732,208754,208860,208861,208862,208863,208864,208865,208866,208867,208868,208869,208870,208871,208872,211100,211285,211286,211287,211288,211289,211375,211376,211377,211378,211379,211380,211381,212680,214038,216555,216556,216557,216558,216559,216560,216561,217958,217959,217960,217961,217962,217963,217964,217965,217966,217967,217968,217969,217970,217971,217972,217973,217974,217975,217976,217977,217978,217979,217980,217981,217982,217983,217984,217985,218098,218099,218100,218101,218102,218103,218104,218105,218106,218107,218108,218109,218110,218111,218112,218113,218114,218115,218116,218117,218118,218119,219290,219291,219292,219293,219294,219295,219296,219484,219485,219487,219489,219490,219491,219492,219544,219545,219546,219547,219548,219549,219550,219629,219630,219825,221601,221602,221603,221604,221605,221606,221607,221608,221609,221610,221611,221612,221617,221618,221619,221620,221621,221622,221623,221624,221625,221626,221627,221628,221629,221630,221631,221632,221633,221634,221635,222707,222977,222980,222982,222984,223005,223034,223035,223043,223128,223129,223130,223131,223157,223158,223159,223160,223162,223163,223164,223165,223166,223763,225577,227523,227525,227526,227529,227530,227531,227533,227595,227603,227606,227858,229157,229158,229159,229160,229161,229162,229163,229164,229206,229782,229783,229784,229785,229799,229809,229810,229881,229894,232027,232029,232418,232420,232452,232455,232456,232457,232458,232459,234093,234094,234795,234796,235413,235414,235415,235416,235417,235418,235419,235420,235421,235422,235441,235442,235443,235444,235445,235446,235561,235562,235563,235564,235565,235566,235567,235568,235569,235570,235571,235572,235573,235574,235575,235576,235577,235578,235579,236128,236129,236130,236131,236132,236133,236134,236135,236136,236137,236138,236139,236140,236141,236142,236143,236144,236145,236146,236147,236148,236149,236150,236151,236152,236153,236154,236155,236156,236157,236158,236159,236160,236161,236714,236715,236723,236724,236725,237043,237044,237045,237046,237047,237048,237049,237050,237051,237052,237053,237235,237510,237979,237980,237981,237982,237985,237986,237987,237989,237990,237991,237992,237993,237994,237995,238019,238020,238021,238027,238028,238029,238030,238031,238033,238618,238619,238620,238621,238622,238623,239178,239179,239180,239181,239182,239183,239184,239185,239186,239187,239188,239189,239190,239191,239192,239193,239194,239195,239196,239197,239198,239199,239200,239201,239202,239203,239204,239205,239206,239207,239208,239209,239210,239211,239212,239213,239214,239215,239216,239217,239218,239219,239220,239221,239222,239223,239224,239225,239226,239227,239228,239229,239230,239231,239232,239233,239234,239235,239236,239237,239238,239239,239240,239241<br /></p>
    002+ <p><br /><br />[10:40:51] -------------------------------------------------------------<br />CODE:N10405119<br />Error:11_-2_0_-2146232060<br />SQL: drop table if exists #tabStr0;<br /> drop table if exists #tabStr1;declare @CheckOrderCodeStr0 varchar(max)= '101227,101228,107376,107377,107378,107379,107380,111478,111479,111480,111481,111482,111483,111484,111485,111486,111487,111488,111489,111490,111577,111602,111603,111604,111605,111606,111607,111827,112176,112552,112553,112554,112555,112556,112557,112558,112559,112560,112561,112562,112563,112564,112565,112566,112567,112568,112569,112570,112571,112572,112573,112574,112575,112576,112577,112578,112579,112580,112581,112582,112583,112584,112585,112586,112587,112588,112589,112590,112591,112592,112593,112594,112595,112596,112597,112598,112599,112600,112601,112602,112603,112604,112605,112606,112607,112608,112609,112610,112611,112612,112613,112614,112615,112616,112617,112618,112619,112620,112621,112622,112623,112624,112625,112626,112627,112628,112629,112630,112631,112632,112633,112634,112635,112636,112637,112638,112639,112640,112641,112642,112643,113038,115495,115496,115497,115498,115499,115500,115501,115502,115503,115504,115505,115506,115507,115508,115509,115510,115511,115519,115520,115521,115522,115523,115524,115525,115526,115527,115528,116977,116978,116979,116980,116981,117030,117043,119356,119357,119358,119359,119360,119361,121252,121253,121254,121255,121256,121257,121258,121259,121260,121261,121262,121263,121264,121265,121308,121309,121310,121311,121312,121313,122182,122183,122184,122185,122186,122187,122188,122189,122190,122191,122192,122193,122194,122195,122196,122197,122198,122199,122200,122201,122202,122203,122204,122205,122206,122207,122208,122209,122210,122211,122212,122213,122214,122215,122216,122217,123242,123243,123244,124917,124918,124919,124920,124921,124922,125551,125552,125553,125554,125555,125556,125557,125558,125559,125560,125561,125562,125563,125564,125565,125566,125693,126137,126327,126652,126723,127587,127588,127589,127590,127591,127592,127593,128254,128255,128268,128269,128270,128271,128272,128276,128306,128307,128347,128348,128349,128350,128351,128352,128353,128354,128355,128356,128357,128362,128384,128452,128467,128468,128469,128471,128474,128475,128476,128477,128478,128479,128480,128481,128763,128764,128765,129105,129106,129107,129108,129109,129110,129112,129113,129114,129116,129131,129132,129135,129136,129137,129138,129139,129141,129142,129143,129144,129262,129279,129280,129286,129287,129288,129289,129290,129291,129450,129451,129452,129453,129454,129455,129456,129457,129458,129459,129460,129463,129464,129465,129466,129467,129468,130916,131624,131625,131626,131627,131628,132573,132574,132575,132576,133265,133266,133267,133268,133269,133270,133271,133272,133273,133274,134895,134896,134897,134898,134899,134900,134902,134903,135018,135019,135020,135021,135022,135023,135024,135051,135052,135053,135054,135055,135056,135057,135058,135059,135060,135061,135062,135063,135064,135065,135066,135067,135068,135069,135094,135785,140464,140749,140750,140751,140752,140753,140754,140755,140756,140757,140758,140759,140760,140761,140762,140763,140764,140765,140898,143854,143855,143856,143857,143858,144246,144247,144248,144249,144250,144251,144252,144253,144498,144499,149099,149100,149101,149102,149135,149136,149868,149869,149870,149871,149872,149873,149874,149875,149876,149877,149878,149879,149880,149881,149882,149883,150090,150091,150092,150589,150590,150591,150592,150593,150594,150595,150596,150597,150598,150605,150606,150607,150608,150609,150610,150611,150612,150613,150614,150631,150632,150633,150634,150635,150636,150637,150638,150639,150640,150646,150647,150648,150649,150650,150651,150652,150655,150656,150658,150659,150660,150661,150662,150663,150664,150665,150666,150667,150668,150669,150670,150671,150672,150673,150674,150675,150676,150677,150678,150679,150680,150681,150682,150683,150684,150685,150686,150687,150696,150697,150698,150699,150700,150701,150702,150703,150704,150705,150710,150711,150934,150935,151451,151452,151453,151454,151455,151476,151477,151478,151479,151480,151481,151482,151483,151484,151789,151790,151791,151792,151793,151794,151795,151796,151797,151804,151805,151806,151807,151808,151809,151810,151811,151812,151861,151862,151863,151864,151865,151866,151867,151868,151869,151870,151871,151872,151873,151874,151875,151876,151877,151878,151879,152015,152016,152017,152018,152019,152020,152021,152022,152023,152024,152025,152026,152027,152028,152029,152030,152031,152032,152033,152034,152035,152036,152037,152038,152039,152040,152041,152042,152043,152044,152045,152046,152047,152048,152049,152050,152051,152052,152053,152054,152055,152056,152089,152090,152091,154821,155874,155875,155876,155877,155878,155879,156436,156437,156438,156439,156440,156483,156484,156485,156486,156983,157062,157063,157072,157073,157074,157075,157076,157077,157078,157079,157080,157081,157082,157083,157648,157649,157650,157651,157652,163418,164797,164798,164799,164800,164801,164802,164803,164804,164805,164806,164807,164808,164809,164869,164958,164959,164960,165076,165077,165078,165079,165080,165081,166136,166137,166138,166139,166140,166141,166142,166143,166144,166973,167083,167084,167085,167086,167087,167428,168800,168801,168802,168803,168804,168805,168806,168807,168808,172012,172013,172014,172015,172016,172017,172018,172019,172020,172021,172871,172872,172873,172877,172878,172879,173277,173278,173279,173280,173281,173282,173283,173284,173797,173798,173799,173800,173801,173835,173836,173837,173838,174013,174014,174015,174016,174017,174018,174019,174020,174021,174022,174023,174024,174025,174026,174027,174028,174029,174030,174031,174032,174033,174034,174035,174036,174037,174038,174039,174040,174041,174042,174043,174044,174045,174046,175650,175651,175652,175653,175654,175655,175656,175657,175658,175659,175660,175661,175662,175663,175664,175665,175666,175667,175668,175669,175670,175671,175672,175673,175674,175675,175676,175677,175678,175679,175680,175681,175820,175821,175822,175823,175824,175825,175826,175827,175828,175834,175842,177631,180897,180898,180899,180900,180901,180902,180903,180904,180905,180908,180909,180910,180911,180912,180913,180914,180969,180970,180971,180972,180973,180974,180975,180976,180977,180978,180979,180980,180981,180982,180983,180984,180985,180986,180987,180988,180989,180990,180991,180992,180993,180994,180995,180996,180997,180998,180999,181000,181001,181002,181003,181004,181005,181006,181007,181008,181009,181010,181011,181012,181013,181014,181015,181016,181017,181018,181019,181020,181021,181022,181023,181024,181507,181892,181893,181894,181895,181896,182986,183051,183071,188159,188160,188161,188162,188163,188164,188165,188166,188167,188168,188891,188892,188893,189478,190148,190180,190181,190182,191422,191423,191424,191463,191464,191465,191466,191467,191468,191469,191470,191471,191472,191484,191487,191488,191489,191490,191491,191492,192679,192680,192681,193169,193971,193972,193973,193974,195272,195273,195274,195275,195276,195277,195278,195279,195280,195281,199204,199205,199416,199417,199418,199419,199420,199421,199422,199423,199424,199425,199426,199427,199428,199429,199430,199431,199432,199433,199434,199435,199436,199437,199438,199439,199440,199441,199442,199443,199444,199445,199446,199447,199514,199515,199516,199517,199518,199519,199520,199521,199522,199523,199524,199525,199526,199527,199528,199529,199530,199531,199532,199533,199543,199544,199545,199546,199547,199548,199549,199550,199551,199552,199553,199554,199555,199556,199557,199558,199559,199560,199561,199562,199563,199564,199565,199570,199571,199572,199573,199574,199575,199576,199577,199578,199579,199580,199581,199582,199583,199584,199585,199586,199587,199588,199589,199590,199591,199722,199723,199724,199963,199964,200454,200455,200456,200457,200458,200459,200460,201254,201255,201256,201257,201258,201259,201260,201855,201987,201992,201993,201994,201995,201996,201997,201998,201999,202000,202013,202014,204031,204032,204033,204034,204035,204837,204838,205288,205289,205290,205291,205292,205293,205294,205295,205928,205929,205930,205931,205932,205933,205934,205935,205936,205937,205938,205939,205940,205953,205954,205955,205956,205957,205958,205959,205960,205961,205962,205963,205964,205965,205966,205967,205968,205969,205970,205971,205972,205973,205974,205975,205976,205977,205978,206249,206250,206251,206252,206253,206254,206255,206256,206257,206258,206259,206260,206261,206262,206263,206264,206265,206266,206267,206268,206269,206270,206271,206272,206273,206274,206275,206276,206277,206278,206279,206280,206281,206282,206283,206284,206285,206286,206287,206288,206316,206317,206318,206319,206320,206321,206322,206779,206780,206781,206782,206783,206784,206785,206786,206787,206788,206789,206790,206791,206792,206793,206794,206795,206796,206797,206798,206799,206800,206801,206802,206803,206804,206805,206806,206807,206808,206809,206810,206811,206812,206813,206814,206815,206816,206817,206818,206819,206820,206821,206822,206823,206824,206825,206826,206827,206828,206829,206830,206831,206832,206833,206834,206835,206836,206837,206838,206839,206840,206841,206842,206843,206844,206845,206846,206847,206848,206849,206850,206851,206852,206853,206854,206855,206856,206857,206858,206859,206860,206861,206862,206863,206864,206865,206866,206867,206868,206869,206870,206871,206872,206873,206874,206875,206876,206877,206878,206879,206880,206881,206882,206883,206884,206885,206886,206887,206888,206889,206890,206891,206892,206893,206894,206895,206896,206897,206898,206899,206900,206901,206902,206903,206904,206905,206906,206907,206908,206909,206910,206911,206912,206913,206914,206915,206916,206917,206918,206919,206920,206921,206922,206923,206924,206925,206926,206927,206928,206929,206930,206931,206932,206933,206934,206935,206936,206937,206938,206939,206940,206941,206942,206943,206944,206945,206946,206947,206948,206949,206950,206951,206952,206953,206954,206955,206956,206957,206958,206959,206960,206961,206962,206963,206964,206965,206966,206967,206968,206969,206970,206971,206972,206973,206974,206975,206976,206977,206978,206979,206980,206981,206982,206983,206984,206985,206986,206987,206988,206989,206990,206991,206992,206993,206994,206995,206996,206997,206998,206999,207000,207001,207002,207003,207004,207005,207006,207007,207008,207009,207010,207011,207012,207013,207014,207015,207016,207017,207018,207019,207020,207021,207022,207023,207024,207025,207026,207027,207028,207029,207030,207031,207032,207033,207034,207035,207036,207037,207038,207039,207040,207041,207042,207043,207044,207045,207046,207047,207048,207049,207050,207051,207052,207053,207054,207055,207056,207057,207058,207059,207060,207061,207062,207063,207064,207065,207066,207067,207068,207069,207070,207071,207072,207073,207074,207075,207076,207077,207078,207079,207080,207081,207082,207083,207084,207085,207086,207087,207088,207089,207090,207091,207092,207093,207094,207095,207096,207097,207098,207099,207100,207101,207102,207103,207104,207105,207106,207107,207108,207109,207110,207111,207112,207113,207114,207115,207116,207117,207136,207137,207910,208731,208732,208754,208860,208861,208862,208863,208864,208865,208866,208867,208868,208869,208870,208871,208872,211100,211285,211286,211287,211288,211289,211375,211376,211377,211378,211379,211380,211381,212680,214038,216555,216556,216557,216558,216559,216560,216561,217958,217959,217960,217961,217962,217963,217964,217965,217966,217967,217968,217969,217970,217971,217972,217973,217974,217975,217976,217977,217978,217979,217980,217981,217982,217983,217984,217985,218098,218099,218100,218101,218102,218103,218104,218105,218106,218107,218108,218109,218110,218111,218112,218113,218114,218115,218116,218117,218118,218119,219290,219291,219292,219293,219294,219295,219296,219484,219485,219487,219489,219490,219491,219492,219544,219545,219546,219547,219548,219549,219550,219629,219630,219825,221601,221602,221603,221604,221605,221606,221607,221608,221609,221610,221611,221612,221617,221618,221619,221620,221621,221622,221623,221624,221625,221626,221627,221628,221629,221630,221631,221632,221633,221634,221635,222707,222977,222980,222982,222984,223005,223034,223035,223043,223128,223129,223130,223131,223157,223158,223159,223160,223162,223163,223164,223165,223166,223763,225577,227523,227525,227526,227529,227530,227531,227533,227595,227603,227606,227858,229157,229158,229159,229160,229161,229162,229163,229164,229206,229782,229783,229784,229785,229799,229809,229810,229881,229894,232027,232029,232418,232420,232452,232455,232456,232457,232458,232459,234093,234094,234795,234796,235413,235414,235415,235416,235417,235418,235419,235420,235421,235422,235441,235442,235443,235444,235445,235446,235561,235562,235563,235564,235565,235566,235567,235568,235569,235570,235571,235572,235573,235574,235575,235576,235577,235578,235579,236128,236129,236130,236131,236132,236133,236134,236135,236136,236137,236138,236139,236140,236141,236142,236143,236144,236145,236146,236147,236148,236149,236150,236151,236152,236153,236154,236155,236156,236157,236158,236159,236160,236161,236714,236715,236723,236724,236725,237043,237044,237045,237046,237047,237048,237049,237050,237051,237052,237053,237235,237510,237979,237980,237981,237982,237985,237986,237987,237989,237990,237991,237992,237993,237994,237995,238019,238020,238021,238027,238028,238029,238030,238031,238033,238618,238619,238620,238621,238622,238623,239178,239179,239180,239181,239182,239183,239184,239185,239186,239187,239188,239189,239190,239191,239192,239193,239194,239195,239196,239197,239198,239199,239200,239201,239202,239203,239204,239205,239206,239207,239208,239209,239210,239211,239212,239213,239214,239215,239216,239217,239218,239219,239220,239221,239222,239223,239224,239225,239226,239227,239228,239229,239230,239231,239232,239233,239234,239235,239236,239237,239238,239239,239240,239241</p>
  6. 2026-05-14 09:33:49, 由 刘超 编辑。
    修改了 上线时间，旧值为 "0000-00-00 00:00:00"，新值为 "2026-05-12 09:30"。
    修改了 上线时效，旧值为 "-1"，新值为 "19.07"。
  7. 2026-05-14 09:33:52, 由 刘超 关闭。
    修改了 Bug状态 ，旧值为 "resolved"，新值为 "closed"。
    修改了 指派给 ，旧值为 "liuchao"，新值为 "closed"。
    修改了 由谁关闭，旧值为 ""，新值为 "liuchao"。
    修改了 关闭日期，旧值为 ""，新值为 "2026-05-14 09:33:52"。
  8. 2026-07-06 18:19:23, 由 刘超 编辑。
    修改了 测试责任人，旧值为 "yuanhuibin"，新值为 "liuchao"。
所属项目 技术中心-需求池
所属模块 供应链   仓储物流   备库订单
所属计划
所属迭代
Bug类型
严重程度 一般
优先级 P2
Bug状态 已关闭
业务部门 供应链管理中心
影响功能
开发责任人 鞠智明
测试责任人 刘超
解决时效 20.77
激活次数 0
激活日期
是否确认 是
当前指派 Closed 于 2026-07-06 18:19:23
截止日期 0000-00-00
上线时间 2026-05-12 09:30:00
上线时效 19.07
操作系统
浏览器
关键词
抄送给
所属迭代
相关需求
相关任务
由谁创建 袁慧斌 于 2026-05-11 14:26:06
影响环境 生产环境-业务反馈
由谁解决 鞠智明 于 2026-05-12 11:12:05
解决版本 主干
解决方案 性能问题
由谁关闭 刘超 于 2026-05-14 09:33:52
最后修改 刘超 于 2026-07-06 18:19:23
相关Bug