prometheus告警
开始时间: 15:53:30
错误代码: N15533018
sql类型: SELECT
sql: [15:53:30] -------------------------------------------------------------
CODE:N15533018
Error:15_137_2_-2146232060
SQL:SELECT
b.OrderSourceName as '渠道来源',
vtb.WareHouseName + '(' + vtb.OrderSourceName + ')' AS '备货仓库',
ASINorItemID AS ASIN,
vtb.SKU,
vtb.ClientSKU AS '自定义SKU',
vtb.FNSKU,
vtb.OrderSourceSKU AS 'SellSKU',
CASE
SellerType
WHEN 0 THEN '跟卖'
WHEN 1 THEN '自主上架'
ELSE ''
END AS '销售类型',
vtb.BusinessTeamName as '销售小组',
vtb.BusinessUserName as '销售人员',
vtb.AddAdminName as '上架人员',
case
vtb.OnShelfMode
when 1 then '一键上架'
when 2 then '草稿上架'
when 3 then '表格上架'
when 4 then '关联导入'
when 5 then '批量跟卖'
when 6 then '凤凰重刊'
end '上架方式',
vtb.AddTime as '记录时间',
vtb.PublishTime as '刊登时间',
REPLACE(vtb.ProductNameCN, ',', ';') AS '产品中文名称',
REPLACE(
ISNULL(
(
CASE
WHEN p.ClassID1 = p.ClassID
AND p.ClassID2 = 0 THEN c1.ClassNameCn
WHEN p.ClassID1 != p.ClassID2
AND p.ClassID = p.ClassID2 THEN c1.ClassNameCn + ' >> ' + c2.ClassNameCn
ELSE c1.ClassNameCn + ' >> ' + c2.ClassNameCn + ' >> ' + c3.ClassNameCn
END
),
''
),
',',
';'
) AS '完整中文类别',
CASE
WHEN vtb.IsFBA = 1 THEN (
CASE
WHEN vtb.FirstLegShippingType = 0 THEN '空运'
ELSE '海运'
END
)
ELSE ''
END as '默认运输方式',
wp.AddCycle AS '备货天数',
wp.HaulageTime AS '运输时间',
wp.SafetyDays AS '安全天数',
CASE
WHEN vtb.IsGroup = 1 THEN vtb.BuyTime
ELSE psb.ProcurementDay
END AS '采购天数',
vtb.LastSupplierPrice AS '采购单价',
cgzNum AS '采购中',
cgzNum * vtb.LastSupplierPrice AS '采购金额',
ystzNum AS '运输途中',
ystzNum * vtb.LastSupplierPrice AS '运输金额',
KykcNum AS '可用库存',
KykcNum * (
CASE
WHEN vtb.LastBuyPrice > 0 THEN vtb.LastBuyPrice
ELSE vtb.LastSupplierPrice
END
) AS '库存金额',
vtb.AvgDailySales AS '估算销量',
todaysaleNum AS '今天销量',
vtb.zsaleNum AS '昨天销量',
vtb.qsaleNum AS '前天销售',
vtb.sqsaleNum AS '上前销量',
WeekSaleNum AS '一周销量',
TwoWeekSaleNum AS '两周销量',
msaleNum AS '30天销量',
vtb.ThreeMonthSaleNum AS '90天销量',
rankNum AS '今天排名',
vtb.rankZTNum AS '昨天排名',
vtb.rankQTNum AS '前天排名',
vtb.rankSQNum AS '上前排名',
ReviewStar AS 'review评分',
ReviewNum AS 'review个数',
Kl AS '库龄',
zhanyong AS '占用资金',
ListingPrice AS '价格',
(KykcNum - vtb.LockNum) '当前库存',
vtb.CnKyNum '本地仓库存',
wp.WarningNum '预警库存',
vtb.FBA_Reserved_CustomerOrders as '购物车锁定',
vtb.FBA_Reserved_Transfers as '转仓库锁定',
vtb.FBA_Reserved_Processing as '入库中锁定',
(
CASE
vtb.IsFBA
WHEN 1 THEN (
CASE
WHEN vtb.AvgDailySales > 0 THEN CAST(KykcNum / vtb.AvgDailySales AS INT)
ELSE ''
END
)
WHEN 0 THEN ''
END
) AS '可卖天数',
vtb.ListingSoldNum '可售数量',
RIGHT(
convert(
nvarchar(8),
DATEADD(day, daysNum, GETDATE()),
112
),
4
) AS '预计售完日期',
CASE
ProductState
WHEN 0 THEN '正常'
WHEN 1 THEN '仅批量'
WHEN 2 THEN '停产'
WHEN 3 THEN '锁定'
WHEN 4 THEN '暂时缺货'
WHEN 5 THEN '清库'
END AS '产品状态',
CASE
WHEN pss.ProductVitalityType = 0 THEN '普通款'
WHEN pss.ProductVitalityType = 1 THEN '爆款'
WHEN pss.ProductVitalityType = 2 THEN '平款'
WHEN pss.ProductVitalityType = 3 THEN '旺款'
WHEN pss.ProductVitalityType = 4 THEN '滞销款'
ELSE ''
END '产品活跃度',
CASE
WHEN vtb.IsOffShelf = 0 THEN '在线'
WHEN vtb.IsOffShelf = 1 THEN '下架'
WHEN vtb.IsOffShelf = 2 THEN '售完'
WHEN vtb.IsOffShelf = 3 THEN '草稿'
WHEN vtb.IsOffShelf = 4 THEN '刊登中'
WHEN vtb.IsOffShelf = 5 THEN '刊登失败'
ELSE ''
END 'listing状态',
CASE
WHEN p.WithBattery = 0 THEN '未选择'
WHEN p.WithBattery = 1 THEN '普货'
WHEN p.WithBattery = 2 THEN '纯电池'
WHEN p.WithBattery = 3 THEN '带内置电池'
WHEN p.WithBattery = 4 THEN '带外置电池'
WHEN p.WithBattery = 5 THEN '含纽扣电池'
WHEN p.WithBattery = 6 THEN '液体'
WHEN p.WithBattery = 7 THEN '粉末'
WHEN p.WithBattery = 8 THEN '打火机'
WHEN p.WithBattery = 9 THEN '刀具_剪刀_仿真枪'
WHEN p.WithBattery = 10 THEN '带磁物品'
WHEN p.WithBattery = 11 THEN '其他禁运物品'
WHEN p.WithBattery = 12 THEN '木质类_竹质类'
WHEN p.WithBattery = 13 THEN '膏状'
WHEN p.WithBattery = 14 THEN '易碎'
WHEN p.WithBattery = 15 THEN '动物羽毛类'
WHEN p.WithBattery = 16 THEN '大功率电池'
WHEN p.WithBattery = 17 THEN '电子烟'
WHEN p.WithBattery = 18 THEN '移动电源'
WHEN p.WithBattery = 19 THEN '可拆卸电池'
WHEN p.WithBattery = 20 THEN '厨具'
WHEN p.WithBattery = 21 THEN '电机_马达'
WHEN p.WithBattery = 22 THEN '超体积普'
WHEN p.WithBattery = 23 THEN '超体积非普'
WHEN p.WithBattery = 24 THEN '手机'
WHEN p.WithBattery = 25 THEN '平衡车'
WHEN p.WithBattery = 26 THEN '液体笔类'
WHEN p.WithBattery = 27 THEN '纺织品'
WHEN p.WithBattery = 28 THEN '植物种子'
WHEN p.WithBattery = 29 THEN '深圳普货'
WHEN p.WithBattery = 30 THEN '成人用品'
WHEN p.WithBattery = 31 THEN '无'
WHEN p.WithBattery = 32 THEN '眼镜'
WHEN p.WithBattery = 33 THEN '口红'
WHEN p.WithBattery = 34 THEN '手表'
WHEN p.WithBattery = 35 THEN '香水'
WHEN p.WithBattery = 36 THEN '纯液体'
WHEN p.WithBattery = 37 THEN '医疗设备'
WHEN p.WithBattery = 38 THEN '人造羽毛'
ELSE ''
END AS '产品物流属性',
(
CASE
WHEN vtb.IsEFN = 1 THEN '是'
ELSE '否'
END
) AS '是否EFN产品',
isnull(vtb.UnsellableQuatity, 0) as '不可售数量',
ISNULL(vtb.RecommendedOrderQuantity, 0) as '平台建议补货数量',
ISNULL(vtb.MaximumShipmentQuantity, 0) as '最大货件数量',
ISNULL(vtb.OrderSourceSkuOrderTime, '') as '渠道SKU首单时间',
ISNULL(vtb.AsinOrderTime, '') as 'ASIN首单时间',
case
when ISNULL(vtb.ImageUrl, '') = '' then p.ImageUrl
else vtb.ImageUrl
end as '首图',
CASE
when vtb.IsNARF = 1 then '是'
else '否'
end as '是否NARF',
stuff(
(
select
',' + HolidaysName
from
(
select
sh.CustomerID,
ah.OrderSourceSKUID,
sh.HolidaysName
from
RB_SalesSactorHolidays (nolock) sh
inner join RB_Amazon_Holiday(nolock) ah on sh.CustomerID = ah.CustomerID
and sh.ID = ah.HolidayID
) t
where
CustomerID = vtb.CustomerID
and OrderSourceSKUID = vtb.OrderSourceSKUID for xml PATH('')
),
1,
1,
''
) as '节日标识'
FROM
RB_Amazon_Product_Base vtb (NOLOCK)
LEFT JOIN RB_StockClearDetailed scd (NOLOCK) ON (
vtb.OrderSourceSKUID = scd.ListId
AND vtb.CustomerID = scd.CustomerID
AND (
clearType = 1
OR clearType = 3
)
)
LEFT JOIN (
SELECT
SUM(GoodNum) AS Inventory,
WareHouseID,
SKU,
CustomerID
FROM
RB_WareHouse_Product (NOLOCK)
GROUP BY
WareHouseID,
SKU,
CustomerID
) AS tbWHN ON (
vtb.WID = tbWHN.WareHouseID
AND vtb.SKU = tbWHN.SKU
AND vtb.CustomerID = tbWHN.CustomerID
)
LEFT JOIN RB_OrderSource b ON vtb.CustomerID = b.CustomerID
AND vtb.OrderSourceID = b.ID
LEFT JOIN RB_Product p (NOLOCK) ON p.CustomerID = vtb.CustomerID
AND vtb.SKU = p.SKU
LEFT JOIN dbo.RB_Product_Class(NOLOCK) c1 ON c1.CustomerID = p.CustomerID
AND p.ClassID1 = c1.ID
LEFT JOIN dbo.RB_Product_Class(NOLOCK) c2 ON c2.CustomerID = p.CustomerID
AND p.ClassID2 = c2.ID
LEFT JOIN dbo.RB_Product_Class(NOLOCK) c3 ON c3.CustomerID = p.CustomerID
AND p.ClassID = c3.ID
LEFT JOIN RB_WareHouse wh (NOLOCK) ON wh.CustomerID = p.CustomerID
AND wh.ID = p.DefaultLocalWarehouse
LEFT JOIN RB_Product_SupplierPrice psb (NOLOCK) ON p.CustomerID = psb.CustomerID
AND p.SKU = psb.SKU
AND psb.IsDefault = 1
LEFT JOIN RB_Product_Supplier c (NOLOCK) ON psb.CustomerID = c.CustomerID
AND psb.SupplierID = c.ID
LEFT JOIN RB_WareHouse swh (NOLOCK) ON swh.CustomerID = c.CustomerID
AND swh.ID = c.TheWareHouseID
LEFT JOIN dbo.RB_Admin (NOLOCK) ON vtb.CustomerID = dbo.RB_Admin.CustomerID
AND b.SaleAdminID = dbo.RB_Admin.ID
AND dbo.RB_Admin.IsActive = 1
AND dbo.RB_Admin.IsLock = 0
LEFT JOIN RB_Product_Admin pa (NOLOCK) ON vtb.CustomerID = pa.CustomerID
AND vtb.SKU = pa.SKU
LEFT JOIN RB_WareHouse_Product wp (NOLOCK) ON wp.CustomerID = vtb.CustomerID
AND wp.ID = WPID
LEFT JOIN RB_SalesSactorHolidays sh (NOLOCK) ON sh.CustomerID = vtb.CustomerID
AND sh.ID = vtb.HolidaysID
LEFT JOIN RB_Customer_Setting setting (NOLOCK) ON setting.CustomerID = vtb.CustomerID
LEFT JOIN RB_Product_SalesStatus AS pss (NOLOCK) ON p.CustomerID = pss.CustomerID
AND p.SKU = pss.SKU
WHERE
vtb.CustomerID = @CustomerID
AND ISNULL(vtb.IsOffShelf, 0) = @IsOffShelf
AND vtb.OrderSourceSKUID > 0
and vtb.IsDelete = 0
AND vtb.AddTime >= @StartAddTime
AND vtb.AddTime <= @EndAddTime
AND 1=1
AND 1=1
AND 1=1
AND 1=1
AND 1=1
AND 1=1
AND 1=1
AND vtb.OrderSourceID IN (SELECT CONVERT(INT,item) FROM dbo.CharSplitForIn(@OrderSourceID,','))
AND 1=1
AND 1=1
AND 1=1
AND vtb.IsFBA = @IsFBA
AND 1=1
AND 1=1
AND 1=1
AND 1=1
AND 1=1
AND 1=1
AND 1=1
AND 1=1
AND 1=1
AND 1=1
AND 1=1
AND 1=1
and 1=1
and 1=1
and 1=1
PARAMS:@EndAddTime = 2023-03-23 23:59:59 ,@IsOffShelf = 0 ,@OrderSourceID = 0,8574,8544,8524,9976,9977,14672,12341,12201,12450,14694,15582,16173,15525,15373,15322,16158,6260,5779,5780,6405,6433,13547,17134,11827,12734,12815,13105,13138,14309,14967,15068,14583,14926,14512,14720,15003,15580,15658,15523,15371,15323,16177,16160,16653,16749,17274,17312,17262,17460,17310,17275,17276,17462,17461,17268,17271,17315,17463,17277,17270,17640,17319,17311,17266,17265,17464,17278,17267,17264,17313,17314,17269,17279,17280,17272,17465,17263,17273,17309,17918,17916,17466,17915,17914,17912,17910,17909,16750,10851,10852,10853,9886,9648,10854,9884,9885,10855,10860,11710,16425,10856,12588,10858,10859,10857,11702,17133,12216,14448,11553,13221,13224,13223,13222,15302,15286,15402,15433,16474,15359,16475,15301,15303,15812,15937,16478,15599,15600,16471,16470,16751,16767,5327,5325,5668,5766,6139,8260,6611,6943,7198,7364,7392,8093,8553,10250,9950,9849,9857,10056,10058,13331,10318,13470,11301,11826,12732,12813,13103,13136,13585,14306,14965,15066,14581,14924,14510,14718,15001,15578,15656,15521,15369,15318,16187,16170,16643,16739,5768,6055,6141,6613,6672,7157,7359,7376,7953,8095,8031,8555,8833,9021,9162,9167,9258,9447,9509,9851,9859,10294,10327,11215,11493,11602,11817,13291,12723,12804,13094,13127,13823,14427,14957,15224,14629,14916,14603,14937,15274,15570,15648,15513,15361,15310,16184,16167,16646,16742,5672,5770,6057,6143,6615,6674,7159,7361,7378,8097,8033,8557,8835,9023,9164,9169,9260,9449,9511,9853,9861,10295,10328,11216,11496,11605,11820,13294,12726,12807,13097,13130,13826,14430,14960,15227,14632,14919,14606,14940,15277,15573,15651,15516,15364,15313,16181,16164,16652,16745,5671,5769,6056,6142,6614,6673,7158,7360,7377,8096,8032,8556,8834,9022,9163,9168,9259,9448,9510,9852,9860,10296,10329,11217,11495,11604,11819,13293,12725,12806,13096,13129,13824,14429,14959,15226,14631,14918,14605,14939,15276,15572,15650,15515,15363,15312,16183,16166,16647,16744,5767,6054,6140,6612,6671,7156,7358,7375,8094,8030,8554,8832,9020,9161,9166,9257,9446,9508,9850,9858,10293,10326,11214,11338,11492,11601,11816,13290,12722,12803,13093,13126,13822,14426,14956,15223,14628,14915,14602,14936,15273,15569,15647,15512,15360,15309,16185,16168,16645,16741,12199,7175,7831,7832,7835,8390,8391,8403,12313,5673,5771,6058,6144,6616,6675,7160,7362,7379,8098,8034,8558,8836,9024,9165,9170,9261,9450,9512,9854,9862,10297,10330,11218,11494,11603,11818,13292,12724,12805,13095,13128,13825,14428,14958,15225,14630,14917,14604,14938,15275,15571,15649,15514,15362,15311,16179,16162,16648,16743,5679,5685,6381,8861,9789,12733,13137,14308,14592,9662,8428,6554,12085,10230,9661,8017,9572,10386,11399,16394,9663,10282,10709,10283,10285,10229,10284,13332,10710,13471,11302,11825,12731,12812,13102,13135,13586,14307,14966,15067,14582,14925,14511,14719,15002,15579,15657,15522,15370,15319,16186,16169,16644,16740,9534,9425,9047,9482,9535,9536,9624,9481,16122,10992,9426,10800,9423,10804,10801,10835,9679,10128,10095,9855,9863,10398,12129,11219,11498,11607,11822,13295,12729,12810,13100,13133,13829,14433,14963,15230,14633,14922,14607,14943,15280,15576,15654,15519,15367,15314,16182,16165,16649,16746,11134,11156,11168,17557,11169,11163,11135,11157,11167,11090,11158,11159,11188,12061,11160,11170,11154,11343,11161,11164,11166,17227,15557,11220,11497,11606,11821,16120,12727,12808,13098,13131,13827,14431,14961,15228,14634,14920,14608,14941,15278,15574,15652,15517,15365,15315,16178,16161,16651,16748,10187,13690,10970,10971,14693,15581,16172,15524,15372,15320,16174,16157,10717,10387,10567,17556,10355,10485,10525,10537,10356,11234,10365,12114,10357,12060,11344,11464,10994,11009,12082,10524,10538,17228,15558,11714,11499,11608,11823,16121,12728,12809,13099,13132,13828,14432,14962,15229,14635,14921,14609,14942,15279,15575,15653,15518,15366,15316,16180,16163,16650,16747,9920,9921,9922,9748,9704,9705,15583,15526,15374,15321,16176,16159,11596,11133,11548,17558,11622,11550,11594,11555,11194,11597,11556,13140,11595,11557,11552,11621,11549,11558,11554,11551,17226,12972,13169,12971,13168,13167,17795,18011,18008,15446,15451,16573,15448,15842,15447,15450,15454,15852,16405,16574,15375,15382,16396,16512,17229,5267,5269,5667,5765,6138,8259,6610,6942,7197,7363,7391,8131,10249,9949,9848,9856,10055,10057,13330,10317,13469,11296,11824,12730,12811,13101,13134,13584,14305,14964,15065,14580,14923,14509,14717,15000,15577,15655,15520,15368,15317,16188,16171,16642,16738 ,@IsFBA = 1 ,@CustomerId = 1 ,
MESSAGE:Must declare the scalar variable "@StartAddTime".
Incorrect syntax near the keyword 'AND'.
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.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
在 RB.DAL.DBOperator.ExecuteReader(String SQLString, SqlParameter[] cmdParms, Boolean IsWriteDB, Int32 Timeout) 在 RB.DAL.DBOperator.toCommonTipException(SqlException ex, String sql, SqlParameter[] cmdParms)
在 RB.DAL.DBOperator.ExecuteReader(String SQLString, SqlParameter[] cmdParms, Boolean IsWriteDB, Int32 Timeout)
在 Biz.Irobotbox.ReportCentre.CustomReportService.GetPageDataForCustomReportToSqlDataReader(String firstFileFullPath, RB_CustomReportTask customReportTask, String[] noPermsissionfields, Dictionary2 paramList, List1 exportFields, String orderBy, Int32 timeOut)
在 Biz.Irobotbox.ReportCentre.CustomReportService.ExportCSVBySteam(RB_CustomReportTask customReportTask, String[] noPermsissionfields, Dictionary2 paramValues, List1 exportFields, String orderField, Int32 timeOut)
在 Biz.Irobotbox.ReportCentre.CustomReportService.ExecuteCustomReportTask(List`1 customReportList)
在 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.Tasks.Schedulers.LimitedConcurrencyLevelTaskScheduler.b__6_0(Object _)
在 System.Threading.QueueUserWorkItemCallback.System.Threading.IThreadPoolWorkItem.ExecuteWorkItem()
在 System.Threading.ThreadPoolWorkQueue.Dispatch()