Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Angel 17 posts 38 karma points
    Feb 03, 2016 @ 16:10
    Angel
    1

    SQL error copying a document type in Umbraco 7

    I wanted to move (or say copy, since there is no way to 'move' a document type node) that currently existed under a master document type.

    I created a new document type which would be my master. I then right clicked on a current document type, selected copy, and then pointed to the newly created document type 'master'.

    I get the following error:

    Cannot insert duplicate key row in object 'dbo.cmsPropertyType' with unique index 'IX_cmsPropertyTypeUniqueID'. The duplicate key value is (f9a05dc0-d239-461f-81b3-b0db9545c98d). The statement has been terminated.

    [SqlException (0x80131904): Cannot insert duplicate key row in object 'dbo.cmsPropertyType' with unique index 'IXcmsPropertyTypeUniqueID'. The duplicate key value is (f9a05dc0-d239-461f-81b3-b0db9545c98d). The statement has been terminated.] System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) +1791910 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) +5347106 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +546 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) +1693 System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() +61 System.Data.SqlClient.SqlDataReader.getMetaData() +90 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +377 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) +1421 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource1 completion, Int32 timeout, Task& task, Boolean asyncWrite) +177 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +53 System.Data.SqlClient.SqlCommand.ExecuteScalar() +152 StackExchange.Profiling.Data.ProfiledDbCommand.ExecuteScalar() in c:\Code\github\SamSaffron\MiniProfiler\StackExchange.Profiling\Data\ProfiledDbCommand.cs:311 Umbraco.Core.Persistence.<>c__DisplayClassa.<ExecuteScalarWithRetry>b__9() +91 Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction(Func1 func) +332 Umbraco.Core.Persistence.PetaPocoCommandExtensions.ExecuteScalarWithRetry(IDbCommand command, RetryPolicy cmdRetryPolicy, RetryPolicy conRetryPolicy) +190 Umbraco.Core.Persistence.PetaPocoCommandExtensions.ExecuteScalarWithRetry(IDbCommand command, RetryPolicy retryPolicy) +137 Umbraco.Core.Persistence.PetaPocoCommandExtensions.ExecuteScalarWithRetry(IDbCommand command) +125 Umbraco.Core.Persistence.Database.Insert(String tableName, String primaryKeyName, Boolean autoIncrement, Object poco) +3169 Umbraco.Core.Persistence.Database.Insert(Object poco) +184 Umbraco.Core.Persistence.Repositories.ContentTypeBaseRepository1.PersistNewBaseContentType(ContentTypeDto dto, IContentTypeComposition entity) +4010 Umbraco.Core.Persistence.Repositories.ContentTypeRepository.PersistNewItem(IContentType entity) +421 Umbraco.Core.Cache.DefaultRepositoryCachePolicy2.CreateOrUpdate(TEntity entity, Action1 persistMethod) +452 Umbraco.Core.Persistence.Repositories.RepositoryBase2.PersistNewItem(IEntity entity) +387 Umbraco.Core.Persistence.UnitOfWork.PetaPocoUnitOfWork.Commit(Action`1 transactionCompleting) +198 Umbraco.Core.Persistence.UnitOfWork.PetaPocoUnitOfWork.Commit() +31 Umbraco.Core.Services.ContentTypeService.Save(IContentType contentType, Int32 userId) +275 Umbraco.Core.Services.ContentTypeService.Copy(IContentType original, String alias, String name, IContentType parent) +565 Umbraco.Core.Services.ContentTypeService.Copy(IContentType original, String alias, String name, Int32 parentId) +198 umbraco.dialogs.moveOrCopy.HandleDocumentTypeCopy() +361 umbraco.dialogs.moveOrCopy.HandleMoveOrCopy(Object sender, EventArgs e) +73 System.Web.UI.WebControls.Button.OnClick(EventArgs e) +9627718 System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +103 System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13 System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +9664310 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1724

    Is there a problem with copying document types in v7?

  • Jason 113 posts 628 karma points
    Feb 03, 2016 @ 16:54
    Jason
    0

    I ran into this issue also and was going to report it but got side track and forgot. So thanks for reminding me.

    http://issues.umbraco.org/issue/U4-7641

  • Edgar Rasquin 174 posts 467 karma points
    Feb 04, 2016 @ 13:26
    Edgar Rasquin
    0

    I am experiencing the same problem running Umbraco version 7.3.6 assembly: 1.0.5871.32302 with MS SQL Server 2012 on my local pc.

  • This forum is in read-only mode while we transition to the new forum.

    You can continue this topic on the new forum by tapping the "Continue discussion" link below.

Please Sign in or register to post replies