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

[步骤]

[14:10:54]  -------------------------------------------------------------
CODE:N1410542
Error:11_-2_0_-2146232060
SQL:select oi.OrderSourceID,oi.AddTime,whp.FNSKU from RB_OrderInfo (nolock) oi 
                         left join RB_OrderInfo_BeikuExpand (nolock) be on oi.CustomerID = be.CustomerID  and oi.OrderCode = be.OrderCode
                         left join RB_OrderList (nolock) ol on oi.CustomerID = ol.CustomerID  and oi.OrderCode = ol.OrderCode
                         left join RB_WareHouse_Product (nolock) whp on oi.CustomerID = whp.CustomerID and ol.SellerSKU=whp.OrderSourceSKU and oi.OrderSourceID=whp.OrderSourceID 
                         where oi.CustomerID = @CustomerID 
                               and oi.AddTime >= DATEADD(YY, -2, GETDATE())
                               and oi.IsStockOrder=@IsStockOrder
                               and oi.OrderStatus<>2 
                               and oi.OrderSourceID in (select item from CharSplitForIn(@OrderSourceIDs,','))
                               and whp.FNSKU in (select item from CharSplitForIn(@SellerSKUs,','))
                               and  be.OrderBuildType in (select item from CharSplitForIn(@OrderBuildTypeList,',')) 
PARAMS:@CustomerID = 1 ,@IsStockOrder = 1 ,@OrderSourceIDs = 10041,6082,14711,15206,6147,16867,13844,15090,6869,13596,9956,7391,12126,8522,14509,5108,20770,6069,6037,13834,15405,6292,13868,9856,5272,6657,8555,12811,8150,8562,6450,8856,5123,8243,5504,5534,6112,13525,9771,9504,13922,9034,8493,9009,9776,12424,8257,16522,16203,12490,11530,22453,15486,5383,6660,9437,11304,7842,8622,13192,5948,11837,6138,18209,6071,5247,5766,6140,6148,18249,6514,5105,16224,9269,5075,7392,6054,6915,14537,6049,5614,15350,10316,16342,5277,7759,6647,8131,14757,15757,13290,6701,5014,18585,13338,16693,6622,5166,20232,6070,6595,8674,11653,13581,9768,14473,6908,7703,5267,9834,15247,5545,5288,11528,10054,6101,15334,15317,7367,5373,5326,10234,9167,9285,6949,6030,6600,6776,17376,6891,8252,13572,5662,5701,6153,9410,15019,18540,5164,16902,5603,10057,9432,5343,6805,8012,17870,6618,6086,12428,10325,16541,6084,6641,6448,15631,16692,8016,6161,9215,6592,6149,10198,10023,14543,6617,5249,6899,6446,7948,15697,5305,6603,5739,14957,9152,5535,5702,17898,18263,5269,6550,9767,5935,14713,13839,17456,9128,13656,14964,15342,5952,9862,7527,8561,8379,5704,5741,6105,5325,6110,15592,15436,5558,9008,15621,14675,15542,6916,9431,13627,8065,5763,16343,5595,5005,8382,9818,10812,6942,22429,5018,14858,11215,16370,6549,6036,10005,5276,9406,20150,11881,10275,8605,11684,16861,13584,17231,17541,7908,6585,16815,6608,7371,5007,11503,9270,13339,13199,6044,9446,14568,12264,5252,7387,8010,6694,5505,7706,5547,14852,6623,15261,10319,19773,6605,15210,15577,13603,15343,9526,11846,9849,8013,16242,8077,9848,13587,10379,15939,11494,9003,15074,14804,15335,5765,13898,7760,10326,10199,9291,13330,15915,11531,5132,19218,10249,16040,6690,5756,11964,14880,16076,5573,10937,7389,10053,7913,6598,5640,15778,10747,15194,12258,10055,11977,8471,15129,7363,8095,13874,13599,5059,11685,5327,15309,15764,6066,5713,19685,16331,9816,5758,10042,13342,11959,19531,17144,5585,17007,6572,6918,16054,6953,6442,10751,15195,16082,13527,14291,12797,16916,15259,16907,5347,7383,5405,5642,6459,6092,10315,15310,6696,13296,7198,6928,13528,14762,18364,9769,14718,14576,19858,13658,10276,17818,9451,6306,13875,14822,7996,5750,6670,7705,14362,19538,15992,6284,13298,5533,15712,9061,11692,15223,6096,6103,9055,8564,8347,20775,5364,13101,16383,15979,14427,7382,11839,11891,5517,6510,6043,7751,16170,5748,7715,14580,11301,7924,7197,11850,8858,9508,14896,16225,6305,9294,10374,14832,13594,14480,10324,14820,6671,13593,9949,5268,8554,8014,6669,5266,7923,8518,5712,6596,5042,5250,7904,8476,11245,5740,14305,8559,6932,16743,6397,6059,8519,8523,13287,12953,16169,15070,7906,9107,12700,13602,14629,8072,9289,17035,5776,5669,9031,9503,6927,11527,6048,14355,11883,6917,17532,9035,8345,9154,7936,7921,9441,10137,8696,7388,7166,14530,5802,6142,9033,21312,14936,8259,14315,14072,5605,6935,14510,14824,16944,8472,6883,18576,16615,10738,5516,16739,9151,5174,14860,14405,6512,20716,10753,7360,7375,10736,8011,9239,6406,6515,11610,13478,13564,15148,16168,15192,17440,8078,9284,15251,16706,6929,17420,15478,12493,9238,14881,17650,5604,6870,6593,6065,6513,5575,10378,6056,6033,17679,6610,16187,18219,15183,9257,11845,12738,5355,5745,9299,20717,16646,15018,10943,6303,6912,6921,17773,13469,6950,6884,12507,14876,5251,5050,10059,10007,12935,13849,5924,5071,7167,19165,15136,11375,5202,14523,6645,9522,18191,20144,12057,19351,6281,7755,15865,6925,15075,14406,12737,10311,9857,8123,13840,9091,6609,10029,6146,5667,5384,6399,8094,9770,9626,8092,6087,9036,14602,14856,17534,5576,16488,5514,14556,14582,6948,13341,5420,5934,8073,5707,16487,14900,5774,9436,13585,19322,6025,15264,15942,12106,16029,7719,9004,18200,5650,9806,9361,6040,16710,10313,7163,6108,14342,11296,20632,7887,5668,6892,13808,15540,11504 ,@SellerSKUs = X004IK7G7T,X0028XJLFN,X0038JUIYJ,X001YBAVV5,X003B5N9I7,X001VY3R57,X0039YNVQZ,X003RBSYO9,X0015N3Q5P,X004KQVXSJ,X0018A3BAF,X0020SZ9QV,X002XGQ9W3,X003WVLKAJ,X003C2CYHL,X002L7NY13,X00451XGGL,X0015GZ72H,X001773BYP,B08688KF82,X001VT1C2R,X002ID075V,X00454RFFL,X002V8106X,B0151CPT4S,X001UFQA4H,X001DJN4FD,X0032YJTUT,B082CKB5L3,X001K5VL69,X002B6UAA7,B07M6KSHF1,B01KLXW61Q,X002TBSQN7,X003B31Y45,X002NHBRI3,X000URYR3R,X0033UV6AD,X002VIAMNZ,X001AZT48L,X003XMD0F5,X003FHJO35,B07ZQK3M9W,X003B9IOFB,X002RZDN5B,X003K1TKAX,X003DT5SWB,B0BVJL5H2B,X004IIUEWZ,X001ILFQ3T,X001INL20X,X004ARQU1X,X003G9163X,X001VY3QYJ,X003VSVSRD,X0013DGJW9,X001862KL5,X0030FGU07,X0010F7ZHD,X001GKC6BR,X001YGAMIR,X001O0YYG7,X002X9RUJL,X001XLAK8X,X0020D1WO1,X001696HYZ,X001CY8PPL,X001SGCRB1,B01J7K5TE0,X0010OXSRF,B01HES3UO8,X003YH2B31,X00126AH93,X001DHL2Q1,X003EYGL1R,X001J0PL5R,X003DZZCIZ,X002ERECWP,X0014C2X0L,X0019JTUHN,X003ZX1UEF,X0015SNRIB,X001OV144B,X003E2CS1L,X0040ST6PJ,X003E90RFD,X003V2KXN9,X003KCUVYV,X000Z32PPX,X002FFF59F,X001OAWG7D,X0020Y69U5,X001RYRGVR,X0022ZLZMB,X002CIVDNR,X00172TF9F,X002K8HYCD,X003U0K5RV,X0039A4TSN,X00424U3V7,B07V4C1J8G,X000FGL565,X0040SXB2N,X001FOU9NV,X000UV9IWD,X002JTNTT5,X001DSKP0L,X004I33KSZ,X003YNP8CL,X003DIRB6X,X001ME6IYN,X002B3K2HL,X001PGF5E5,B075S1CS4X,X003K6HEMT,X001O60I11,X00164CJX1,B086MZXZ7R,B089GH8LF1,X002IE8UCH,X0039R5K61,X003YNQA9V,B083FBDPGT,X000NVOGSB,X0022G7SID,X002O8Z91H,X0018EJJRP,X0019AXK2D,X0017WQDJP,X002J01UPJ,X0016983X3,X002N7KRI9,X0045KLWDL,X002C7WR4R,X00111AOAV,X003RSBO03,X000REE5LH,B077VW86W9,B07GB2XPX7,X001GSK4RR,X002LRXQUH,X0031GBTGP,X003E76A0L,X001PPEQB1,X004HT2IHJ,X000KCBENN,X003XI8XMT,X00226DOAT,X002UF5F0J,X001FS0FOZ,X0018DFHD1,X000L14I27,X0010KJH1F,X001TO7MQJ,X0045GXX4B,X00423D1PN,X0016UKISP,X001HYN0TJ,X001L6R4KJ,X001P0IRBV,X001XCQUI3,X000TM42AB,X001BSTUQX,X003JH1X0D,X001SICL9J,X004I8AU8X,X0019BPDW7,B07K2T7V21,X001A9S6JF,X001GASF5X,X0014QBM8B,X0032UAHO5,X002TJA9ZH,X0047TE4DF,X001FXLQ1B,X0015JOQ2J,X002MAOFM1,X002E5147X,X003D8Q4AH,X003GI0MFR,B01JR5LF84,X000RYZ2XR,X0029UG80B,B077R3S1HR,X001OFQD95,X002P6BJ03,X001AWUK19,X001F6I1OV,X002MHQYOV,X002RRAPX7,X001X9UE47,X003ZEVBON,X0020TA4BF,X004AYJXS3,X001L6LTPN,X002V9WM2D,X000XQJIX9,X0034XF6R3,X003GUI0YP,B07W417RCP,X004N99ADX,X003ZFK1XT,X002UV4HB1,X001NP8EVB,X004ELMWBH,X002602S5F,X000TPXWCH,X001BX9B03,B07DGS1SZX,B083HKLT8Q,X0018FCROL,X000RYXXZB,X002BUQGPB,X00164T5ML,X0013TG42B,X004EU2BR3,X004K2K04V,X001MTKUY7,X000X3T11B,X002JDLS5N,X001S1NY1P,B07BT4YLHT,X0028TZRHN,X001SXJDS1,X003FVYGCF,X001OBS5N1,X001Q7C043,B07VT9YVR3,X003YO2DI7,X0011GRKWV,B07GR1KN7L,X001X1TJ17,X003UIYEGB,X000YYK807,X001L6AZSF,X000QPJZ29,X001BLKY8N,X0019U6MYL,X002T8L9C5,X003HFGMXF,X0047FODZD,X002SOLN71,X003DLBLQV,X000TWUW69,X001CZ10OP,X00485BVV1,X000UZSSGL,X0018VLHT1,X002NPPH3V,X002MHTYGV,X001A8Q37X,X002P0971R,X001PPWT09,X002P2YR15,X004BUQBHH,X001H0E8GH,X0043EMNJ1,X002JCGJHV,X001QT8RIJ,X004F83Y75,X002OWKDLT,X003RIUGRF,X0038IKFQL,X001VY6BEV,X003YI4P0H,X000YZJFSH,X002YBWVXX,X001B0QJ7T,X001X4Y8UX,X002F08AH9,B088HF72W3,X001KYWQM1,X001JDA8Y3,X001U1ASBR,X003CQ64JB,X001TNS46F,X003CL2MXN,X002I543DV,X000VZFZMZ,X001GUANGH,X0045A28P7,X0038TZUKB,X003TS1E6Z,X000QZCITV,X000JXVOV5,X002FJO09R,X003IJGQOF,X0046WYNSJ,X000UAYJRD,B00LO4ROYQ,X001TKYSFT,B00OJ0FZFC,X002WWL7GB,X00168R85N,X000SI5DPJ,B077JMWHLW,X003CTHKGT,X003TAKOKF,B01DXSULGS,X0045W2BOX,B072QZKMKR,X002OQAUJZ,X001ZUL4Q1,X002PM10F1,X004BBPHNF,X003CCW8W7,X003C7BX4V,X001X4IT2V,X003Y88LMF,X001APTFRB,B081DGP5FN,X001G45HJL,X0031XP98H,X001SHHFE1,X0048FUR5H,X001SMLGTV,X004ILJG0N,X002IEJEQD,X0039L7LNR,X003A9KTZF,X001GKMUR7,X0025F17YJ,X001F6GTVP,X0016H5TOB,X001L77FK7,X0040ENVD1,X0045QCV7V,X003TGSTKV,X002TEDV8T,X0025VGOKZ,X00416L8KL,X00236S223,B01C5LM3Q0,X004D3BTE7,X001O8Y2E5,X002BKQ9GH,X001IVUDT1,X002L4070R,X004HHUL75,X002P0H9PN,X001DXOOI5,X001GMNQI7,X001QOZEZN,X004EDLIOH,X001NG5ESV,X001DQ7MEF,X0028YVF15,B015ZBP95E,X00467T5HX,X002QNSI3B,X003XV3WWR,X000VC12AH,X002L6SIDN,X003FKIGZ9,X001LEGXDP,X001R2DHO9,X002TBVFUD,X002QKXS1B,X002J5XDQD,X002OIBBE1,B01HZH2R06,X000UWIKLR,X0045PDQUD,X001N287MF,X003RY2O7T,X0015SXVJB,X00220C83T,X003PLQ1R3,X001T5XB63,X002S31MAZ,X004G6JCOP,X003U3SHDR,X001WBFOBJ,X001BYRDDH,X0031W7S2X,X002OI5ZED,X003Y3Z28B,B08TMYKPW3,X001BX2QNR,X001VGVAZ9,X002IDHX85,X001O0P887,X003817UQV,X0041I0QTD,X0024VQ5H1,X0037W641X,X001PH6DX1,X001FYJEN7,X0041VQ0VN,X001NRSS29,X003FU9WWP,X001KVWCGB,X00189SV8X,X004DFD3O9,B07Y88Z6PL,X001ZBM4D5,X000P7H3WT,X003YHAGKB,X0015NS1KP,X003R80BVB,X001BSOQL7,X003UDDPN9,X001CKS79B,B08418WYYG,X002VSLS8N,X003G67O69,X003YNIWWT,X001W5N8LN,X000UZISHZ,X003XX82MZ,X002LP3QB3,X001683CML,X0046C2IMR,X0018N75EP,X001KNGYJZ,X00484ZWE9,X003WG2D3H,X002IQDAHZ,X002DLZO29,X001DXOJ35,X001QPP3W1,X004JG3EHX,X00396LSLN,X0044XWFIZ,X0041VYCWH,X0039RBGR3,X001CZ5ZNH,X0041D0KRB,X003RR7NHH,X001VY78S9,X000L7BV53,X0019FAS49,X0042GBCLZ,X000V6DF3P,X001371015,X001OB4T0J,X001P95LF7,X0028PR7I9,X000V5HLBX,X00168GTIP,X002NR7KRF,X002IUTY5D,X001PTPGU7,B06XKYVGRK,B07CG2Y8S9,X001WCN9UV,X002IIXS89,X002U7Y6TX,X0024GMQFL,X00421HA9X,X003CAA9UR,X001TB4FWB,X003RSDWUX,X002Y4B7C1,X0029OPEGV,X003U6MQBD,X004IMTW1F,X0042F6IH9,X001CKCQRD,X001SOHM6F,X002PDX3ZF,X001YOX0KL,X003S75RBP,X001FG6KKF,X000RPT0O3,X000W44T1D,X00421KEMX,X003DU9BYB,X002KJFVRR,X001TFGG3B,X00169XKH7,X0028AMFXB,X002F8Z77R,X0013NPZP1,X00388EXTB,X0045E3KJB,X001NMQLZP,X001WPYG5F,X000Z6MCCB,X001TDLKIB,X001QIBOVZ,X001HGFGZN,X001O7AS85,X0026WWXMT,X0018D2XBF,X002A2WTV5,X003AA0CYR,X001OD07CB,X004JHX3I7,B01MED463H,X0029KJU4H,X000Z3QAK9,X002W3SM63,X004GU6NLL,X001FP1IFX,X001ME7UJP,X0018MQT5R,X001Z58K0T,B06ZZXPWBF,X002BNU7YJ,X0033VY9PL,X001NRG6SH,X00453H2RD,X001KRF1GX,X000SC8SFF,X0016NZN8R,X003JYO9YD,X002W5ITW3,X000XGSZV5,X003FVXFRH,X003VE3ZKZ,X003AH9XT5,X0030MIQ0H,X004C839OL,B07PNBYLVT,X0018RGZAV,X003RSHBFP,X0017BII53,X002JMF41X,X002AIDRBF,X0016CTG9Z,X002IQBPAJ,X0017UQ167,X003Z1VKH9,B00V4PZ226,X003IK0U3H,X002KUUS4H,X0028T03IL,X002E71XOP,X0038VPRX9,X00436VMOB,X0030C4SIB,X001TUZ4LB,X0031W1H3J,X001VDUHN3,X001QS50DZ,X0048P4LGN,X0012YWXQZ,X002IITDUB,X002XLOB4L,X003Y63BBN,X00182BI3P,X002S1GM7P,X003RXMJJN,X003HFOTOJ,X000U3SFZ7,X0018J0SAF,X000MGTEL9,X003W9MSG1,X0017K9EXT,X003QMYE61,X0043OZAIH,X003TWX6AX,X003TO4NPX,B084P5FGJZ,X002SU0P9R,X001KYZBPR,X002RHNP3T,X004JWOV2J,X003CSRZDX,X00161W9QN,X002XABK37,X002JCWM5T,X003QOVY85,X002PIVFNH,B073VNYLXP,X0017LKGHV,X001MGEJLP,B01JOWK752,X00249N3OL,X002NEF86D,X0040YBW9L,B073VF23D8,X00100DMVL,X003PUUU0D,X00284B8L7,X003UMDZV7,X003JKL99F,X003FL8L99,X000RJCPB9,X0019CIUT9,X0013G1GKJ,B00U0TTN2M,B01J1HGIHQ,X002WZFTUX,B011B8KVZ8,X001EBMAH1,B07J62VJ7L,X002XKP71X,X001IN21QR,X0042GHZ3T,X003Z40HKH,X002L4BUIP,X002ODCFY1,X001NXGZ4V,X0047UNB8D,X003WFJB3D,X002CL7MCP,X001Y8LX45,X001UKM7OT,X001E1GQWV,X0020OCE5J,B07G264MTH,X002MGKR63,B0814LD984,X003H2LJCR,X002J544V1,X002IVY8UN,X0030DWGFR,X003WDO85L,X003S2PN5Z,X002MHMYL3,X001A6PH13,X001K9948R,X001MXZ6X3,X0034F4YG5,X003ACU6C3,X0023UI5HX,X0013ZX5JH,X001KTEVG7,X0041LKKZF,X00129JDHR,X000RTW1SL,X001HM9ZC7,X000SHLWDF,X00183ULJB,X002M7JZ29,X004D2HT33,X001NHNBAD,X0041S347T,X001FJ76DR,X002Y59FC9,X0017KJFKB,X0014C8J8V,X001MBHT5D,X0037BXJ49,X001OGSEZZ,X001BE0E9T,X003E2RK23,X003JZ2FD9,X0029DNX8Z,X0016XICHV,X001TRL8N7,X002WGCVWL,X002ORYSAB,X0018CE5TT,X002ZHKLRT,B0811R9MSP,X001A5R073,X0034QFUCV,X001NE6E41,X003CFTYVH,B08T7H7L1N,X00459FLI9,X003WM83V7,B01MF5M1R7,X001FS0QVH,X001KC1H8J,X003IS44DV,X00412X8P3,X001WK90PJ,X0013HEA35,X002ZX96F1,X00305T01N,X002552LH1,X00462JFO1,X001M2Z3EB,X002PPI4ED,X001P0QA3N,X001QNTY55,X000R5TL1Z,X000TT98HL,X0034T4S0N,X0013Y802F,X003AG4HY7,X001LDCHFJ,X004KUVAFB,X001EC0ZDX,X004BXBEMB,X001YEKMPR,X002VNV405,X001U2VTXR,X001X4TO1V,X001M6SSDZ,X001TODNLP,X003RPQ5SH,X003R2K6CL,X0017PSXJP,X0027MQZJZ,X0014S5I07,X00244ZRB3,X001AVXE31,X000UBVDFD,X002264HMD,X001MFW337,X003AS7VZH,X00183OWK5,X004LTZBZL,X001JT817X,X002CITYHJ,X001H381K3,X004MQHBAB,X002TTCSWJ,X001LHO22L,X001BE0VP1,X001419QE3,X00168HPL5,B083GRZT8G,X003LM11CL,X002O92NFB,B083FLCRDM,X002TSW8S9,X0031OZV75,X003APGKV1,X004GQ1Q21,X0011Y8HWF,X000V2AWOJ,B08HP5K665,X003Y5OTIX,X00445MLGT,X001VUE9CV,B06WP5CVN4,X0038YQE2J,X001M7CIBH,X002ICZVHV,X002A0FZWR,X0027NEWYT,X001XEUU7N,X003FW39NV,X0047FR6DT,X0043NFFNN,B00UL3ENW2,X0039DZT9X,X002L4YLY5,X001GISLOF,X001WRPI8R,X001M92QKV,X003ZTMQ51,X00149737R,X001QKJJPD,X00254C5EV,X001TQHXJN,X001I2FUON,X0045FCXV1,X003FL8BHL,X003TQSXUH,X0018BY8IN,X0013Y8UI9,X001KSV3FF,X0037UESJ5,X001W570PN,X0040EMGF5,X002AX1J47,X000REKND9,X00144V5ET,X000V4XADR,X001GP6V63,X001FOJMRP,X000SSF0EN,X000KKCQCN,B01KFPFLBW,X00201KH1R,X001UUI301,X0018GYV8Z,X001HPLR2F,X001F0MIXT,X001CGZOV7,X002UJX8B3,X004G2PB0D,X0046C30U1,X002R9567Z,X003KBF2T1,X003YEP2VH,X001OBN9B9,X001FJ5R51,X001DFHKTX,X001ILDY6Z,X002R8UA6X,X0016SCB41,X001C5VLAB,X0030NSWM3,X003HM3WRR,X00168K7Q5,X000OI30AD,X000WOARPF,X001NRR7ML,X001C19DCP,X004420Q4B,X001P5T4VD,X0035PVTOT,X001PPBW5J,X0041XPF3Z,X00475MSO1,B08T9H1THL,B089QZ9V6P,X0032EU4Q7,X003V4XUVJ,X0018GC8PD,X003EK2HM3,X003Z3MO63,X004I1Q9IP,X00194O9V5,X001TK3WUN,X0045683YL,X000VEOKO5,B077R1BB1S,X0018R1LWV,X001GJ0HPP,X003H0074F,X0040IHPXJ,B073ZBFLGL,X000YUPSBN,X003CJGCCH,X00168A1WZ,B07FZR2462,X002OKYRNL,X000W9LH0T,X002QT7PS9,X0032OP75P,X003DXUVGZ,X000RVXHCD,X001L1B17J,X003X6D40R,X0013FYWL7,X003Z490K5,X001F7IMYB,B08MCDW696,X0046PTQ0V,X001FMM319,X000MEBTFH,X004HWD4DN,X001111NB5,X0047038QD,X001TDKC5D,X0044CIHHT,B01IR5CMOQ,X001MOADQ7,X001XT1MY3,X0037Q9ML3,X001Y242FZ,B07QXKB3QQ,X003ST7OAP,X003GHUWZN,X0040EMHPT,X000R09G47,B0152W34BM,X002VO2FMP,X0016Y0JY9,X001GYFYIP,X001YAPKIZ,X002EO89TZ,X001LEU0JN,X001UASZAT,X003U8E92F,X0032U01KP,X001EM64U1,X001HABKIB,X0037R55K9,B07Y8JK29S,X003VE23IZ,X0016TIAX1,X0019V7SD9,X002PFYROT,X0017RARSD,X001LOWWTH,X002BGIIPV,X002YJ931X,X003TMB8WL,X003QZ1LR3,X0027ZTQY3,X0018HLTMD,X003KXLQ2L,X002DO0FZR,X001T93CC7,X004LE10DN,X001G9N5NB,X004MX3IVP,B082NMWQQC,X0014FMVE1,X0038JXUO9,X002U5A8U1,X003PYHJ35,X0026ESMPV,X0016AD6YD,X003XX09N5,X0020ZYH8P,X002JM8Y5B,X001ZZ4SEV,X003CJJQF7,X000QC820F,X00226JXBN,X003044CIF,X003Y629B1,X002OA8WPF,X001QBJS5N,X0031OZV7F,X0016A3AHV,X002DUBLEZ,X003FBH57N,X00440SX1B,X0046KPJHP,X0046AJO8Z,X0045U9B61,X003VC99GB,X000UWAOMP,X000RZ24VT,X00168NEMT,X003A3IKCZ,X003WZOPGL,X003CL94LL,X003XLVLVL,X0036SUMOD,X003XRSI61,X001MRP3PP,X000RXRDC1,B07VPYMSW2,B07MQ5LMS9,X0024QK9F5,X0038SMWPD,X003OYQD9R,X002RPPG0L,X000XMWN1R,X002AMRY79,X002RRJCK9,X0017MV92L,X001HIUSJ5,X0012VNMS1,X0047ES4IV,X001X00KJZ,X001YFCJTV,X00394KZIH,X000RKG2SP,X0018M3BDF,X002RNV8BJ,X0036SZ1TT,X003UXR8KP,X00445UAAD,X00193JIR1,X00154UUDX,X0014ELX87,X0017LVX55,X001NZTPYB,X0020C3TL1,X003Z9CRC3,X004386YSD,X00189SA4N,X000TT99R5,X001LKXWOR,X0019RN81J,X004MCE49B,X000XSF8TF,B072MLKQGL,X003XRF7ZL,X002IEZVUL,X001HNTFZN,X001SENFON,B0784XQH8S,X0040Y199T,X003FFRLD7,X001E3QNAV,X001AYVF57,X0025PKDUD,B075CM9RHL,X002PM4HBP,X001DYNT2B,X0018831PR,X001VV9DJ9,X002Z3IITL,X0020IXHH1,X002WXMFLB,X002MP8CHZ,X0018W82BV,X0035MXYZT,X003ED5669,X00477LYAN,X0018F6DL9,X001VYINHJ,B07W4TDL6P,X001JXFKT1,X0040Y7GBT,X001KY9WE3 ,@OrderBuildTypeList = 1,2 ,
MESSAGE:执行超时已过期。完成操作之前已超时或服务器未响应。 
TRACE:   在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   在 System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   在 System.Data.SqlClient.SqlDataReader.get_MetaData()
   在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   在 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   在 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   在 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable)
   在 RB.DAL.DBOperator.Query(String SQLString, SqlCommand cmd, Int32 Times, SqlParameter[] cmdParms, Boolean IsWriteDB)   在 RB.DAL.DBOperator.toCommonTipException(SqlException ex, String sql, SqlParameter[] cmdParms)
   在 RB.DAL.DBOperator.Query(String SQLString, SqlCommand cmd, Int32 Times, SqlParameter[] cmdParms, Boolean IsWriteDB)
   在 RB.DALExtendV2.RB_RemovalOrderCreateRecordExtendV2.GetOrderInfoByOrderSourceIDAndSku(Int32 customerId, List`1 OrderSourceIDs, List`1 Skus)
   在 Biz.Irobotbox.RemovalOrder.RemovalOrderUpdateOrderSourceService.Execute()
   在 ChinaDownLoadImage.Task.Task_RemovalOrder_UpdateOrderSource.Execute()
   在 RB.Utility.SystemTask.<doTask>b__43_0()
   在 System.Threading.Tasks.Task.Execute()
   在 System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   在 System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   在 System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot)
   在 System.Threading.Tasks.Task.ExecuteEntry(Boolean bPreventDoubleExecution)
   在 System.Threading.ThreadPoolWorkQueue.Dispatch()

-------------------------------------------------------------

[结果]

[期望]

建议把查询时间延长到10分钟 超时