[步骤]
[结果]
CODE:N1626042Error:16_207_1_-2146232060
SQL:insert into [RB_Amazon_FeedWithSellQueue]([CustomerID],[FeedSubmissionId],[OrderSourceID],[SKU],[OrderSourceSKU],[Product_ID],[Product_ID_Type],[Price],[Item_Condition],[Quantity],[AdminID],[AdminName],[IsSubmit],[SubmitNum],[Status],[AddTime],[UpdateTime],[Item_Note],[LeadtimeToShip],[Msg],[MerchantShippingGroupName],[MaximumRetailPric],[ClientSKU],[WithSellTime],[MessageCode],[FulfillmentCenterId]) values (@CustomerID,@FeedSubmissionId,@OrderSourceID,@SKU,@OrderSourceSKU,@Product_ID,@Product_ID_Type,@Price,@Item_Condition,@Quantity,@AdminID,@AdminName,@IsSubmit,@SubmitNum,@Status,@AddTime,@UpdateTime,@Item_Note,@LeadtimeToShip,@Msg,@MerchantShippingGroupName,@MaximumRetailPric,@ClientSKU,@WithSellTime,@MessageCode,@FulfillmentCenterId) ;select @@IDENTITY
PARAMS:@CustomerID = 1 ,@FeedSubmissionId = null ,@OrderSourceID = 25 ,@SKU = 1224491 ,@OrderSourceSKU = ce_24-25-1626041351 ,@Product_ID = 1 ,@Product_ID_Type = 4 ,@Price = 10 ,@Item_Condition = New ,@Quantity = 10 ,@AdminID = 1378 ,@AdminName = Irobotbox系统管理员 047 ,@IsSubmit = 0 ,@SubmitNum = 0 ,@Status = 0 ,@AddTime = 2022/6/7 16:26:04 ,@UpdateTime = null ,@Item_Note = 10 ,@LeadtimeToShip = 2 ,@Msg = null ,@MerchantShippingGroupName = 77 ,@MaximumRetailPric = AMAZON_NA ,@ClientSKU = ce_24 ,@WithSellTime = null ,@MessageCode = null ,@FulfillmentCenterId = DEFAULT ,
MESSAGE:列名 'FulfillmentCenterId' 无效。
TRACE: 在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
在 System.Data.SqlClient.SqlInternalConnection.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.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, TaskCompletionSource`1 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.ExecuteScalar()
在 RB.DAL.DBOperator.GetSingle(String SQLString, SqlCommand cmd, Int32 Times, SqlParameter[] cmdParms, Boolean IsWriteDB) 在 RB.DAL.DBOperator.toCommonTipException(SqlException ex, String sql, SqlParameter[] cmdParms)
在 RB.DAL.DBOperator.GetSingle(String SQLString, SqlCommand cmd, Int32 Times, SqlParameter[] cmdParms, Boolean IsWriteDB)
在 RB.DAL.DBOperator.GetSingle(String SQLString, SqlParameter[] cmdParms, Boolean IsWriteDB)
在 RB.DAL.RB_Amazon_FeedWithSellQueue.Add(RB_Amazon_FeedWithSellQueue model)
在 PandaBuy.ERP.Web.IrobotBox.SalesAnalysis.AmazonWithSellings.btnTxtSubmit_Click(Object sender, EventArgs e)
在 System.Web.UI.WebControls.Button.OnClick(EventArgs e)
在 System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)
在 System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)
在 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
在 System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
在 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
在 System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
在 System.Web.UI.Page.ProcessRequest()
在 System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context)
在 System.Web.UI.Page.ProcessRequest(HttpContext context)
在 ASP.irobotbox_salesanalysis_amazonwithsellings_aspx.ProcessRequest(HttpContext context)
在 System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
在 System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step)
在 System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
在 System.Web.HttpApplication.PipelineStepManager.ResumeSteps(Exception error)
在 System.Web.HttpApplication.BeginProcessRequestNotification(HttpContext context, AsyncCallback cb)
在 System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context)
在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)
在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)
-------------------------------------------------------------
[期望]
根据报错日志，直观看到报错信息