prometheus告警
开始时间: 14:10:24
错误代码: N14102410
sql类型: CREATE
sql: [14:10:24] -------------------------------------------------------------
CODE:N14102410
Error:15_102_1_-2146232060
SQL:CREATE TABLE #tempCon
(
CustomerID INT,
OrderSourceSKUID INT,
OrderSourceID INT,
OrderSourceSKU VARCHAR(400),
IsOffShelf int,
UpdateTime DateTime,
IsVariation bit,
VariantGroup VarChar(100),
RecommendedBrowseNodeName VarChar(2000),
TemplateID INT,
ImageUrl VarChar(250),
ASINorItemID VarChar(50),
BrowsePathByID VarChar(1000),
ListingPrice Decimal(18,2),
AddAdminID INT,
AddAdminName VarChar(50),
ProductName VarChar(2000),
PreDiscountPrice Decimal(18,2),
DiscountSalesPrice Decimal(18,2),
DiscountStartTime DateTime,
DiscountEndTime DateTime,
BrandAddTitle Bit,
TranslateStatus INT,
OnShelfMode INT,
ConstSeconds INT,
ShelfRemark VarChar(50)
); INSERT INTO #tempCon VALUES (1, 896232749, 5383,'130558PFXT',0,'2023/3/24 20:43:31','True','2022725162102216','Pet Supplies(8)(宠物用品)>>Birds(9)(鸟)>>Cages & Accessories(10)(笼及配件)>>Other(0)(其他)',1002500,'http://picture.irobotbox.com/Amazon-Z01026-MX/1/ProductImages/7539163/2023/01/12/6a03ebcaae9e4790a4c43f66b15e45a5/33a6a032-e3de-40fd-b46f-b061ee3361ff.jpg?x-oss-process=image/resize,m_pad,w_1603,h_1603,limit_0,color_ffffff','B0B7JPBQCY','2619533011,2619534011,2975221011,2975222011,2975222011',24.49,7680,'梁凯欣','Parrot Foot Chain, Stainless Steel Bird Foot Stand Chain with Ring, Parrot Ankle Foot Ring Pet Supplies for Birds Cockatiels',23.69,22.51,'2022/8/12 0:00:00','2022/8/23 0:00:00','True',0,1,446,'V3'),(1, 896239519, 6479,'3NJOTZ99160028Q122CYT8',0,'2023/3/24 20:43:31','True','2022725162124268','Productos para Animales(11)(动物产品)>>Aves y Vida Silvestre de Jardín(6)(园鸟与野生动物)>>Aves(5)(鸟类)>>Otro(0)(其他)',947573,'http://picture.irobotbox.com/Amazon-Z01026-MX/1/ProductImages/7539163/2023/01/12/6a03ebcaae9e4790a4c43f66b15e45a5/33a6a032-e3de-40fd-b46f-b061ee3361ff.jpg?x-oss-process=image/resize,m_pad,w_1603,h_1603,limit_0,color_ffffff','B0B7J9PWT2','11782336011,11782337011,20949686011,20949736011,20949736011',452.19,7680,'梁凯欣','Cadena de Pie de Loro Cadena de Pie de Pie de Pájaro de Acero Inoxidable con Anillo Loros Anillo de Pie Anillo Suministros para Mascotas para Pájaros Cacatúas',452.19,406.97,'2023/3/20 0:00:00','2023/4/20 0:00:00','True',1,1,446,'V3'),(1, 896239546, 9641,'61302ZH164',0,'2023/3/24 20:43:31','True','2022725162129626','Pet Shop(9)(宠物商店)>>Aves e Pássaros(8)(鸟和鸟)>>Acessórios para Gaiolas(6)(笼式配件)>>Outros(0)(其他)',1483442,'http://picture.irobotbox.com/Amazon-Z01447-SE/1/ProductImages/7539163/2023/01/12/6a03ebcaae9e4790a4c43f66b15e45a5/33a6a032-e3de-40fd-b46f-b061ee3361ff.jpg?x-oss-process=image/resize,m_pad,w_1603,h_1603,limit_0,color_ffffff','B0B7JBNJ5Y','18991136011,18991137011,19653949011,19653985011,19653985011',141.19,7680,'梁凯欣','Cadeia de Pé de Papagaio Cadeia de Pé de A?o Inoxidável Com Anel de Anel de Anel Tornozelo de Tornozelo para O Tornozelo para Pássaros Cockatiels',141.19,131.31,'2022/11/2 0:00:00','2022/11/30 0:00:00','True',1,1,446,'V3'),(1, 896239652, 9924,'3R5UG30215F6OTASY288Z16T',0,'2023/3/24 20:43:31','True','2022725162135900','Pet Supplies(9)(宠物用品)>>Birds(8)(鸟类)>>Birdcage Accessories(5)(鸟笼配件)>>Other(0)(其他)',1381060,'http://picture.irobotbox.com/Amazon-Z01447-SE/1/ProductImages/7539163/2023/01/12/6a03ebcaae9e4790a4c43f66b15e45a5/33a6a032-e3de-40fd-b46f-b061ee3361ff.jpg?x-oss-process=image/resize,m_pad,w_1603,h_1603,limit_0,color_ffffff','B0B7J78WY7','6315296051,6315297051,6386498051,6386513051,6386513051',30.49,7680,'梁凯欣','Parrot Foot Chain, Stainless Steel Bird Foot Stand Chain with Ring, Parrot Ankle Foot Ring Pet Supplies for Birds Cockatiels',30.49,28.36,'2022/11/2 0:00:00','2022/11/30 0:00:00','True',0,1,446,'V3'),(1, 896239808, 11023,'16BM0172QBWNC',0,'2023/3/24 20:43:31','True','2022725162163617','Pet Supplies(10)(宠物用品)>>Birds(8)(鸟)>>Other(0)(其他)',628650,'http://picture.irobotbox.com/Amazon-Z01447-SE/1/ProductImages/7539163/2023/01/12/6a03ebcaae9e4790a4c43f66b15e45a5/33a6a032-e3de-40fd-b46f-b061ee3361ff.jpg?x-oss-process=image/resize,m_pad,w_1603,h_1603,limit_0,color_ffffff','B0B7J66V7G','340840031,340841031,451108031,451108031',29.19,7680,'梁凯欣','Parrot Foot Chain, Stainless Steel Bird Foot Stand Chain with Ring, Parrot Ankle Foot Ring Pet Supplies for Birds Cockatiels',29.19,26.27,'2023/3/20 0:00:00','2023/4/20 0:00:00','True',0,1,446,'V3'),(1, 896239889, 11024,'U021816VWD',0,'2023/3/24 20:43:31','True','2022725162187804','Haustier(20)(宠物)>>V?gel(9)(禽鸟)>>K?fige & Zubeh?r(11)(笼及配件)>>K?fige(0)(笼)',1706246,'http://picture.irobotbox.com/Amazon-Z01447-SE/1/ProductImages/7539163/2023/01/12/6a03ebcaae9e4790a4c43f66b15e45a5/33a6a032-e3de-40fd-b46f-b061ee3361ff.jpg?x-oss-process=image/resize,m_pad,w_1603,h_1603,limit_0,color_ffffff','B0B7J92GW5','340852031,340853031,445319031,470866031,470868031',33.19,7680,'梁凯欣','Parrot Fu?kette Edelstahl- Vogelfu?- Standkette mit Ring Papageien- Kn?chelfu?- Ring- Haustier Vorr?te für V?gel Cockatiels',33.19,29.87,'2023/3/20 0:00:00','2023/4/20 0:00:00','True',1,1,446,'V3'),(1, 896239909, 11025,'47V74E602189H16V5DU',0,'2023/3/30 14:56:58','True','2022725162182813','Prodotti per animali domestici(20)(宠物用品)>>Uccelli(9)(鸟类)>>Gabbie e accessori(11)(笼子和配件)>>Gabbie(0)(笼)',1063139,'http://picture.irobotbox.com/Amazon-Z01447-SE/1/ProductImages/7539163/2023/01/12/6a03ebcaae9e4790a4c43f66b15e45a5/33a6a032-e3de-40fd-b46f-b061ee3361ff.jpg?x-oss-process=image/resize,m_pad,w_1603,h_1603,limit_0,color_ffffff','B0B7JHVHN3','12472499031,12472500031,13369973031,13370064031,13370370031',40.59,7680,'梁凯欣','Catena Del Piede Del Pappagallo Catena Del Piede per Uccelli in Acciaio Inossidabile con Anello Poggiatesta Della Caviglia per Pappagalli.',40.59,36.53,'2023/3/20 0:00:00','2023/4/20 0:00:00','True',1,1,446,'V3'),(1, 896239930, 11026,'Y1J3MO5Y191102CNL16E',0,'2023/3/25 21:16:23','True','2022725162184948','Animalerie(24)(宠物商店)>>Oiseaux(9)(鸟)>>Cages et accessoires(10)(笼及配件)>>Autre(0)(其他)',1131457,'http://picture.irobotbox.com/Amazon-Z01447-SE/1/ProductImages/7539163/2023/01/12/6a03ebcaae9e4790a4c43f66b15e45a5/33a6a032-e3de-40fd-b46f-b061ee3361ff.jpg?x-oss-process=image/resize,m_pad,w_1603,h_1603,limit_0,color_ffffff','B0B7J9HZN5','1571268031,1571269031,1981903031,2036541031,2036541031',37.69,7680,'梁凯欣','Cha?ne de Pied de Perroquet Cha?ne de Supports à Pied D' oiseau en Acier Inoxydable avec Anneau Perroquet à Pied D'',37.69,33.92,'2023/3/20 0:00:00','2023/4/20 0:00:00','True',1,1,446,'V3'),(1, 896239959, 11027,'19ABH0216X9',0,'2023/3/25 9:21:48','True','2022725162195234','Productos para mascotas(11)(宠物用品)>>Pájaros(8)(鸟类)>>Jaulas y accesorios(13)(笼子和配件)>>Otro(0)(其他)',890095,'http://picture.irobotbox.com/Amazon-Z01447-SE/1/ProductImages/7539163/2023/01/12/6a03ebcaae9e4790a4c43f66b15e45a5/33a6a032-e3de-40fd-b46f-b061ee3361ff.jpg?x-oss-process=image/resize,m_pad,w_1603,h_1603,limit_0,color_ffffff','B0B7JC8G1F','12472654031,12472656031,13441888031,13441966031,13441966031',36.29,7680,'梁凯欣','Cadena de Pie de Loro Cadena de Pie de Pie de Pájaro de Acero Inoxidable con Anillo Loros Anillo de Pie Anillo Suministros para Mascotas para Pájaros Cacatúas',36.29,32.66,'2023/3/20 0:00:00','2023/4/20 0:00:00','True',1,1,446,'V3'),(1, 896239993, 11028,'2DF7WB558021206KCRVO',0,'2023/3/24 20:43:31','True','2022725162199486','Huisdierbenodigdheden(9)(宠物用品)>>Vogels(9)(鸟儿)>>Vogelkooiaccessoires(10)(鸟配件)>>Overig(0)(其他)',794056,'http://picture.irobotbox.com/Amazon-Z01447-SE/1/ProductImages/7539163/2023/01/12/6a03ebcaae9e4790a4c43f66b15e45a5/33a6a032-e3de-40fd-b46f-b061ee3361ff.jpg?x-oss-process=image/resize,m_pad,w_1603,h_1603,limit_0,color_ffffff','B0B7JG6HKR','16242572031,16242573031,16332435031,16332450031,16332450031',37.79,7680,'梁凯欣','Papegaai Voetketting Roestvrijstalen Vogelvoetketting Met Ring Papegaai Enkelvoet Ring Huisdierbenodigdheden Voor Vogels Valkatertjes',37.79,34.01,'2023/3/20 0:00:00','2023/4/20 0:00:00','True',1,1,446,'V3'),(1, 896240020, 13866,'702K20F167FB',0,'2023/3/24 20:43:31','True','2022811112397780','Artyku?y dla zwierz?t(9)(动物用品)>>Ptaki(8)(那些鸟儿)>>Akcesoria do klatek dla ptaków(4)(鸟笼配件)>>Other(0)(其他)',1245195,'http://picture.irobotbox.com/Amazon-Z01447-SE/1/ProductImages/7539163/2023/01/12/6a03ebcaae9e4790a4c43f66b15e45a5/33a6a032-e3de-40fd-b46f-b061ee3361ff.jpg?x-oss-process=image/resize,m_pad,w_1603,h_1603,limit_0,color_ffffff','B0B99RKCLR','20659309031,20659310031,20855446031,20855504031,20855504031',163.79,7680,'梁凯欣','?ańcuch Stóp Papugi ?ańcuch Stojowy Ptaków Ze Stali Nierdzewnej Z Pier?cieniem Papugi Kostki Pier?cień Pet Pet Zapasy Dla Ptaków',163.79,147.41,'2023/3/20 0:00:00','2023/4/20 0:00:00','True',0,1,32,'V3'),(1, 896240053, 13867,'7E0163MBQ0284SXRBR20OAD5K',0,'2023/3/24 20:43:31','True','20228111158234334','Ev ve Ya?am(10)(家庭生活)>>Di?er(0)(其他)',1695538,'http://picture.irobotbox.com/Amazon-Z01447-SE/1/ProductImages/7539163/2023/01/12/6a03ebcaae9e4790a4c43f66b15e45a5/33a6a032-e3de-40fd-b46f-b061ee3361ff.jpg?x-oss-process=image/resize,m_pad,w_1603,h_1603,limit_0,color_ffffff','B0B99XPBPB','12466667031,12466668031,12466668031',458.49,7680,'梁凯欣','Stainless Steel Foot Chain Metal Ankle Chain Anti- Off Anklet Durable Ankle Rings for Birds Cockatiels Pet Parrot ( Size 4 Extraordinarily Thin Chain )',458.49,412.64,'2023/3/20 0:00:00','2023/4/20 0:00:00','True',0,1,0,'V2'),(1, 896240077, 14927,'021P02HU166',0,'2023/3/24 20:43:31','True','20228111156313010','Husdjurstillbeh?r(9)(宠物配件)>>F?glar(8)(鸟类)>>F?gelburstillbeh?r(4)(鸟笼配件)>>Other(0)(其他)',1234978,'http://picture.irobotbox.com/Amazon-Z01447-SE/1/ProductImages/7539163/2023/01/12/6a03ebcaae9e4790a4c43f66b15e45a5/33a6a032-e3de-40fd-b46f-b061ee3361ff.jpg?x-oss-process=image/resize,m_pad,w_1603,h_1603,limit_0,color_ffffff','B0B99YJQ9Q','20513422031,20513423031,20652813031,20652871031,20652871031',408.59,7680,'梁凯欣','Papegoja Fotkedja Rostfritt St?l F?gelfot Stativ Kedja Med Ring Papegoja Ankel Fot Ring Husdjur Leveranser F?r F?glar Cockatiels',408.59,367.73,'2023/3/20 0:00:00','2023/4/20 0:00:00','True',0,1,18,'V3');
CREATE INDEX idx_con
ON #tempCon (
CustomerID,
OrderSourceSKUID,
OrderSourceID,
OrderSourceSKU
);
UPDATE p
SET p.IsOffShelf = t.IsOffShelf,
p.UpdateTime = t.UpdateTime,
p.IsVariation = t.IsVariation,
p.VariantGroup = t.VariantGroup,
p.RecommendedBrowseNodeName = t.RecommendedBrowseNodeName,
p.TemplateID = t.TemplateID,
p.ImageUrl = t.ImageUrl,
p.ASINorItemID = t.ASINorItemID,
p.BrowsePathByID = t.BrowsePathByID,
p.ListingPrice = t.ListingPrice,
p.AddAdminID = t.AddAdminID,
p.AddAdminName = t.AddAdminName,
p.ProductName = t.ProductName,
p.PreDiscountPrice = t.PreDiscountPrice,
p.DiscountSalesPrice = t.DiscountSalesPrice,
p.DiscountStartTime = t.DiscountStartTime,
p.DiscountEndTime = t.DiscountEndTime,
p.BrandAddTitle = t.BrandAddTitle,
p.TranslateStatus = t.TranslateStatus,
p.OnShelfMode = t.OnShelfMode,
p.ConstSeconds = t.ConstSeconds,
p.ShelfRemark = t.ShelfRemark
FROM RB_Amazon_Product_Base p
INNER JOIN #tempCon t
ON p.CustomerID = t.CustomerID
AND p.OrderSourceSKUID = t.OrderSourceSKUID
AND p.OrderSourceID = t.OrderSourceID
AND p.OrderSourceSKU = t.OrderSourceSKU;
DROP TABLE IF EXISTS #tempCon;
DROP TABLE IF EXISTS #tempID;
PARAMS:
MESSAGE:Incorrect syntax near 'oiseau'.
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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
在 System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) 在 System.Data.SqlClient.SqlCommand.ExecuteNonQuery() 在 RB.DAL.DBOperator.ExecuteSql(String SQLString, SqlCommand cmd, Int32 Times, SqlParameter[] cmdParms) 在 RB.DAL.DBOperator.toCommonTipException(SqlException ex, String sql, SqlParameter[] cmdParms) 在 RB.DAL.DBOperator.ExecuteSql(String SQLString, SqlCommand cmd, Int32 Times, SqlParameter[] cmdParms) 在 RB.DAL.DBOperator.ExecuteSql(String SQLString) 在 RB.DALExtend.RB_Amazon_Product_BaseExtend.UpdateIsOffShelfByOrderSourceSKUIDNew(List1 models)
在 PandaBuy.ERP.Web.IrobotBox.Product.AmazonProductImageBacthEdit.Submit()
在 PandaBuy.ERP.Web.IrobotBox.Product.AmazonProductImageBacthEdit.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_amazonproductimagebacthedit_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)
