[步骤]
CODE:N15045624
Error:16_8003_1_-2146232060
SQL:
INSERT INTO [dbo].[RB_Amazon_Product_Base_Brand] ([CustomerID],[OrderSourceSKUID],[Asin],[BrandName],[IsFba],[AddTime],[UpdateTime])
VALUES (@CustomerID,@OrderSourceSKUID_1,@Asin_1,@BrandName_1,0,GETDATE(),GETDATE());
INSERT INTO [dbo].[RB_Amazon_Product_Base_Brand] ([CustomerID],[OrderSourceSKUID],[Asin],[BrandName],[IsFba],[AddTime],[UpdateTime])
VALUES (@CustomerID,@OrderSourceSKUID_2,@Asin_2,@BrandName_2,0,GETDATE(),GETDATE());
INSERT INTO [dbo].[RB_Amazon_Product_Base_Brand] ([CustomerID],[OrderSourceSKUID],[Asin],[BrandName],[IsFba],[AddTime],[UpdateTime])
VALUES (@CustomerID,@OrderSourceSKUID_3,@Asin_3,@BrandName_3,0,GETDATE(),GETDATE());
INSERT INTO [dbo].[RB_Amazon_Product_Base_Brand] ([CustomerID],[OrderSourceSKUID],[Asin],[BrandName],[IsFba],[AddTime],[UpdateTime])
VALUES (@CustomerID,@OrderSourceSKUID_4,@Asin_4,@BrandName_4,0,GETDATE(),GETDATE());
INSERT INTO [dbo].[RB_Amazon_Product_Base_Brand] ([CustomerID],[OrderSourceSKUID],[Asin],[BrandName],[IsFba],[AddTime],[UpdateTime])
VALUES (@CustomerID,@OrderSourceSKUID_5,@Asin_5,@BrandName_5,0,GETDATE(),GETDATE());
INSERT INTO [dbo].[RB_Amazon_Product_Base_Brand] ([CustomerID],[OrderSourceSKUID],[Asin],[BrandName],[IsFba],[AddTime],[UpdateTime])
VALUES (@CustomerID,@OrderSourceSKUID_6,@Asin_6,@BrandName_6,0,GETDATE(),GETDATE());
INSERT INTO [dbo].[RB_Amazon_Product_Base_Brand] ([CustomerID],[OrderSourceSKUID],[Asin],[BrandName],[IsFba],[AddTime],[UpdateTime])
VALUES (@CustomerID,@OrderSourceSKUID_7,@Asin_7,@BrandName_7,0,GETDATE(),GETDATE());
INSERT INTO [dbo].[RB_Amazon_Product_Base_Brand] ([CustomerID],[OrderSourceSKUID],[Asin],[BrandName],[IsFba],[AddTime],[UpdateTime])
VALUES (@CustomerID,@OrderSourceSKUID_8,@Asin_8,@BrandName_8,0,GETDATE(),GETDATE());
INSERT INTO [dbo].[RB_Amazon_Product_Base_Brand] ([CustomerID],[OrderSourceSKUID],[Asin],[BrandName],[IsFba],[AddTime],[UpdateTime])
VALUES (@CustomerID,@OrderSourceSKUID_9,@Asin_9,@BrandName_9,0,GETDATE(),GETDATE());
INSERT INTO [dbo].[RB_Amazon_Product_Base_Brand] ([CustomerID],[OrderSourceSKUID],[Asin],[BrandName],[IsFba],[AddTime],[UpdateTime])
VALUES (@CustomerID,@OrderSourceSKUID_10,@Asin_10,@BrandName_10,0,GETDATE(),GETDATE());
INSERT INTO [dbo].[RB_Amazon_Product_Base_Brand] ([CustomerID],[OrderSourceSKUID],[Asin],[BrandName],[IsFba],[AddTime],[UpdateTime])
B0CBSVZM63 ,@BrandName_1579 = Uonlytech ,
MESSAGE:The incoming request has too many parameters. The server supports a maximum of 2100 parameters. Reduce the number of parameters and resend the request.
TRACE: 在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) 在 System.Data.SqlClient.SqlInternalConnection.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.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.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.DAL.DBOperator.ExecuteSql(String SQLString, SqlParameter[] cmdParms)
在 Biz.product.ProductVideoService.ImportToCreateProductVideo(ICollection1 imports, Int32 customerId, Int32 adminId, String userName, Action1 logTime)
在 PandaBuy.ERP.Web.IrobotBox.Product.ProductVideo.ProductVideoExport.DoUpload()
在 PandaBuy.ERP.Web.IrobotBox.Product.ProductVideo.ProductVideoExport.Page_Load(Object sender, EventArgs e)
在 System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e)
在 System.Web.UI.Control.OnLoad(EventArgs e)
在 System.Web.UI.Control.LoadRecursive()
在 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_product_productvideo_productvideoexport_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)
[结果]
[期望]
修复 SQL 异常
不是这边的业务,找其他组看看。