prometheus告警

            开始时间: 20:13:46 

            错误代码: N2013464  

            sql类型: DROP   

            sql: [20:13:46]  -------------------------------------------------------------

CODE:N2013464

Error:15_102_1_-2146232060

SQL: drop table if exists #tabBoxingList;

create table #tabBoxingList(id int primary key, IsSingleBox int);

insert into #tabBoxingList values ; UPDATE rop

SET rop.IsSingleBox = t.IsSingleBox

FROM RB_PackingBoxingList rop

INNER JOIN #tabBoxingList t

ON rop.ID = t.id

drop table if exists #tabBoxingList

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.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.DALExtendV2.RB_PackingBoxingListExtendV2.BatchUpdateIsSingleBox(List`1 models)

在 Biz.Irobotbox.ReStock.PackingBoxingService.CalculatePackingBoxSingleBox()

在 ChinaDownLoadImage.Task.Task_Restock_SetPackingBoxSingleBox.Execute()

在 RB.Utility.SystemTask.b__43_0()

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

---