Copied to clipboard

Flag this post as spam?

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


  • RamaSagar 3 posts 73 karma points
    Nov 11, 2022 @ 09:08
    RamaSagar
    0

    Courier error while transferring content with umbraco version 7.12.4 and courier 3.1.6

    Hi All,

    I have a 2 websites test and staging running on Umbraco version 7.12.4. Top of it, courier version 3.1.6 is installed. Everything looks fine in terms of setup but when I try to transfer a media image or any other content. I get the below error:

    Deployment failed
    Deployment of content could not complete due to an unexpected error, all changes have been cancelled
    
    Unhandled exception occurred.Status: 500 Message: Internal Server Error</p><p>ExceptionType: System.Web.Services.Protocols.SoapException
    Message: Server was unable to process request. ---> Error extracting item, ID: cc07b313-0843-4aa8-bbda-871c8da728c8_d8e6ad84-e73a-11df-9492-0800200c9a66, Name: Image, Type: Umbraco.Courier.ItemProviders.DocumentType ---&gt; could not insert: [Umbraco.Courier.Persistence.V6.NHibernate.EntityClasses.UmbracoNode][SQL: INSERT INTO umbracoNode (createDate, level, nodeObjectType, path, sortOrder, text, trashed, uniqueID, nodeUser, parentID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?); select SCOPE_IDENTITY()] ---&gt; Cannot insert duplicate key row in object 'dbo.umbracoNode' with unique index 'IX_umbracoNodeUniqueID'. The duplicate key value is (cc07b313-0843-4aa8-bbda-871c8da728c8).
    The statement has been terminated. StackTrace: at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
       at System.Web.Services.Protocols.SoapHttpClientProtocol.EndInvoke(IAsyncResult asyncResult)
       at Umbraco.Courier.RepositoryProviders.WebServiceProvider.RepositoryWebservice.EndExtractItems(IAsyncResult asyncResult)
       at Umbraco.Courier.RepositoryProviders.CourierWebserviceRepositoryProvider.ExtractItems(Item[] items, Boolean overWrite)
       at Umbraco.Courier.Core.Extraction.RevisionExtraction.ExtractItems(List`1 nodes)
       at Umbraco.Courier.Core.Extraction.RevisionExtraction.ExtractReadyRevisionBatch()
       at Umbraco.Courier.Core.Extraction.RevisionExtraction.Extract()
       at Umbraco.Courier.Core.Tasks.ExtractionTask.Run()
       at Umbraco.Courier.Core.BackgroundTaskRunner`1.ConsumeTaskInternal(T task)
      End of stack trace from previous location where exception was thrown 
       at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
       at Umbraco.Courier.Core.TaskManager.GetSuccessfulProcessedTasks()
       at Umbraco.Courier.UI.Pages.ViewTaskManager.GetProcessed()
    
  • Mehmet Avcı 55 posts 240 karma points
    Nov 11, 2022 @ 14:24
    Mehmet Avcı
    1

    Hi RamaSagar,

    This usually happens when changes are done on both environments. It appears that UniqueId in umbracoNode table you have on the source env. has already been created at target env. for another node.

    Please check if that node are the same, if not, I would suggest a copy of db to synchronize values.

    Regards,

    Mehmet

  • RamaSagar 3 posts 73 karma points
    Nov 14, 2022 @ 17:18
    RamaSagar
    0

    Hi Mehmet,

    Thanks for the response. We have replicated the target env DB to the source env and gave a try again. But still the same

Please Sign in or register to post replies

Write your reply to:

Draft