[步骤]
prometheus告警
开始时间: 15:25:20
错误代码: N1525201
sql类型: SELECT
sql: [15:25:20] -------------------------------------------------------------
CODE:N1525201
Error:15_102_1_-2146232060
SQL:
select [ID],[CustomerID],[SKU],[ProductGroupSKU],[ComeSource],[ReferenceUrl],[ClientSKU],[ProductName],[ProductNameCN],[SearchKeyword],[ProductProperty],[WithBattery],[ProductState],[PlugRelate],[OnlineStatus],[BeginTime],[EndTime],[ProductModelID],[ClassID],[ClassID1],[ClassID2],[BrandID],[LastSupplierPrice],[LastBuyPrice],[MarketPrice],[SalePrice],[MinSalePrice],[MinSaleNum],[ImageUrl],[NetWeight],[GrossWeight],[PackWeight],[Length],[Width],[Height],[Pack_Length],[Pack_Width],[Pack_Height],[PageTitle],[MateKeyword],[MateDescription],[ProductDescription],[PackingList],[FeatureList],[UnitName],[UnitNum],[Url],[AdvanceSale],[PlanArriveDate],[OrderProductCount],[RecommendType],[IsGroup],[SupplyState],[ProdutcArrivalDate],[ProdutStopDate],[NewUploadUpdateDateTime],[NewUploadImageDateTime],[ProductColor],[ProductSize],[TempOrderState],[IsRawMaterial],[UnitShipFee],[SMTProID],[LastBuyShipFee],[DeleteStatus],[IsNeedPhoto],[PlugRelateType],[Undercarriage],[ProductStateRemarks],[AddedOrderSourceTypes],[ReceiptRemark],[IsQualitInCollection],[ProductType],[TaxPoint],[TaxRate],[IsFBABarCode],[IsRecommendOcean],[Carton_Length],[Carton_Width],[Carton_Height],[Carton_PcsNum],[Carton_GrossWeight],[Carton_NetWeight],[UpdateTaxRateTime],[LastSinglePrice],[IsCheckTransport],[IsCheckDeclarationCode],[NeedToPackType],[ProductSpec],[DefaultLocalWarehouse],[IsDiscontinuedApprove],[DiscontinuedApproveReason],[DiscontinuedApproveApplicant],[DiscontinuedApproveApplicantId],[DiscontinuedApproveApplyTime],[IsBiSycnComplete],[BiSycnCompleteTime],[IsPreclass],[PreclassStatus],[AddTime],[UpdateTime],[ReportingElements],[DevelopType],[AppointDevelopType],[PictureSource],[PreclassType],[Is1688DistributeProduct],[PreclassGoodsCode],[PreclassNumber],[YunAccountId],[ImitatingBrandRemark],[ClassPath],[IsTranslationLanguage],[IsHaveSetSaleSource],[IsSpu],[IsIntelligentStocking],[IsMainGroupSKU],[ImageUpdateTime],[AccurateKeyword],[IsKeyAttributesEdit],[BrandLevel],[IsLogisticsCheck],[LogisticsCheckType],[EditNum],[ProductMaterial],[HolidayID],[IsNeedCeCertification],[GroupSkuID],[IsInfringementConfirm],[AutoChooseKeyWords],[ProductSizeName],[PackingListCn],[TypeOfTorts],[IsSingleDistributeBuyerId],[RiskLevel],[RiskLevelRemark]
from RB_Product with(nolock)
where SKU in (''0406925') and CustomerID=1
PARAMS:
MESSAGE:Incorrect syntax near '0406925'.
Unclosed quotation mark after the character string ') and CustomerID=1'.
TRACE: 在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) 在 System.Data.SqlClient.SqlInternalConnection.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.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) 在 System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) 在 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.RB_ProductExtend.GetProductModelList(List1 skus, Int32 customerId)
在 PandaBuy.ERP.Web.IrobotBox.Product.UploadAmazonProductV3.LoadSKUList()
在 PandaBuy.ERP.Web.IrobotBox.Product.UploadAmazonProductV3.Page_Load(Object sender, EventArgs e)
在 System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e)
在 System.EventHandler.Invoke(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.ProcessRequestWithNoAssert(HttpContext context)
在 System.Web.UI.Page.ProcessRequest(HttpContext context)
在 ASP.irobotbox_product_uploadamazonproductv3_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.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)
在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)
[结果]
[期望]
