数据库使用触发器日志报错

David.Zhong

本帖最后由 Joe.xu 于 2021-12-21 13:36 编辑

CurrentMethodName: InsertRowAndGetQueryInfoAsync
Tid:81 2021/12/2 10:49:15: Assembly: ForguncyDataAccess, Version=7.0.6.0, Culture=neutral, PublicKeyToken=967100671921c115 -----------
{
  "ClassName": "System.Data.SqlClient.SqlException",
  "Message": "如果 DML 语句包含不带 INTO 子句的 OUTPUT 子句，则该语句的目标表 'dbo.mes_ArrivalNoticeChild' 不能具有任何启用的触发器。",
  "Data": {
"$type": "System.Collections.ListDictionaryInternal, System.Private.CoreLib",
"HelpLink.ProdName": "Microsoft SQL Server",
"HelpLink.ProdVer": "15.00.2000",
"HelpLink.EvtSrc": "MSSQLServer",
"HelpLink.EvtID": "334",
"HelpLink.BaseHelpUrl": "https://go.microsoft.com/fwlink",
"HelpLink.LinkId": "20476",
"SqlError 1": "System.Data.SqlClient.SqlError: 如果 DML 语句包含不带 INTO 子句的 OUTPUT 子句，则该语句的目标表 'dbo.mes_ArrivalNoticeChild' 不能具有任何启用的触发器。"
  },
  "InnerException": null,
  "HelpURL": null,
  "StackTraceString": " at System.Data.SqlClient.SqlCommand.<>c.<ExecuteDbDataReaderAsync>b__126_0(Task`1 result)
at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke()
at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
--- End of stack trace from previous location where exception was thrown ---
at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot, Thread threadPoolThread)
--- End of stack trace from previous location where exception was thrown ---
at Forguncy.SqlServerDB.InsertRowAndGetQueryInfoAsync(DataRow masterRow, Dictionary`2 newValues, Dictionary`2 queryDic, String masterTableSchema, CommandExecutor executor, List`1 neededColumnNames, Dictionary`2 autoGenreatedIDInfos)",
  "RemoteStackTraceString": null,
  "RemoteStackIndex": 0,
  "ExceptionMethod": null,
  "HResult": -2146232060,
  "Source": "Core .Net SqlClient Data Provider",
  "WatsonBuckets": null,
  "Errors": null,
  "ClientConnectionId": "127c66e9-d752-45ca-a1fd-941d79229f54"
}