[步骤]
content
:[13:45:53] -------------------------------------------------------------CODE:N1345537
Error:14_2627_1_-2146232060
SQL: drop table if exists #BrowseTreeNode;
create table #BrowseTreeNode(BrowsePathByID varchar(400) primary key);
insert into #BrowseTreeNode values
('2206275011,2206276011,2224199011,6647799011,6647802011,6647803011'), ('9482593011,9482594011,9756857011,9756921011,9756926011,9756928011'), ('3167641,3169011,3437522031,3437563031,3437563031'), (''), (''), ('57004031,57686031,2916060031,3305799031,2896360031,2896363031'), ('16295907031,16295908031,16473767031,16473815031,27931809031'), ('20658154031,20658155031,20852963031,20853063031,26968532031,26969162031'), ('20513023031,20513024031,20650182031,20650288031,26911133031'), (''), (''), ('12466667031,12466668031,13028017031,13028087031,13028471031'), ('16191000011,16191001011,17100533011,17100587011,17100838011,17100838011'), ('11497916031,11497917031,12148103031,12148167031,12148474031'), ('27157084031,27157085031,27897723031,27897816031,27898181031,27898181031') ; select alias.[ID],alias.[Country],alias.[BrowseNodeID],alias.[BrowseNodeName],alias.[BrowseNodeNameCn],alias.[BrowseNodeStoreContextName],alias.[BrowsePathByID],alias.[BrowsePathByName],alias.[HasChildren],alias.[ProductTypeDefinitions],alias.[ChildNodesCount],alias.[OID],alias.[TemplateUrl],alias.[TemplateName],alias.[ParentBrowsePathByID],alias.[IsBindTemplate],alias.[TemplateID],alias.[SupportVariation],alias.[IsEnabled],alias.[TemplateDownloadType],alias.[IsTranslate],alias.[AddTime],alias.[UpdateTime],alias.[AddAdminId],alias.[IsCollectioned],alias.[LastDownUpdateTime],alias.[LockGuid],alias.[ExecTime],alias.[IsReBind],alias.[BrowseNodeName_1],alias.[SkuCount],alias.[DeclarationCode] from E_Amazon_BrowseTree_Node_V2(nolock) alias inner join #BrowseTreeNode tbtn on CHARINDEX(alias.BrowsePathByID,tbtn.BrowsePathByID) = 1 where alias.IsEnabled = 1 and alias.BrowseNodeName in (N'Kategorien', N'Cat??gories', N'Categorie', N'カテゴリー別', N'Categor?-as', N'Categorías', N'Categories'); drop table if exists #BrowseTreeNode; PARAMS: MESSAGE:Violation of PRIMARY KEY constraint 'PK__#BrowseT__ED37C03EA32587F8'. Cannot insert duplicate key in object 'dbo.#BrowseTreeNode'. The duplicate key value is (). The statement has been terminated. 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.ExecuteReader(CommandBehavior behavior, String method) 在 System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) 在 System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) 在 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) 在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) 在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) 在 RB.DAL.DBOperator.Query(String SQLString, SqlCommand cmd, Int32 Times, SqlParameter[] cmdParms, Boolean IsWriteDB) 在 RB.DAL.DBOperator.toCommonTipException(SqlException ex, String sql, SqlParameter[] cmdParms) 在 RB.DAL.DBOperator.Query(String SQLString, SqlCommand cmd, Int32 Times, SqlParameter[] cmdParms, Boolean IsWriteDB) 在 RB.DALExtendV2.E_Amazon_BrowseTree_Node_V2ExtendV2.GetFirstBrowseTreeByIByBrowsePathByIDs(List`1 browsePathByIDs) 在 PandaBuy.ERP.Web.IrobotBox.Product.UploadAmazonProductV3.ErrorBrowseNodeCheck(List`1 orderSourceIDs, List`1 browseNodeIDs) 在 PandaBuy.ERP.Web.IrobotBox.Product.UploadAmazonProductV3.submit() 在 PandaBuy.ERP.Web.IrobotBox.Product.UploadAmazonProductV3.Page_Load(Object sender, EventArgs e) 在 System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) 在 System.EventHandler.Invoke(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_uploadamazonproductv3_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) 在 System.Web.Hosting.UnsafeIISMethods.MgdIndicateCompletion(IntPtr pHandler, RequestNotificationStatus& notificationStatus) 在 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)
[结果]
[期望]