[步骤]
CODE:N154813173Error:11_-2_0_-2146232060
SQL:select a.OrderSourceID,a.OrderSourceSKU,a.TemplateID,
b.BrowsePathByID, b.RecommendedBrowseNodeName, a.VariantGroup,a.TranslateStatus,a.IsVariation,a.BrandAddTitle
from RB_AmazonUploadProduct_V2 a(nolock)
inner
join RB_AmazonUploadResult_V2 b(nolock)
on a.CustomerID = b.CustomerID
and a.QueueID = b.ID
where a.CustomerID =@CustomerID and a.AddTime > '2022-08-01'
and a.OrderSourceSKU in (SELECT item FROM Charsplitforin(@OrderSourceSKUs, ','))
PARAMS:@CustomerID = 1 ,@OrderSourceSKUs = C6N85413TK7L8K04758QBJ5NH,LUT54J0UVO13EB589SQNTS5,15938Q54Y3PI,U5K5O1W159543RT05,5954HRG13KLSYKSNBGZM,RU6Z5954K13D,1359548WN77RJ,5594M13Z55,138I5015YP9G,W13ATT0010551TQ0O,C1553014O2AW,5155023EXZ0W,J755DZ0182U7GWBS3L1300AAP,CDLJ02955LN13J,0355R1H7KE4Y1C2133G,UPZ03C130ODI492B55QAAAUG1,7GWIZ05A5035U13FWPKW2,7BW0415513AO5E04I7CU1LA,WGAS13JF04AI557MJUDWOX3,IQXKY55V0513RC7SC,P05Y5513TN,13U506N205G55VFR6,55D105352T4X,065504R13K,EVWQ068XTA255134C0TUFK6Z,F607NZ1553FLF,78607XHT55B13X,13NAAD074M55FBQ6RTD69,WO81073A4555IY5,55J1083VGJY,JKT5ONZ08D13F55GAAOTFRHI,8YWU07O55TJ5Q1083EU1XGKC,V4520913HHPVETJ553VC,H85XZ09T7KG2R605513U1X,08V41355VO1,096555RX139DCX,107XU013O55ZWK,621151053MMC,MAX55813092W6VZ60ZZJJL,0155103Y2B64O9NJ,8P8V71155713E42H,8IN5K12K130559P88,E13HR55125RGZA,2455P13OENU6RQC12Y90ZR,V83P1313559U4,79A7131553VZ4O7W4OE,9555TOA2H62MZ134013MZS,13KF10J814EVEJWGWPJN5543M,WQJ15A30F55T0TBWZY13OB4B,9LURZ1355K3136,13Z3L59ILV8YL313N55W4OP,YD13J13HO55DFO,Z8Y5513JJ15F7UZT3,I55GP1613HC2PEL514O,16Z137P55A3S0P7JQXD,CH553YU96VWG14SO13P98I1O,0S4551413MDU,R2GK5513EZ14PY8FNO76GCD5X,B5175PU136W9,7Q1173D55FG3,17355AI135H1SI,135175XWMB46Q,SA6YZ135581NS17Z2WP7WA,B551713CQLP,55XI1713FJ7C1,V07E8BB13T17N2B55H6P,13UK6C55968CS618OOMEE09,6553X2W1193EL356,Z191553CUKX77NDG,55X19AQ013F,5520CV13C8P,720OJZ13553ZSW,1521535RIOO,CB55G8Z3QYC1321MJTB2,21XH55130DGZ,ONG21RM55B513M,55222PU13HJI8H1,YMO35225I913S,9FBC21OS55130,GYENHD455SE23B8F3G1344,U23556F1J7SPA613O,XW23IGB55PY13F,MHB134F6Y23RZFEJSX755JOC,2O55S7U2413Q2W6WQ6EXJ0,24O6755WK1360,WY6E1524559N13F,HR24M4Z9DR7313DE0I55ME5J,4OW55K7124389IX,I339G7GT05513A0LS6252B6BT,M138D55NV3824JBXVF4XOD7,155253L9J8YV5PKZU7S9,2546A558139F53REPC,55U2513WCA,F4T4J5H256558BDQ0EUF13P,557S6SC25HZZGK50X13DYI,13276559BJT1JUZODL5BRC,4T1283RHQ55XFJOGAK,J9MMHIW55J7RQUL2813M0MB,X12835517H0,1382655HG6XD,Z55265113MW,S55T65JD27S46Y87R13ZV,M132V802655T67KV2J,C13055UMPJHTBEG113VHZC05,155313TQ49IE5,PJS70EGS55130306R3GN5Q,D4C130YAX31JY55FJQSWILBDV,3HT551331PWIA3Y,13U5593014GIYE1,61331ND9K55CKV2,25555325TMOE13Y,HLLI9551332MRF6EA,467GSD732OHH91553AQVJRDNK,85325FUGLB13Y,3C5720P3255XRYHPD13Y,EAP53351LM1343Z,OHF1333G9QU55PQE,PF58NP3313YFS55COJO0VQCB,MO13PA33UPV55FP0J,2553331QEJ513P,FGM55R3313X60,JSGZNA4BI6556C34B13XZHOQS,KNU0L1333X5537Z,G133455U9SS4U4EUK2U9,OQB9CH34F4EG35513C,755734TT13O,G0XX63455TZN61K13E,K13O4JR8G5534FHRSOBR6,T351553IBXUY,PZEP355513OWB6R,WH35B5513W,M5355D13TME,55P7UG136311MVUJDRE6HT5M8,5QN55MD6HT36E3DWI138N,T5NH81537530XC9S,T555ZFKTL3W4637R13TQO0,1380E5513F,R3855EC13S,T13W0XB5385C26GCS79UEFYM,1553387O0YZU1,38IMM4WX13YI55THX9IDQF1,81355CFAURXVH390RYBZ1,ZORBZBUKXG55P1339P8R364,Z5539P713ZT8JCU9,13KK3955YXPK,J5A3LZDE139553BVRWDK,I1340FD3O023SQO55DHBICJ,ZZ1403K55R3UD,3355O4013HZB,55HW0400N2138EXQI5OS4,132F55401FFK02BLZ,TO14033Q55914,44155E413L6,55ON42GY0BLQ13V,3N42PKNT55VEQETFG9130,13C0HOC17O551E342WN1USDLU,B5544Q13M4X,55E13450S6AEXTFC0VONQDY,1113IDZ85FCWZ45IJ8R55QNO0,7Q55JW8464CK130AQ4A,4655WE13SCB,E155463PWMN57KJ,M47R1H13YF55QN9OAEZM,5521473ZH19,3ZSD48E813HD55UIQ0D,ZV44955ANM13IYPW,5549JWRC13U,A497R2F55IHB0YI13FVMAF3EB,493PKBFP5513G,GEYR55051326,511355C28FU,52JK55313XB,E9U55I5Y53ZG132G4F46L1,559548GK3H13XHQT,SFQ50T54GD45513SLSN4T2V,S55651YON13ZW,5555FU1133,054Q1355VCF0,I9LG55553TM413ZI,2L156553WL,UFCKYPZ13UN6S55DSO65575NA,292BICI4M5595613JPISI,5755BH131MCIO3,55C13JB55NWM5JP56FG,67V6W55060761R15531Q2KHI,R13QLT855OION559740E,1354TL55FWF0,R6OK588K55KGI13P5TZNG,58GVY555U13CORVW,355U7F58138W6,OC5558Z13VMJMWALAI,X0ZF58M6555139,G1315558UMB5FEEVG,Q589L55BAD13KMBPGU96C004,BM58QW13550FZO,G3N13P3EV0B5559K6FCLFY,9V13H93BK8I595569VOA7O,18X1355GMA193X59GK3X1,7156300BYJFP0JT,2AA150063ONH9 , 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_AmazonUploadProduct_V2ExtendV2.GetAutoPublishProductQueueList(Int32 customerID, List`1 orderSourceSKUList) 在 Biz.Irobotbox.Amazon.Amazon_Product_Base_SynQueue.GetAutoPublishProductQueueList(Int32 customerID, List`1 orderSourceSKUList) 在 Biz.Irobotbox.Amazon.Amazon_Product_Base_SynQueue.SyncAddListingV2ByCustomer(RB_Customer_Setting customer) 在 System.Collections.Generic.List`1.ForEach(Action`1 action) 在 ChinaDownLoadImage.Task.Amazon.Task_Amazon_SyncListing.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()
[结果]
[期望]
该脚本已优化完成