[步骤]
[00:39:32] -------------------------------------------------------------
CODE:N00393218
Error:16_515_2_-2146232060
SQL:update [RB_OrderInfo] set [FirstName] = @FirstName_1 , [LastName] = @LastName_1, [Country] = @Country_1, [District] = @District_1 , [Province] = @Province_1 , [City] = @City_1 , [CompanyName] = @CompanyName_1, [PostCode] = @PostCode_1, [Telephone] = @Telephone_1 , [Email] = @Email_1 , [Address] = @Address_1 , [Address1] = @Address1_1 , [Address2] = @Address2_1, [Address3] = @Address3_1, [OrderStatus] = @OrderStatus_1 where ID=@ID_1;
PARAMS:@FirstName_1 = ,@LastName_1 = ,@Country_1 = null ,@District_1 = ,@Province_1 = ,@City_1 = ,@CompanyName_1 = ,@PostCode_1 = ,@Telephone_1 = ,@Email_1 = ,@Address_1 = ,@Address1_1 = ,@Address2_1 = ,@Address3_1 = ,@OrderStatus_1 = 0 ,@ID_1 = 227677184 ,
MESSAGE:Cannot insert the value NULL into column 'Country', table 'irobotbox.dbo.RB_OrderInfo'; column does not allow nulls. UPDATE fails.
The statement has been terminated.
TRACE: 在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 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.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, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
在 System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 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.DALExtendV3.RB_OrderInfoExtendV3.BatchUpdateAddresss(List`1 models)
在 Biz.Irobotbox.Temu.TemuService.TemuSemiAddressData()
在 ChinaDownLoadImage.Task.Temu.Task_TemuSemi_SyncAddress.Execute()
在 RB.Utility.SystemTask.<doTask>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()
-------------------------------------------------------------
[结果]
[期望]
修复 错误
采集地址有异常 已处理异常数据 异常数据检验过滤代码已提交