Sign in Register
Go to solution
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 6132 posts 23951 karma points MVP 7x admin c-trib
    Nov 11, 2016 @ 15:14
    Alex Skrypnyk
    0

    Crash on restoring content

    Umbraco Cloud
    Umbraco 7

    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)
    Copy Link
  • Dennis Aaen 4499 posts 18254 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

    Copy Link
  • Alex Skrypnyk 6132 posts 23951 karma points MVP 7x admin c-trib
    Nov 14, 2016 @ 21:07
    Alex Skrypnyk
    0

    Hi Dennis,

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

    /Alex

    Copy Link
  • 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

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

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

    Kind regards

    Anders

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

    Also got this. How did you fix it?

    Copy Link
  • Anders Burla 2560 posts 8256 karma points
    Feb 15, 2017 @ 07:29
    Anders Burla
    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

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

    This is a brand new site I started yesterday.

    Copy Link
  • Anders Burla 2560 posts 8256 karma points
    Feb 15, 2017 @ 08:02
    Anders Burla
    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 :)

    Copy Link
  • 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.

    Copy Link
  • Alex Skrypnyk 6132 posts 23951 karma points MVP 7x admin c-trib
    Feb 15, 2017 @ 10:40
    Alex Skrypnyk
    0

    Hi

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

    Thanks,

    Alex

    Copy Link
  • 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.

    Copy Link
Please Sign in or register to post replies

Write your reply to:

Draft