Problem with courier not updating when changing document type
Hey
I've recently started out a project using UaaS, and made a deployment to the Develop site.
But i have run into an issue where Courier is no longer updating the /data folder when i save something.
I can make changes to document types just fine. I can also save values and so forth.
Do you have any ideas what could cause this, and how do i go about debugging this?
I also have a different problem, although i am not sure if it's related or not.
Earlier it was possible for me to push changes to the Git repository, and Umbraco would create/update document types on Develop.
But now it does nothing when i deploy new changes to the .courier files, although Kudo tells me that deployment have been successful.
I cannot find anything related in the documentation, that i haven't tried. Including checking the Git repository on console.
Wait a minute, it seems like TFS is locking the existing data files.
When i check out the files for edit, they get updated.
So it seems like file rights.
I found this in the Courier trace log in the console on wwwroot:
2016-02-10 15:17:37,901 [5] ERROR Umbraco.Courier.Core.Extraction.RevisionExtraction - [Thread 30] There was a problem with extracting database information for the item: Name:Recipe Tag | Id:RecipeTag | Provider:Document types
NHibernate.Exceptions.GenericADOException: could not insert: [Umbraco.Courier.Persistence.V6.NHibernate.EntityClasses.CmsPropertyType][SQL: INSERT INTO cmsPropertyType (Alias, contentTypeId, dataTypeId, uniqueID, Description, mandatory, Name, sortOrder, validationRegExp, propertyTypeGroupId) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?); select SCOPEIDENTITY()] ---> System.Data.SqlClient.SqlException: Cannot insert duplicate key row in object 'dbo.cmsPropertyType' with unique index 'IXcmsPropertyTypeUniqueID'. The duplicate key value is (d624e953-8104-40be-b27b-a243802c943b).
The statement has been terminated.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
at NHibernate.AdoNet.AbstractBatcher.ExecuteReader(IDbCommand cmd)
at NHibernate.Id.IdentityGenerator.InsertSelectDelegate.ExecuteAndExtract(IDbCommand insert, ISessionImplementor session)
at NHibernate.Id.Insert.AbstractReturningDelegate.PerformInsert(SqlCommandInfo insertSQL, ISessionImplementor session, IBinder binder)
--- End of inner exception stack trace ---
at NHibernate.Id.Insert.AbstractReturningDelegate.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.DocumentTypeItem.PersistItem(DocumentType item)
at Umbraco.Courier.Core.ItemCrud1.PersistItem[T1](T1 item)
at Umbraco.Courier.Core.ItemCrudProvider.PersistItem[T](T item)
at Umbraco.Courier.ItemProviders.DocumentTypeItemProvider.HandleExtract(Item item)
at Umbraco.Courier.Core.ItemProvider.Extract(Item item)
at Umbraco.Courier.RepositoryProviders.Local.ExtractItem(Item item, Boolean overwrite)
at Umbraco.Courier.Core.Extraction.RevisionExtraction.ExtractItem(GraphNode node, Boolean isDependency)
at Umbraco.Courier.Core.Extraction.RevisionExtraction.ExtractReadyRevisionBatch()
at Umbraco.Courier.Core.Extraction.RevisionExtraction.ExtractReadyRevisionBatch()
at Umbraco.Courier.Core.Extraction.RevisionExtraction.Extract()
That pretty much looks like my problem, and now to solve it.
I tried clearing the data folder from the new additions, but now i am getting this:
2016-02-10 16:11:56,301 [56] ERROR Umbraco.Courier.Core.Extraction.RevisionExtraction - [Thread 71] There was a problem with extracting database information for the item: Name:Standard | Id:Standard | Provider:Templates
System.NullReferenceException: Object reference not set to an instance of an object.
at Umbraco.Courier.Persistence.V6.NHibernate.Persisters.DocumentTypeItem.PersistItem(DocumentType item)
at Umbraco.Courier.Core.ItemCrud`1.PersistItem[T1](T1 item)
at Umbraco.Courier.Core.ItemCrudProvider.PersistItem[T](T item)
at Umbraco.Courier.ItemProviders.DocumentTypeItemProvider.HandlePostProcess(Item item)
at Umbraco.Courier.Core.ItemProvider.PostProcess(Item item)
at Umbraco.Courier.RepositoryProviders.Local.PostProcess(Item item, Boolean overwrite)
at Umbraco.Courier.Core.Extraction.RevisionExtraction.PostProcessItem(GraphNode node, Boolean isDependency)
at Umbraco.Courier.Core.Extraction.RevisionExtraction.PostProcess()
at Umbraco.Courier.Core.Extraction.RevisionExtraction.Extract()
After i removed the faulty "Standard" document type, and re-added the courier files, my document types finally got added to Develop.
I am still not sure what the problem was which is kinda frightening.
Becuase if it happens to any other document type which is being used, i cannot just delete it.
Problem with courier not updating when changing document type
Hey
I've recently started out a project using UaaS, and made a deployment to the Develop site.
But i have run into an issue where Courier is no longer updating the /data folder when i save something.
I can make changes to document types just fine. I can also save values and so forth.
Do you have any ideas what could cause this, and how do i go about debugging this?
I also have a different problem, although i am not sure if it's related or not. Earlier it was possible for me to push changes to the Git repository, and Umbraco would create/update document types on Develop.
But now it does nothing when i deploy new changes to the .courier files, although Kudo tells me that deployment have been successful.
I cannot find anything related in the documentation, that i haven't tried. Including checking the Git repository on console.
Kind regards,
Mathias
Wait a minute, it seems like TFS is locking the existing data files. When i check out the files for edit, they get updated. So it seems like file rights.
I will try another deploy to Develop.
Nope, the deployment part still doesn't work out. Is there something that i am missing?
As far as i can tell from the documentation, deploying the courier files should update the Umbraco on develop automaticly, right?..
I found this in the Courier trace log in the console on wwwroot:
NHibernate.Exceptions.GenericADOException: could not insert: [Umbraco.Courier.Persistence.V6.NHibernate.EntityClasses.CmsPropertyType][SQL: INSERT INTO cmsPropertyType (Alias, contentTypeId, dataTypeId, uniqueID, Description, mandatory, Name, sortOrder, validationRegExp, propertyTypeGroupId) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?); select SCOPEIDENTITY()] ---> System.Data.SqlClient.SqlException: Cannot insert duplicate key row in object 'dbo.cmsPropertyType' with unique index 'IXcmsPropertyTypeUniqueID'. The duplicate key value is (d624e953-8104-40be-b27b-a243802c943b). The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action
1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource1 completion, Int32 timeout, Task& task, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader() at NHibernate.AdoNet.AbstractBatcher.ExecuteReader(IDbCommand cmd) at NHibernate.Id.IdentityGenerator.InsertSelectDelegate.ExecuteAndExtract(IDbCommand insert, ISessionImplementor session) at NHibernate.Id.Insert.AbstractReturningDelegate.PerformInsert(SqlCommandInfo insertSQL, ISessionImplementor session, IBinder binder) --- End of inner exception stack trace --- at NHibernate.Id.Insert.AbstractReturningDelegate.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.DocumentTypeItem.PersistItem(DocumentType item) at Umbraco.Courier.Core.ItemCrud1.PersistItem[T1](T1 item) at Umbraco.Courier.Core.ItemCrudProvider.PersistItem[T](T item) at Umbraco.Courier.ItemProviders.DocumentTypeItemProvider.HandleExtract(Item item) at Umbraco.Courier.Core.ItemProvider.Extract(Item item) at Umbraco.Courier.RepositoryProviders.Local.ExtractItem(Item item, Boolean overwrite) at Umbraco.Courier.Core.Extraction.RevisionExtraction.ExtractItem(GraphNode node, Boolean isDependency) at Umbraco.Courier.Core.Extraction.RevisionExtraction.ExtractReadyRevisionBatch() at Umbraco.Courier.Core.Extraction.RevisionExtraction.ExtractReadyRevisionBatch() at Umbraco.Courier.Core.Extraction.RevisionExtraction.Extract()That pretty much looks like my problem, and now to solve it.
I tried clearing the data folder from the new additions, but now i am getting this:
2016-02-10 16:11:56,301 [56] ERROR Umbraco.Courier.Core.Extraction.RevisionExtraction - [Thread 71] There was a problem with extracting database information for the item: Name:Standard | Id:Standard | Provider:Templates System.NullReferenceException: Object reference not set to an instance of an object. at Umbraco.Courier.Persistence.V6.NHibernate.Persisters.DocumentTypeItem.PersistItem(DocumentType item) at Umbraco.Courier.Core.ItemCrud`1.PersistItem[T1](T1 item) at Umbraco.Courier.Core.ItemCrudProvider.PersistItem[T](T item) at Umbraco.Courier.ItemProviders.DocumentTypeItemProvider.HandlePostProcess(Item item) at Umbraco.Courier.Core.ItemProvider.PostProcess(Item item) at Umbraco.Courier.RepositoryProviders.Local.PostProcess(Item item, Boolean overwrite) at Umbraco.Courier.Core.Extraction.RevisionExtraction.PostProcessItem(GraphNode node, Boolean isDependency) at Umbraco.Courier.Core.Extraction.RevisionExtraction.PostProcess() at Umbraco.Courier.Core.Extraction.RevisionExtraction.Extract()
Not sure if i solved the other thing though...
After i removed the faulty "Standard" document type, and re-added the courier files, my document types finally got added to Develop.
I am still not sure what the problem was which is kinda frightening. Becuase if it happens to any other document type which is being used, i cannot just delete it.
is working on a reply...