prometheus告警
开始时间: 15:38:15
错误代码: N1538151
sql类型: DROP
sql: [15:38:15] -------------------------------------------------------------
CODE:N1538151
Error:15_137_2_-2146232060
SQL:DROP TABLE IF EXISTS #TempAddDevelopmentSkus;
-- 创建临时表 #TempAddDevelopmentSkus 开发人员系统SKU临时表
CREATE TABLE #TempAddDevelopmentSkus
(
ID [INT] NOT NULL IDENTITY(1, 1),
CustomerID INT,
SKU VARCHAR(20) COLLATE Chinese_PRC_CI_AS,
DevelopType INT NOT NULL,
AddAdminId INT NOT NULL,
AddAdminName NVARCHAR(200),
--DepartmentID INT NOT NULL,
--DepartmentName NVARCHAR(200),
OnlineTime DATETIME
);
INSERT INTO #TempAddDevelopmentSkus
SELECT pdl.CustomerID,
tp.SKU,
tp.DevelopType,
pdl.AddAdminId,
pdl.AddAdminName,
--dept.ID AS DepartmentID,
--dept.DepartmentName,
MAX(tp.OnlineTime) AS 'OnlineTime'
FROM RB_Product_Development (NOLOCK) pdl
INNER JOIN RB_ProductDevelopment_Related_Product (NOLOCK) prp
ON pdl.Id = prp.ProductDevelopmentId
AND pdl.CustomerID = prp.CustomerID
INNER JOIN
(
SELECT p.DevelopType,
p.SKU,
p.CustomerID,
pa.OnlineTime
FROM dbo.RB_Product (NOLOCK) p
INNER JOIN RB_Product_Admin (NOLOCK) pa
ON p.CustomerID = pa.CustomerID
AND p.SKU = pa.SKU
WHERE p.CustomerID = @CustomerID
AND DeleteStatus = 0 --未删除
AND ProductProperty IN ( 1, 3 ) --1 非侵权 3 灰色产品
AND DevelopType IN ( 3, 5 ) --3 指定开发 5 销售提报 _FBA新品
AND ProductState IN ( 0, 1, 2, 4, 5 ) --排除停产
AND pa.CheckStatus = 1 --终审通过
AND pa.OnlineTime >= @StartTime
AND pa.OnlineTime < @EndTime
) tp
ON tp.CustomerID = pdl.CustomerID
AND tp.SKU = prp.SKU
INNER JOIN dbo.RB_Admin (NOLOCK) ra
ON ra.CustomerID = pdl.CustomerID
AND ra.ID = pdl.AddAdminId
WHERE 1=1
GROUP BY t.CustomerID,
bt.BusinessTeamName,
t.产品提报类型;
PARAMS:@Auth_AdminID = 0,100073,100084,663,846,928,1113,1154,1364,1443,1483,1482,1839,2114,2909,3676,3445,100229,7610,7810,7935,8259,8553,8689,9293,981,1118,1842,2001,2529,2904,3267,3284,3498,3523,3626,3694,3762,3910,4595,5060,5162,5253,5327,5647,5806,5828,5849,5850,5905,6017,6888,6939,7107,7158,100230,7587,7918,7953,8023,8463,8711,1151,1550,1827,1893,2828,2940,3006,3316,3370,3382,3464,3478,3916,4096,5142,5144,5650,5999,6150,6396,6840,7067,7458,100458,8931,2603,3117,3558,3564,4033,4062,4593,4872,5128,5799,5802,5891,5910,6334,6356,6779,6850,100486,7714,9139,1334,2113,4035,4597,4816,4933,5122,5331,5345,5414,5648,5649,6186,6858,7186,7442,100554,8457,8998,9200,9284,2135,3436,4515,5646,6187,6329,7284,100555,7794,9061,4592,6068,6194,6423,6646,6812,6831,7182 ,@CustomerId = 1 ,
MESSAGE:Must declare the scalar variable "@StartTime".
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()
应该是报表组那边的问题