Copied to clipboard

Flag this post as spam?

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


  • Alex Skrypnyk (skrypnyk.dev) 6070 posts 23408 karma points MVP 6x admin c-trib
    Nov 11, 2016 @ 15:14
    Alex Skrypnyk (skrypnyk.dev)
    0

    Crash on restoring content

    We are trying to restore our website locally from Umbraco Cloud, but when we downloading content we have error -

    An error occurred
    Error:  Error extracting item, ID: 43e40982-a71b-4037-9afa-10d4f24079a8_d8e6ad83-e73a-11df-9492-0800200c9a66, Name: item.dk, Type: Umbraco.Courier.ItemProviders.Document
    
    
    
    System.ApplicationException: Error extracting item, ID: 43e40982-a71b-4037-9afa-10d4f24079a8_d8e6ad83-e73a-11df-9492-0800200c9a66, Name: Home.dk, Type: Umbraco.Courier.ItemProviders.Document ---> NHibernate.Exceptions.GenericADOException: could not insert: [Umbraco.Courier.Persistence.V6.NHibernate.EntityClasses.CmsContent][SQL: INSERT INTO cmsContent (contentType, nodeId) VALUES (?, ?)] ---> System.Data.SqlServerCe.SqlCeException: The column cannot contain null values. [ Column name = contentType,Table name = cmsContent ]
       at System.Data.SqlServerCe.SqlCeCommand.ProcessResults(Int32 hr)
       at System.Data.SqlServerCe.SqlCeCommand.ExecuteCommandText(IntPtr& pCursor, Boolean& isBaseTableCursor)
       at System.Data.SqlServerCe.SqlCeCommand.ExecuteCommand(CommandBehavior behavior, String method, ResultSetOptions options)
       at System.Data.SqlServerCe.SqlCeCommand.ExecuteNonQuery()
       at NHibernate.AdoNet.AbstractBatcher.ExecuteNonQuery(IDbCommand cmd)
       at NHibernate.Id.Insert.AbstractSelectingDelegate.PerformInsert(SqlCommandInfo insertSQL, ISessionImplementor session, IBinder binder)
       --- End of inner exception stack trace ---
       at NHibernate.Id.Insert.AbstractSelectingDelegate.PerformInsert(SqlCommandInfo insertSQL, ISessionImplementor session, IBinder binder)
       at NHibernate.Persister.Entity.AbstractEntityPersister.Insert(Object[] fields, Boolean[] notNull, SqlCommandInfo sql, Object obj, ISessionImplementor session)
       at NHibernate.Persister.Entity.AbstractEntityPersister.Insert(Object[] fields, Object obj, ISessionImplementor session)
       at NHibernate.Action.EntityIdentityInsertAction.Execute()
       at NHibernate.Engine.ActionQueue.Execute(IExecutable executable)
       at NHibernate.Event.Default.AbstractSaveEventListener.PerformSaveOrReplicate(Object entity, EntityKey key, IEntityPersister persister, Boolean useIdentityColumn, Object anything, IEventSource source, Boolean requiresImmediateIdAccess)
       at NHibernate.Event.Default.AbstractSaveEventListener.PerformSave(Object entity, Object id, IEntityPersister persister, Boolean useIdentityColumn, Object anything, IEventSource source, Boolean requiresImmediateIdAccess)
       at NHibernate.Event.Default.AbstractSaveEventListener.SaveWithGeneratedId(Object entity, String entityName, Object anything, IEventSource source, Boolean requiresImmediateIdAccess)
       at NHibernate.Event.Default.DefaultSaveOrUpdateEventListener.SaveWithGeneratedOrRequestedId(SaveOrUpdateEvent event)
       at NHibernate.Event.Default.DefaultSaveEventListener.SaveWithGeneratedOrRequestedId(SaveOrUpdateEvent event)
       at NHibernate.Event.Default.DefaultSaveOrUpdateEventListener.EntityIsTransient(SaveOrUpdateEvent event)
       at NHibernate.Event.Default.DefaultSaveEventListener.PerformSaveOrUpdate(SaveOrUpdateEvent event)
       at NHibernate.Event.Default.DefaultSaveOrUpdateEventListener.OnSaveOrUpdate(SaveOrUpdateEvent event)
       at NHibernate.Impl.SessionImpl.FireSave(SaveOrUpdateEvent event)
       at NHibernate.Impl.SessionImpl.Save(Object obj)
       at Umbraco.Courier.Persistence.V6.NHibernate.Persisters.DocumentItem.PersistItem(Document item)
       at Umbraco.Courier.Core.ItemCrud`1.PersistItem[T1](T1 item)
       at Umbraco.Courier.Core.ItemCrudProvider.PersistItem[T](T item)
       at Umbraco.Courier.ItemProviders.DocumentItemProvider.HandleItemExtract(Document item)
       at Umbraco.Courier.Core.GenericItemProvider`1.HandleExtract(Item item)
       at Umbraco.Courier.Core.ItemProvider.Extract(Item item)
       --- End of inner exception stack trace ---
       at Umbraco.Courier.Core.ItemProvider.Extract(Item item)
       at Umbraco.Courier.RepositoryProviders.Local.ExtractItem(Item item, 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 Concorde.CacheHandler.Tasks.InitialExtractionTask.Run()
       at Umbraco.Courier.Core.BackgroundTaskRunner`1.ConsumeTaskInternal(T task)
    
  • Dennis Aaen 4495 posts 18201 karma points admin hq c-trib
    Nov 14, 2016 @ 20:04
    Dennis Aaen
    100

    Hi Alex,

    Are you still having the issue with restoring content?

    Please let me know then we will look more into this.

    Best,

    /Dennis

  • Alex Skrypnyk (skrypnyk.dev) 6070 posts 23408 karma points MVP 6x admin c-trib
    Nov 14, 2016 @ 21:07
    Alex Skrypnyk (skrypnyk.dev)
    0

    Hi Dennis,

    Thanks, you helped me when we talked in uaas chat.

    /Alex

  • Rodske 74 posts 104 karma points
    Dec 01, 2016 @ 22:12
    Rodske
    0

    How did you fix this? I have the same issue and need to get restore working. I have no idea how to investigate this further as the error is only:

    Error: Error extracting item, ID: 437e51fb-980b-474e-b335-accedd9ac670_d8e6ad83-e73a-11df-9492-0800200c9a66, Name: Broker Support, Type: Umbraco.Courier.ItemProviders.Document

    Details: System.ApplicationException: Error extracting item, ID: 437e51fb-980b-474e-b335-accedd9ac670_d8e6ad83-e73a-11df-9492-0800200c9a66, Name: Broker Support, Type: Umbraco.Courier.ItemProviders.Document ---> NHibernate.Exceptions.GenericADOException: could not insert: [Umbraco.Courier.Persistence.V6.NHibernate.EntityClasses.CmsContent][SQL: INSERT INTO cmsContent (contentType, nodeId) VALUES (?, ?)] ---> System.Data.SqlServerCe.SqlCeException: The column cannot contain null values. [ Column name = contentType,Table name = cmsContent ] at System.Data.SqlServerCe.SqlCeCommand.ProcessResults(Int32 hr) at System.Data.SqlServerCe.SqlCeCommand.ExecuteCommandText(IntPtr& pCursor, Boolean& isBaseTableCursor) at System.Data.SqlServerCe.SqlCeCommand.ExecuteCommand(CommandBehavior behavior, String method, ResultSetOptions options) at System.Data.SqlServerCe.SqlCeCommand.ExecuteNonQuery() at NHibernate.AdoNet.AbstractBatcher.ExecuteNonQuery(IDbCommand cmd) at NHibernate.Id.Insert.AbstractSelectingDelegate.PerformInsert(SqlCommandInfo insertSQL, ISessionImplementor session, IBinder binder) --- End of inner exception stack trace --- at

  • Anders Burla Johansen 2560 posts 8256 karma points
    Dec 12, 2016 @ 15:52
    Anders Burla Johansen
    0

    How was this fixed? Have same problem with a large site we have just started working with from a client.

    Kind regards

    Anders

  • Kenneth Solberg 227 posts 418 karma points
    Feb 14, 2017 @ 22:04
    Kenneth Solberg
    0

    Also got this. How did you fix it?

  • Anders Burla Johansen 2560 posts 8256 karma points
    Feb 15, 2017 @ 07:29
    Anders Burla Johansen
    0

    What version is your Umbraco on the Cloud? We never got the client working but Umbraco said it could be because the Umbraco version is pretty old. So an update is in process and hope that will help.

    Kind regards

    Anders

  • Kenneth Solberg 227 posts 418 karma points
    Feb 15, 2017 @ 07:51
    Kenneth Solberg
    0

    This is a brand new site I started yesterday.

  • Anders Burla Johansen 2560 posts 8256 karma points
    Feb 15, 2017 @ 08:02
    Anders Burla Johansen
    0

    Yeah - okay. That is properly a thing that Cloud support can help you with. Just write the support in the platform. Then maybe write the answer here so it help others at a later point :)

  • Kenneth Solberg 227 posts 418 karma points
    Feb 15, 2017 @ 08:07
    Kenneth Solberg
    0

    On it. Will update this thread with the result. I guess doing a clean setup of local dev will work, but I'd like to know if it's possible to solve the problem.

  • Alex Skrypnyk (skrypnyk.dev) 6070 posts 23408 karma points MVP 6x admin c-trib
    Feb 15, 2017 @ 10:40
    Alex Skrypnyk (skrypnyk.dev)
    0

    Hi

    Sometimes this problem can be fixed just by restarting the application. I hope this is your case.

    Thanks,

    Alex

  • Kenneth Solberg 227 posts 418 karma points
    Feb 15, 2017 @ 10:50
    Kenneth Solberg
    0

    Hi restarting the application did not solve the problem for me. I solved it by generating a new VS solution with UaaS.cmd as this site was pretty fresh anyways. Support suggested that I create all content, doctypes etc in local dev and push to live as this is the recommended workflow. I was not aware of that and had doctypes and templates created in live.

Please Sign in or register to post replies

Write your reply to:

Draft