prometheus告警

            开始时间: 21:04:21 

            错误代码: N210421401  

            sql类型: DROP   

            sql: [21:04:21]  -------------------------------------------------------------

CODE:N210421401

Error:15_102_1_-2146232060

SQL: drop table if exists #BrowseTreeNode;

create table #BrowseTreeNode(BrowsePathByID varchar(400) primary key);

insert into #BrowseTreeNode values

; select alias.[ID],alias.[Country],alias.[BrowseNodeID],alias.[BrowseNodeName],alias.[BrowseNodeNameCn],alias.[BrowseNodeStoreContextName],alias.[BrowsePathByID],alias.[BrowsePathByName],alias.[HasChildren],alias.[ProductTypeDefinitions],alias.[ChildNodesCount],alias.[OID],alias.[TemplateUrl],alias.[TemplateName],alias.[ParentBrowsePathByID],alias.[IsBindTemplate],alias.[TemplateID],alias.[SupportVariation],alias.[IsEnabled],alias.[TemplateDownloadType],alias.[IsTranslate],alias.[AddTime],alias.[UpdateTime],alias.[AddAdminId],alias.[IsCollectioned],alias.[LastDownUpdateTime],alias.[LockGuid],alias.[ExecTime],alias.[IsReBind],alias.[BrowseNodeName_1],alias.[SkuCount],alias.[DeclarationCode] from E_Amazon_BrowseTree_Node_V2(nolock) alias inner join #BrowseTreeNode tbtn on CHARINDEX(alias.BrowsePathByID,tbtn.BrowsePathByID) = 1

where alias.IsEnabled = 1 and alias.BrowseNodeName in (N'Kategorien', N'Cat??gories', N'Categorie', N'カテゴリー別', N'Categor?-as', N'Categorías', N'Categories');

drop table if exists #BrowseTreeNode;

PARAMS:

MESSAGE:Incorrect syntax near ';'.

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.DALExtendV2.E_Amazon_BrowseTree_Node_V2ExtendV2.GetFirstBrowseTreeByIByBrowsePathByIDs(List1 browsePathByIDs) 在 Biz.Irobotbox.Amazon.Amazon_ErrorTask.FirstCategoryToBeExempted(RB_Amazon_ErrorTask_Queue queue) 在 Biz.Irobotbox.Amazon.Amazon_ErrorTask.<StructureErrorTask>b__0_0(RB_Amazon_ErrorTask_Queue queue) 在 System.Threading.Tasks.Parallel.<>c__DisplayClass17_01.b__1()

在 System.Threading.Tasks.Task.InnerInvokeWithArg(Task childTask)

在 System.Threading.Tasks.Task.<>c__DisplayClass176_0.b__0(Object )

在 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()

---