[步骤]
prometheus告警
开始时间: 02:03:50
错误代码: N02035013
sql类型: SELECT
sql: [02:03:50] -------------------------------------------------------------
CODE:N02035013
Error:15_102_1_-2146232060
SQL:SELECT
[ID],[CustomerID],[OrderSourceID],[AccountDetailsEntryType],[BalanceCurrencyID],[BalanceValue],[ConversionRateCurrencyID],[ConversionRateValue],[date],[Description],[GrossDetailAmountCurrencyID],[GrossDetailAmountValue],[ItemID],[Memo],[NetDetailAmountCurrencyID],[NetDetailAmountValue],[OrderLineItemID],[ReceivedTopRatedDiscount],[RefNumber],[Title],[TransactionID],[VATPercent],[AccountState],[AmountPastDueCurrencyID],[AmountPastDueValue],[BankAccountInfo],[BankModifyDate],[BillingCycleDate],[CreditCardExpiration],[CreditCardInfo],[CreditCardModifyDate],[CurrentBalanceCurrencyID],[CurrentBalanceValue],[InvoiceBalanceCurrencyID],[InvoiceBalanceValue],[InvoiceCreditCurrencyID],[InvoiceCreditValue],[InvoiceDate],[InvoiceNewFeeCurrencyID],[InvoiceNewFeeValue],[InvoicePaymentCurrencyID],[InvoicePaymentValue],[LastAmountPaidCurrencyID],[LastAmountPaidValue],[LastPaymentDate],[PastDue],[PaymentMethod],[AddTime],[IsBuildFee],[BuildFeeTime],[AccountID],[ComeSource],[OrderId],[PayoutId],[BookingEntry]
FROM
RB_Ebay_Account_Fee (nolock)
WHERE
ComeSource='TransactionAPI'
AND CustomerID IN (1)
AND OrderSourceID IN (6635)
AND OrderLineItemID IN ('0','10053037684419','10053138876401','10053145802419','10053175947714','10053184628720','10053186554919','10053186555019','10053189551411','10053216117210','10053254100210','10053254961810','10053256540319','10053256540419','10053256540519','10053288932023','10053295511612','10053306222815','10053921739403','10054358260213','10054437192813','10054518047813','10056055160918','10056216492818','10058235361107','10058500678821')
AND TransactionID IN ('01-09844-12872','03-09839-71784','07-09849-80305','10-09861-90514','10-09868-14505','10-09868-28292','11-09846-77660','12-09870-05066','13-09835-53584','13-09848-65579','13-09862-37111','14-09854-77896','15-09874-78658','18-09828-34186','18-09855-38266','19-09831-27304','19-09849-31346','19-09856-24305','19-09867-72528','20-09839-43277','21-09860-85342','DISPUTE_HOLD_REVERSE-6133108148-5751521660','DISPUTE_HOLD-6133108148','FEE-4949683741819','FEE-4949683787519','FEE-4949683835219','FEE-4949683900019','FEE-4949683971819','FEE-4949684039419','FEE-4949684075019','FEE-4949684140419','FEE-4949684194619','FEE-4949684248019','FEE-4949684298219','FEE-4949684360019','FEE-4949684401019','FEE-4949684467919','FEE-4949684533819','FEE-4949684590419','FEE-4949684662819','FEE-4949684737019','FEE-4949684803419','FEE-4949684846019','FEE-4949684939019','FEE-4949684974219','FEE-4949685014319','FEE-4949685052719','FEE-4949685104119','FEE-4949685163219','FEE-4949685201619','FEE-4949685239719','FEE-4949685289519','FEE-4949685335519','FEE-4949685387919','FEE-4949685430619','FEE-4949685489419','FEE-4949685529819','FEE-4949685583419','FEE-4949685651719','FEE-4949685702119','FEE-4949685751719','FEE-4949685798719','FEE-4949703503319','FEE-4949703564319','FEE-4949703603319','FEE-4949703640519','FEE-4949703694119','FEE-4949703745919','FEE-4949703790119','FEE-4949703853919','FEE-4949703905019','FEE-4949703973919','FEE-4949708763219','FEE-4949711660219','FEE-4949714779419','FEE-4949717234019','FEE-4949720414619','FEE-4949723505319','FEE-4949728929719','FEE-4949731976819','FEE-4949735093619','FEE-4949737056019','FEE-4949739401119','FEE-4949745430419','FEE-4949748020719','FEE-4949751528319','FEE-4949756395519','FEE-4949759660619','FEE-4949763196819','FEE-4949766578919','FEE-4949771654319','FEE-4949774064919','FEE-4949778329719','FEE-4949782765419','FEE-4949795417019','FEE-4949800293819','FEE-4949807936919','FEE-4949812626819','FEE-4949817626319','FEE-4949819061119','FEE-4949822682119','FEE-4949826247219','FEE-4949832846919','FEE-4949835493419','FEE-4949838765019','FEE-4949844265219','FEE-4949849615519','FEE-4949853241019','FEE-4949858349619','FEE-4949866220119','FEE-4949872967519','FEE-4949879896919','FEE-4949883107119','FEE-4949883168619','FEE-4949885401419','FEE-4949889277319','FEE-4949907948819','FEE-4949908590019','FEE-4949908831019','FEE-4949918364519','FEE-4949923834819','FEE-4949931135519','FEE-4949933621319','FEE-4949940906419','FEE-4949949806619','FEE-4949951684519','FEE-4949957515619','FEE-4949961458519','FEE-4949968790619','FEE-4949973917719','FEE-4949974358819','FEE-4949978692519','FEE-4949984333419','FEE-4949990681419','FEE-4949992448219','FEE-4950000987319','FEE-4950011506219','FEE-4950023562619','FEE-4950027235519','FEE-4950032046219','FEE-4950037634919','FEE-4950041791819','FEE-4950042491919','FEE-4950052901019','FEE-4950056914019','FEE-4950066522019','FEE-4950070820119','FEE-4950078534919','FEE-4950082901019','FEE-4950087160019','FEE-4950519524919','FEE-4951576329919','FEE-4951654618719','FEE-4951706797319','FEE-4951940547919','FEE-4952041862019','FEE-4952468361319','FEE-4952600280719','FEE-4952626602019','FEE-4953311931219','FEE-4953579408919','FEE-4953587217619','FEE-4953594607019','FEE-4953607189419','FEE-4953612993519','FEE-4953618735919','FEE-4953625543919','FEE-4953631623819','FEE-4953638309019','FEE-4953649680519','FEE-4953656212019','FEE-4953660827719','FEE-4953666159819','FEE-4953671384119','FEE-4953677844019','FEE-4953681969719','FEE-4953687318319','FEE-4953692876819','FEE-4953700191219','FEE-4953704809719','FEE-4953708994819','FEE-4953713943419','FEE-4953720418519','FEE-4953727961919','FEE-4953727962919','FEE-4953732955019','FEE-4953739975119','FEE-4953752226719','FEE-4953757362719','FEE-4953772384719','FEE-4953788988319','FEE-4953796100219','FEE-4953806378319','FEE-4953815195919','FEE-4953820983219','FEE-4953834521619','FEE-4953836036519','FEE-4953844584919','FEE-4953849532719','FEE-4953863693019','FEE-4953878816919','FEE-4953887451219','FEE-4953894287819','FEE-4953901670919','FEE-4953909208219','FEE-4953915634619','FEE-4953920784119','FEE-4953927866019','FEE-4953936934019','FEE-4957047785219','FEE-4958384137119','FEE-4958929997019','FEE-4959431000219','FEE-4960095670919','FEE-4960095737719','FEE-4960095804819','FEE-4960095878319','FEE-4960095955119','FEE-4960096034219','FEE-4960096080219','FEE-4960096137319','FEE-4960096202919','FEE-4960096267319','FEE-4960096310919','FEE-4960096368719','FEE-4960096458319','FEE-4960096537519','FEE-4960096583019','FEE-4960096642519','FEE-4960096710619','FEE-4960096759119','FEE-4960096829319','FEE-4960096887819','FEE-4960096936119','FEE-4960097019919','FEE-4960097088819','FEE-4960097165219','FEE-4960097243319','FEE-4960097301119','FEE-4960097349619','FEE-4960097404119','FEE-4960426765819','FEE-4961109683519','FEE-4962627406819','FEE-4964226483219','FEE-4964307354219','FEE-4965132890819','FEE-4965868094119','FEE-4965885178819','FEE-4965932269819','FEE-4966865087519','FEE-4967511431319','FEE-4967994306919','FEE-4969029601619','FEE-4969420669819','FEE-4969420693319','FEE-4969420714719','FEE-4970609490819','FEE-4970609497319','FEE-4970609680619','FEE-4970609840119','FEE-4970609897919','FEE-4970609915919','FEE-4970610114619','FEE-4970610431119','FEE-4970610440519','FEE-4970610545719','FEE-4970610924219','FEE-4970611034219','FEE-4970611193619','FEE-4970611196419','FEE-4970818135919','FEE-4970832685819','FEE-4970832686219','FEE-4970833427819','FEE-4970833768919','FEE-4970837328219','FEE-4971644002519','INTERNAL_TRANSFER-6137406548-12','INTERNAL_TRANSFER-M_MAL_4247_9069_5383548-23','INVOICE-3-4287481-10')
AND Description IN ('AD_FEE','CASE_ID:','eBay Credit','FINAL_VALUE_FEE','FINAL_VALUE_FEE_FIXED_PER_ORDER','INSERTION_FEE','INTERNATIONAL_FEE','Payment to plaintiff as ordered by the court in the final judgment order in Wham-O case 20-cv-6011. For more info contact plaintiff's attorney attorney@vogtip.com.')
UNION ALL
SELECT [ID],[CustomerID],[OrderSourceID],[AccountDetailsEntryType],[BalanceCurrencyID],[BalanceValue],[ConversionRateCurrencyID],[ConversionRateValue],[date],[Description],[GrossDetailAmountCurrencyID],[GrossDetailAmountValue],[ItemID],[Memo],[NetDetailAmountCurrencyID],[NetDetailAmountValue],[OrderLineItemID],[ReceivedTopRatedDiscount],[RefNumber],[Title],[TransactionID],[VATPercent],[AccountState],[AmountPastDueCurrencyID],[AmountPastDueValue],[BankAccountInfo],[BankModifyDate],[BillingCycleDate],[CreditCardExpiration],[CreditCardInfo],[CreditCardModifyDate],[CurrentBalanceCurrencyID],[CurrentBalanceValue],[InvoiceBalanceCurrencyID],[InvoiceBalanceValue],[InvoiceCreditCurrencyID],[InvoiceCreditValue],[InvoiceDate],[InvoiceNewFeeCurrencyID],[InvoiceNewFeeValue],[InvoicePaymentCurrencyID],[InvoicePaymentValue],[LastAmountPaidCurrencyID],[LastAmountPaidValue],[LastPaymentDate],[PastDue],[PaymentMethod],[AddTime],[IsBuildFee],[BuildFeeTime],[AccountID],[ComeSource],[OrderId],[PayoutId],[BookingEntry]
FROM RB_Ebay_Account_Fee (nolock)
WHERE
ComeSource='TransactionAPI'
AND CustomerID IN (1)
AND OrderSourceID IN (6635)
AND OrderLineItemID IN ('0','10053037684419','10053138876401','10053145802419','10053175947714','10053184628720','10053186554919','10053186555019','10053189551411','10053216117210','10053254100210','10053254961810','10053256540319','10053256540419','10053256540519','10053288932023','10053295511612','10053306222815','10053921739403','10054358260213','10054437192813','10054518047813','10056055160918','10056216492818','10058235361107','10058500678821')
AND TransactionID IN ('01-09844-12872','03-09839-71784','07-09849-80305','10-09861-90514','10-09868-14505','10-09868-28292','11-09846-77660','12-09870-05066','13-09835-53584','13-09848-65579','13-09862-37111','14-09854-77896','15-09874-78658','18-09828-34186','18-09855-38266','19-09831-27304','19-09849-31346','19-09856-24305','19-09867-72528','20-09839-43277','21-09860-85342','DISPUTE_HOLD_REVERSE-6133108148-5751521660','DISPUTE_HOLD-6133108148','FEE-4949683741819','FEE-4949683787519','FEE-4949683835219','FEE-4949683900019','FEE-4949683971819','FEE-4949684039419','FEE-4949684075019','FEE-4949684140419','FEE-4949684194619','FEE-4949684248019','FEE-4949684298219','FEE-4949684360019','FEE-4949684401019','FEE-4949684467919','FEE-4949684533819','FEE-4949684590419','FEE-4949684662819','FEE-4949684737019','FEE-4949684803419','FEE-4949684846019','FEE-4949684939019','FEE-4949684974219','FEE-4949685014319','FEE-4949685052719','FEE-4949685104119','FEE-4949685163219','FEE-4949685201619','FEE-4949685239719','FEE-4949685289519','FEE-4949685335519','FEE-4949685387919','FEE-4949685430619','FEE-4949685489419','FEE-4949685529819','FEE-4949685583419','FEE-4949685651719','FEE-4949685702119','FEE-4949685751719','FEE-4949685798719','FEE-4949703503319','FEE-4949703564319','FEE-4949703603319','FEE-4949703640519','FEE-4949703694119','FEE-4949703745919','FEE-4949703790119','FEE-4949703853919','FEE-4949703905019','FEE-4949703973919','FEE-4949708763219','FEE-4949711660219','FEE-4949714779419','FEE-4949717234019','FEE-4949720414619','FEE-4949723505319','FEE-4949728929719','FEE-4949731976819','FEE-4949735093619','FEE-4949737056019','FEE-4949739401119','FEE-4949745430419','FEE-4949748020719','FEE-4949751528319','FEE-4949756395519','FEE-4949759660619','FEE-4949763196819','FEE-4949766578919','FEE-4949771654319','FEE-4949774064919','FEE-4949778329719','FEE-4949782765419','FEE-4949795417019','FEE-4949800293819','FEE-4949807936919','FEE-4949812626819','FEE-4949817626319','FEE-4949819061119','FEE-4949822682119','FEE-4949826247219','FEE-4949832846919','FEE-4949835493419','FEE-4949838765019','FEE-4949844265219','FEE-4949849615519','FEE-4949853241019','FEE-4949858349619','FEE-4949866220119','FEE-4949872967519','FEE-4949879896919','FEE-4949883107119','FEE-4949883168619','FEE-4949885401419','FEE-4949889277319','FEE-4949907948819','FEE-4949908590019','FEE-4949908831019','FEE-4949918364519','FEE-4949923834819','FEE-4949931135519','FEE-4949933621319','FEE-4949940906419','FEE-4949949806619','FEE-4949951684519','FEE-4949957515619','FEE-4949961458519','FEE-4949968790619','FEE-4949973917719','FEE-4949974358819','FEE-4949978692519','FEE-4949984333419','FEE-4949990681419','FEE-4949992448219','FEE-4950000987319','FEE-4950011506219','FEE-4950023562619','FEE-4950027235519','FEE-4950032046219','FEE-4950037634919','FEE-4950041791819','FEE-4950042491919','FEE-4950052901019','FEE-4950056914019','FEE-4950066522019','FEE-4950070820119','FEE-4950078534919','FEE-4950082901019','FEE-4950087160019','FEE-4950519524919','FEE-4951576329919','FEE-4951654618719','FEE-4951706797319','FEE-4951940547919','FEE-4952041862019','FEE-4952468361319','FEE-4952600280719','FEE-4952626602019','FEE-4953311931219','FEE-4953579408919','FEE-4953587217619','FEE-4953594607019','FEE-4953607189419','FEE-4953612993519','FEE-4953618735919','FEE-4953625543919','FEE-4953631623819','FEE-4953638309019','FEE-4953649680519','FEE-4953656212019','FEE-4953660827719','FEE-4953666159819','FEE-4953671384119','FEE-4953677844019','FEE-4953681969719','FEE-4953687318319','FEE-4953692876819','FEE-4953700191219','FEE-4953704809719','FEE-4953708994819','FEE-4953713943419','FEE-4953720418519','FEE-4953727961919','FEE-4953727962919','FEE-4953732955019','FEE-4953739975119','FEE-4953752226719','FEE-4953757362719','FEE-4953772384719','FEE-4953788988319','FEE-4953796100219','FEE-4953806378319','FEE-4953815195919','FEE-4953820983219','FEE-4953834521619','FEE-4953836036519','FEE-4953844584919','FEE-4953849532719','FEE-4953863693019','FEE-4953878816919','FEE-4953887451219','FEE-4953894287819','FEE-4953901670919','FEE-4953909208219','FEE-4953915634619','FEE-4953920784119','FEE-4953927866019','FEE-4953936934019','FEE-4957047785219','FEE-4958384137119','FEE-4958929997019','FEE-4959431000219','FEE-4960095670919','FEE-4960095737719','FEE-4960095804819','FEE-4960095878319','FEE-4960095955119','FEE-4960096034219','FEE-4960096080219','FEE-4960096137319','FEE-4960096202919','FEE-4960096267319','FEE-4960096310919','FEE-4960096368719','FEE-4960096458319','FEE-4960096537519','FEE-4960096583019','FEE-4960096642519','FEE-4960096710619','FEE-4960096759119','FEE-4960096829319','FEE-4960096887819','FEE-4960096936119','FEE-4960097019919','FEE-4960097088819','FEE-4960097165219','FEE-4960097243319','FEE-4960097301119','FEE-4960097349619','FEE-4960097404119','FEE-4960426765819','FEE-4961109683519','FEE-4962627406819','FEE-4964226483219','FEE-4964307354219','FEE-4965132890819','FEE-4965868094119','FEE-4965885178819','FEE-4965932269819','FEE-4966865087519','FEE-4967511431319','FEE-4967994306919','FEE-4969029601619','FEE-4969420669819','FEE-4969420693319','FEE-4969420714719','FEE-4970609490819','FEE-4970609497319','FEE-4970609680619','FEE-4970609840119','FEE-4970609897919','FEE-4970609915919','FEE-4970610114619','FEE-4970610431119','FEE-4970610440519','FEE-4970610545719','FEE-4970610924219','FEE-4970611034219','FEE-4970611193619','FEE-4970611196419','FEE-4970818135919','FEE-4970832685819','FEE-4970832686219','FEE-4970833427819','FEE-4970833768919','FEE-4970837328219','FEE-4971644002519','INTERNAL_TRANSFER-6137406548-12','INTERNAL_TRANSFER-M_MAL_4247_9069_5383548-23','INVOICE-3-4287481-10')
AND Description IS NULL
PARAMS:
MESSAGE:Incorrect syntax near 's'.
Unclosed quotation mark after the character string ')
AND Description IS NULL'.
TRACE: 在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 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, TaskCompletionSource1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
在 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
在 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable)
在 RB.DAL.DBOperator.Query(String SQLString, SqlCommand cmd, Int32 Times, SqlParameter[] cmdParms, Boolean IsWriteDB) 在 RB.DAL.DBOperator.toCommonTipException(SqlException ex, String sql, SqlParameter[] cmdParms)
在 RB.DAL.DBOperator.Query(String SQLString, SqlCommand cmd, Int32 Times, SqlParameter[] cmdParms, Boolean IsWriteDB)
在 RB.DALExtend.Generate.RB_Ebay_Account_FeeExtend.GetTransactionList(List1 customerIds, List1 orderSourceIds, List1 orderLineItemIDs, List1 transactionIDs, List1 descriptions) 在 Biz.Ebay.AccountFee.AccountFeeDownloadV2.ProcessEabyAccountFromTransaction(RB_OrderSource_EbayAmazonAPI_FromTransactionModel account, Int32 retryCount) 在 Biz.Ebay.AccountFee.AccountFeeDownloadV2.DownloadAccountFeeFromTransaction(RB_OrderSource_EbayAmazonAPI_FromTransactionModel account) 在 RB.Utility.TaskSmartManager1.execute(Func`2 execFunction)
在 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()
[结果]
[期望]
