Hey Ismail

The error points at a Macro Property, so you are trying to extract a macro (which was most likely on the template), so this is a guess, 

On the template, there is a macro, with some properties on, maybe the macro doesn't exist, or one of those properties has some broken data? 

(ofcourse courier should just be able to capture that silently, but seems in your case it breaks) 

/Per

Per,

I just created a new blank template that doesnt not inherit from anything.  The template just has the default content placeholder. When I attempt to right click courier that i still get same error.

"There was a problem with extracting database information for the item: Name:Test | Id:Test | Provider:Templates. Stacktrace: System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> NHibernate.AssertionFailure: null id in Umbraco.Courier.Persistence.V4.NHibernate.EntityClasses.UmbracoNode entry (don't flush the Session after an exception occurs) "

regards

Ismail

Hmm that sounds odd, could you get the .pdbs here:  http://nightly.umbraco.org/UmbracoCourier/Umbraco.Courier2_SymbolFiles.zip ;

So we can get some line numbers on when this happens

Per,

Uploaded the dlls I dont see any line numbers. I have attached a screen shot of the error.  It looks like its creating the package in app_data/courier on my source server.  However there seems to be an issue on the target server in getting and extracting that package.  Also what is the name of the table that courier installs? Looking at my db I dont see anything that looks like its related to courier.

Regards

Ismail

You might need the corresponding DLLs for those pdbs it seems: http://nightly.umbraco.org/UmbracoCourier/Umbraco.Courier2_manual_install.zip ;

(copy the /bin to your site) 

the courier table is called UCUserSettings

@Ismail, I think the table is called UCUserSettings. HAHA, beaten to it :P

Per,

The missing table is a red herring I do have table UCUserSettings.  Have deployed the bin dir in the zip and the full trace is 

 

'Extracting Test' was not completed, as it returned an error

 

Close this window

 

Recently processed tasks

Packaging

Packaging TestCompleted on: 17/11/2011 15:52:40

Extraction

Extracting TestUmbraco.Courier.Core.Exceptions.ExtractionManagerException: There was a problem with extracting database information for the item: Name:Test | Id:Test | Provider:Templates. Stacktrace: System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> null id in Umbraco.Courier.Persistence.V4.NHibernate.EntityClasses.UmbracoNode entry (don't flush the Session after an exception occurs) at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall) at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters) at Umbraco.Courier.RepositoryProviders.WebServiceProvider.RepositoryWebservice.Commit(String sessionKey, String username, String password) in c:\Program Files (x86)\teamcity\buildAgent\work\233db67f911c4288\Umbraco.Courier.RepositoryProviders\WebserviceProvider\webservice.cs:line 594 at Umbraco.Courier.RepositoryProviders.CourierWebserviceRepositoryProvider.Commit(String sessionKey) in c:\Program Files (x86)\teamcity\buildAgent\work\233db67f911c4288\Umbraco.Courier.RepositoryProviders\WebserviceProvider\CourierWebserviceRepositoryProvider.cs:line 416 at Umbraco.Courier.Core.Extraction.RevisionExtraction.Extract() ---> System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> null id in Umbraco.Courier.Persistence.V4.NHibernate.EntityClasses.UmbracoNode entry (don't flush the Session after an exception occurs) at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall) at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters) at Umbraco.Courier.RepositoryProviders.WebServiceProvider.RepositoryWebservice.Commit(String sessionKey, String username, String password) in c:\Program Files (x86)\teamcity\buildAgent\work\233db67f911c4288\Umbraco.Courier.RepositoryProviders\WebserviceProvider\webservice.cs:line 594 at Umbraco.Courier.RepositoryProviders.CourierWebserviceRepositoryProvider.Commit(String sessionKey) in c:\Program Files (x86)\teamcity\buildAgent\work\233db67f911c4288\Umbraco.Courier.RepositoryProviders\WebserviceProvider\CourierWebserviceRepositoryProvider.cs:line 416 at Umbraco.Courier.Core.Extraction.RevisionExtraction.Extract() --- End of inner exception stack trace --- at Umbraco.Courier.Core.Extraction.RevisionExtraction.Extract() at Umbraco.Courier.Core.Tasks.ExtractionTask.Run() at Umbraco.Courier.Core.TaskManager.(IRevisionTask value) 17/11/2011 15:52:44

 

Regards

Ismail

Thanks Ismail

I will work on this tomorrow to see why this happens. Is this a new install or could the database on one of those sites in anyway be corrupt? 

as it's acting really weird compared to those 1000s of testruns I've done :)

/Per

Per,

The website is fresh 4.7 install and courier 2.5 is fresh install so no upgrades on either.  If you want I can show you what I have via skype. I dont think its access issue as the 2 servers can see each other i.e when you create revision in one you can see it in the other. It just seems to be issue when it tries to extract. 

Regards

Ismail

Per,

Update on this I have turned on debugging and this is what i get in the log.txt

18/11/2011 10:09:21: Can't initialize provider 'Umbraco.Courier.Core.GenericItemProvider`1': System.ArgumentException: Cannot create an instance of Umbraco.Courier.Core.GenericItemProvider`1[T] because Type.ContainsGenericParameters is true.

   at System.RuntimeType.CreateInstanceCheckThis()

   at System.RuntimeType.CreateInstanceSlow(Boolean publicOnly, Boolean skipCheckThis, Boolean fillCache)

   at System.RuntimeType.CreateInstanceDefaultCtor(Boolean publicOnly, Boolean skipVisibilityChecks, Boolean skipCheckThis, Boolean fillCache)

   at System.Activator.CreateInstance(Type type, Boolean nonPublic)

   at Umbraco.Courier.Core.ProviderCollection`1.™(IEnumerable`1 types)

 

18/11/2011 10:09:27: Templatesfinding: Test

 

18/11/2011 10:09:30: Templatesfinding: Test

 

18/11/2011 10:09:31: Umbraco.Courier.DataResolvers.LocalLinks:ItemResolvers: Executing resolver Umbraco.Courier.DataResolvers.LocalLinks on Packaging event

 

18/11/2011 10:09:31: Umbraco.Courier.DataResolvers.TemplateResources:ItemResolvers: Executing resolver Umbraco.Courier.DataResolvers.TemplateResources on Packaging event

 

18/11/2011 10:09:31: Umbraco.Courier.DataResolvers.LocalLinks:ItemResolvers: Executing resolver Umbraco.Courier.DataResolvers.LocalLinks on Packaged event

 

18/11/2011 10:09:31: Umbraco.Courier.DataResolvers.LocalLinks:ItemResouceResolvers: Executing resouce resolver Umbraco.Courier.DataResolvers.LocalLinks on PackagingResource event, on resource: /masterpages/Test.master

 

18/11/2011 10:09:31: Umbraco.Courier.DataResolvers.MacroParameters:ItemResouceResolvers: Executing resouce resolver Umbraco.Courier.DataResolvers.MacroParameters on PackagingResource event, on resource: /masterpages/Test.master

 

18/11/2011 10:09:31: Umbraco.Courier.DataResolvers.TemplateResources:ItemResouceResolvers: Executing resouce resolver Umbraco.Courier.DataResolvers.TemplateResources on PackagingResource event, on resource: /masterpages/Test.master

 

18/11/2011 10:09:31: Looking up: D:\code\ATG\website\masterpages\Test.master

 

18/11/2011 10:09:31: Umbraco.Courier.DataResolvers.LocalLinks:ItemResouceResolvers: Executing resouce resolver Umbraco.Courier.DataResolvers.LocalLinks on PackagedResource event, on resource: /masterpages/Test.master

 

18/11/2011 10:09:31: Umbraco.Courier.DataResolvers.MacroParameters:ItemResouceResolvers: Executing resouce resolver Umbraco.Courier.DataResolvers.MacroParameters on PackagedResource event, on resource: /masterpages/Test.master

 

18/11/2011 10:09:31: Packaging Resource for macro parameters: /masterpages/Test.master

 

18/11/2011 10:09:31: Umbraco.Courier.DataResolvers.MacroParameters:ItemDataResolvers - MacroParameters: Replacing macros in string to guid:True

 

18/11/2011 10:09:31: Umbraco.Courier.DataResolvers.TemplateResources:ItemResouceResolvers: Executing resouce resolver Umbraco.Courier.DataResolvers.TemplateResources on PackagedResource event, on resource: /masterpages/Test.master

 

18/11/2011 10:09:46: Templatesfinding: Test

 

18/11/2011 10:09:46: Started extraction

 

18/11/2011 10:09:46: __6549ca37-2a79-49be-bfd5-92d7170351c2 ++ 1

 

18/11/2011 10:09:46: Umbraco.Courier.Core.Extraction.RevisionExtraction:BuildGraph: Adding 0 Items from provider: Folders

 

18/11/2011 10:09:46: Umbraco.Courier.Core.Extraction.RevisionExtraction:BuildGraph: Adding 0 Items from provider: Languages

 

18/11/2011 10:09:46: Umbraco.Courier.Core.Extraction.RevisionExtraction:BuildGraph: Adding 0 Items from provider: Files

 

18/11/2011 10:09:46: Umbraco.Courier.Core.Extraction.RevisionExtraction:BuildGraph: Adding 0 Items from provider: Dictionary items

 

18/11/2011 10:09:46: Umbraco.Courier.Core.Extraction.RevisionExtraction:BuildGraph: Adding 0 Items from provider: Stylesheets

 

18/11/2011 10:09:46: Umbraco.Courier.Core.Extraction.RevisionExtraction:BuildGraph: Adding 0 Items from provider: Tag Relations

 

18/11/2011 10:09:46: Umbraco.Courier.Core.Extraction.RevisionExtraction:BuildGraph: Adding 0 Items from provider: Datatypes

 

18/11/2011 10:09:46: Umbraco.Courier.Core.Extraction.RevisionExtraction:BuildGraph: Adding 0 Items from provider: Macros

 

18/11/2011 10:09:46: Umbraco.Courier.Core.Extraction.RevisionExtraction:BuildGraph: Adding 0 Items from provider: Relations

 

18/11/2011 10:09:46: Umbraco.Courier.Core.Extraction.RevisionExtraction:BuildGraph: Adding 0 Items from provider: Macro property types

 

18/11/2011 10:09:46: Umbraco.Courier.Core.Extraction.RevisionExtraction:BuildGraph: Adding 1 Items from provider: Templates

 

18/11/2011 10:09:46: Umbraco.Courier.Core.Extraction.RevisionExtraction:BuildGraph: Adding 0 Items from provider: Media types

 

18/11/2011 10:09:46: Umbraco.Courier.Core.Extraction.RevisionExtraction:BuildGraph: Adding 0 Items from provider: Media

 

18/11/2011 10:09:46: Umbraco.Courier.Core.Extraction.RevisionExtraction:BuildGraph: Adding 0 Items from provider: Document types

 

18/11/2011 10:09:46: Umbraco.Courier.Core.Extraction.RevisionExtraction:BuildGraph: Adding 0 Items from provider: Documents

 

18/11/2011 10:09:46: Umbraco.Courier.Core.Extraction.RevisionExtraction:BuildGraph: Adding 0 Items from provider: PropertyData

 

18/11/2011 10:09:46: Umbraco.Courier.RepositoryProviders.CourierWebserviceRepositoryProvider:ExtractRevisions: Session opening

 

18/11/2011 10:09:46: 1 items found ready

 

18/11/2011 10:09:46: Item: Test False

 

18/11/2011 10:09:47: Umbraco.Courier.RepositoryProviders.CourierWebserviceRepositoryProvider:ExtractionManager: System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> could not insert: [Umbraco.Courier.Persistence.V4.NHibernate.EntityClasses.UmbracoNode][SQL: INSERT INTO umbracoNode (createDate, level, nodeObjectType, path, sortOrder, text, trashed, uniqueID, nodeUser, parentID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?); select SCOPE_IDENTITY()] ---> Cannot insert the value NULL into column 'id', table 'atg-sandbox.dbo.umbracoNode'; column does not allow nulls. INSERT fails.

The statement has been terminated.

   at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)

   at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)

   at Umbraco.Courier.RepositoryProviders.WebServiceProvider.RepositoryWebservice.Extract(String sessionKey, Byte[] item, ItemIdentifier itemId, Boolean overwrite, String user, String pass) in c:\Program Files (x86)\teamcity\buildAgent\work\233db67f911c4288\Umbraco.Courier.RepositoryProviders\WebserviceProvider\webservice.cs:line 975

   at Umbraco.Courier.RepositoryProviders.CourierWebserviceRepositoryProvider.ExtractItem(Item item, Boolean overwrite) in c:\Program Files (x86)\teamcity\buildAgent\work\233db67f911c4288\Umbraco.Courier.RepositoryProviders\WebserviceProvider\CourierWebserviceRepositoryProvider.cs:line 212

 

18/11/2011 10:09:47: Umbraco.Courier.Core.Extraction.RevisionExtraction:extraction: Item extraction did not complete, status returned: Error

 

18/11/2011 10:09:47: Umbraco.Courier.RepositoryProviders.CourierWebserviceRepositoryProvider:ExtractRevisions: Committing changes

 

18/11/2011 10:09:47: Umbraco.Courier.RepositoryProviders.CourierWebserviceRepositoryProvider:ExtractRevisions: Rolling back changes

 

18/11/2011 10:09:47: Umbraco.Courier.RepositoryProviders.CourierWebserviceRepositoryProvider:ExtractRevisions: Session closed

 

18/11/2011 10:09:47: System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> null id in Umbraco.Courier.Persistence.V4.NHibernate.EntityClasses.UmbracoNode entry (don't flush the Session after an exception occurs)

   at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)

   at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)

   at Umbraco.Courier.RepositoryProviders.WebServiceProvider.RepositoryWebservice.Commit(String sessionKey, String username, String password) in c:\Program Files (x86)\teamcity\buildAgent\work\233db67f911c4288\Umbraco.Courier.RepositoryProviders\WebserviceProvider\webservice.cs:line 594

   at Umbraco.Courier.RepositoryProviders.CourierWebserviceRepositoryProvider.Commit(String sessionKey) in c:\Program Files (x86)\teamcity\buildAgent\work\233db67f911c4288\Umbraco.Courier.RepositoryProviders\WebserviceProvider\CourierWebserviceRepositoryProvider.cs:line 416

   at Umbraco.Courier.Core.Extraction.RevisionExtraction.Extract()

 

18/11/2011 10:09:47: Umbraco.Courier.Core.Exceptions.ExtractionManagerException: There was a problem with extracting database information for the item: Name:Test | Id:Test | Provider:Templates. Stacktrace: System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> null id in Umbraco.Courier.Persistence.V4.NHibernate.EntityClasses.UmbracoNode entry (don't flush the Session after an exception occurs)

   at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)

   at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)

   at Umbraco.Courier.RepositoryProviders.WebServiceProvider.RepositoryWebservice.Commit(String sessionKey, String username, String password) in c:\Program Files (x86)\teamcity\buildAgent\work\233db67f911c4288\Umbraco.Courier.RepositoryProviders\WebserviceProvider\webservice.cs:line 594

   at Umbraco.Courier.RepositoryProviders.CourierWebserviceRepositoryProvider.Commit(String sessionKey) in c:\Program Files (x86)\teamcity\buildAgent\work\233db67f911c4288\Umbraco.Courier.RepositoryProviders\WebserviceProvider\CourierWebserviceRepositoryProvider.cs:line 416

   at Umbraco.Courier.Core.Extraction.RevisionExtraction.Extract() ---> System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> null id in Umbraco.Courier.Persistence.V4.NHibernate.EntityClasses.UmbracoNode entry (don't flush the Session after an exception occurs)

   at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)

   at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)

   at Umbraco.Courier.RepositoryProviders.WebServiceProvider.RepositoryWebservice.Commit(String sessionKey, String username, String password) in c:\Program Files (x86)\teamcity\buildAgent\work\233db67f911c4288\Umbraco.Courier.RepositoryProviders\WebserviceProvider\webservice.cs:line 594

   at Umbraco.Courier.RepositoryProviders.CourierWebserviceRepositoryProvider.Commit(String sessionKey) in c:\Program Files (x86)\teamcity\buildAgent\work\233db67f911c4288\Umbraco.Courier.RepositoryProviders\WebserviceProvider\CourierWebserviceRepositoryProvider.cs:line 416

   at Umbraco.Courier.Core.Extraction.RevisionExtraction.Extract()

   --- End of inner exception stack trace ---

   at Umbraco.Courier.Core.Extraction.RevisionExtraction.Extract()

   at Umbraco.Courier.Core.Tasks.ExtractionTask.Run()

   at Umbraco.Courier.Core.TaskManager.(IRevisionTask value)

Regards

Ismail

 

 

Hi Ismail

Do you have any out of the ordinary windows settings (localization or similiar) and what are the specific website setup? 

Webserver, DB type, language etc

The issue is this sql statement generated by nhibernate: 

[Umbraco.Courier.Persistence.V4.NHibernate.EntityClasses.UmbracoNode][SQL: INSERT INTO umbracoNode (createDate, level, nodeObjectType, path, sortOrder, text, trashed, uniqueID, nodeUser, parentID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?); select SCOPE_IDENTITY()] ---> Cannot insert the value NULL into column 'id', table 'atg-sandbox.dbo.umbracoNode'; column does not allow nulls. INSERT fails.

have a look in /app_data/courier/revisions/ latest folder/ and have a look in the templates folder and paste the contents of the .courier file here

Per,

The server is win2k8 running on iis7.5 both websites on same server the db server is sql 2008 and both dbs are on same server as well locale will be en-GB.

 

The contents of the .courier file is

<?xml version="1.0" encoding="utf-8"?>

<Template xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">

  <CourierFileName>Test</CourierFileName>

  <Dependencies />

  <ItemId>

    <Id>Test</Id>

    <ProviderId>25867200-e67e-11df-9492-0800200c9a66</ProviderId>

  </ItemId>

  <Name>Test</Name>

  <ItemType>Item</ItemType>

  <Resources>

    <Resource>

      <ExtractToPath>/masterpages/Test.master</ExtractToPath>

      <Hash>e17b94919dd62248780aa44c60d3e3ef</Hash>

      <Name>/masterpages/Test.master</Name>

      <PackageFromPath>/masterpages/Test.master</PackageFromPath>

      <TemporaryStoragePath>/masterpages/Test.master</TemporaryStoragePath>

      <VirtualResource>false</VirtualResource>

      <NotFound>false</NotFound>

    </Resource>

  </Resources>

  <Alias>Test</Alias>

  <Design> </Design>

  <MasterPagePath>~/masterpages/Test.master</MasterPagePath>

  <ParentTemplateId>0</ParentTemplateId>

  <Id>13749</Id>

</Template>

Regards

 

Ismail

 

Per,

Ok issue resolved.  On the target server i tried to publish something and got same null error.  That got me thinking about how i cloned the db for the site. I create blank db then did import from existing db i suspect during this process some of the primary keys etc got munged.  I deleted the target db and recreated it from a backup of the source.  Then did transfer and it works.

Apologies for the time wasting.  Having now used it in anger all i can say is wow!!!

Regards

Ismail

Hi Ismail,

I have been getting the same error. What i am doing is that, i have created a package of the existing site using courier 2 in Revisions area and click transfer. The package gets transferred to the new umbraco build i.e. both umbraco builds are in 4.7.1. The destination is a fresh build. Now at destination when i click compare and install, i get this error message. Permissions and everything is just fine. I have also tried direct install and same error. But when i try Right click deplyment process it works and there is no error. But i don't like that much :(

I'm just a bit confused what could be the issue in my case. So if you came across any other solution or way out, plz do reply.

Thanks,

Rizwan

 

Rizwan, did you figure out how to resolve this issue? We have the exact same problem and can't figure out what's going on.

Thanks,

Phil

is working on a reply...