prometheus告警
开始时间: 02:02:10
错误代码: N02021035
sql类型: SELECT
sql: [02:02:10] -------------------------------------------------------------
CODE:N02021035
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','10053145802419','10053175947714','10053184628720','10053186554919','10053186555019','10053189551411','10053216117210','10053254100210','10053254961810','10053256540319','10053256540419','10053256540519','10053288932023','10053295511612','10053306222815','10053325121026','10053385533316','10053417636210','10053425787719','10053480978124','10053857537222','10054254953606','10054437192813','10054518047813','10056216492818','10058235361107','10058500678821')
AND TransactionID IN ('06-09888-03831','07-09849-80305','10-09861-90514','10-09868-14505','10-09868-28292','10-09895-48720','11-09846-77660','12-09870-05066','13-09848-65579','13-09862-37111','14-09854-77896','15-09874-78658','16-09887-04088','18-09855-38266','19-09849-31346','19-09856-24305','19-09867-72528','19-09896-00096','21-09860-85342','22-09904-93810','24-09896-55541','26-09880-75228','DISPUTE_HOLD_REVERSE-6133108148-5751521660','FEE-388815857-10','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','FEE-4975086081619','FEE-4975744568219','FEE-4975820615919','FEE-4981153346819','FEE-4985333001719','INTERNAL_TRANSFER-6137406548-12','INTERNAL_TRANSFER-6140616915-12','INTERNAL_TRANSFER-M_MAL_4247_9069_5383548-23','INVOICE-2-99138698-63-12','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','OTHER_FEES','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','10053145802419','10053175947714','10053184628720','10053186554919','10053186555019','10053189551411','10053216117210','10053254100210','10053254961810','10053256540319','10053256540419','10053256540519','10053288932023','10053295511612','10053306222815','10053325121026','10053385533316','10053417636210','10053425787719','10053480978124','10053857537222','10054254953606','10054437192813','10054518047813','10056216492818','10058235361107','10058500678821')
AND TransactionID IN ('06-09888-03831','07-09849-80305','10-09861-90514','10-09868-14505','10-09868-28292','10-09895-48720','11-09846-77660','12-09870-05066','13-09848-65579','13-09862-37111','14-09854-77896','15-09874-78658','16-09887-04088','18-09855-38266','19-09849-31346','19-09856-24305','19-09867-72528','19-09896-00096','21-09860-85342','22-09904-93810','24-09896-55541','26-09880-75228','DISPUTE_HOLD_REVERSE-6133108148-5751521660','FEE-388815857-10','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','FEE-4975086081619','FEE-4975744568219','FEE-4975820615919','FEE-4981153346819','FEE-4985333001719','INTERNAL_TRANSFER-6137406548-12','INTERNAL_TRANSFER-6140616915-12','INTERNAL_TRANSFER-M_MAL_4247_9069_5383548-23','INVOICE-2-99138698-63-12','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()