Hi, there.

I've been playing around Courier 2.5.4 for contents transfer. I uninstalled 2.1 and re-installed 2.5.4 that was grabbed from http://nightly.umbraco.org/UmbracoCourier/2.5.4/

All seemed to be working fine until I got the following error while I was trying to make a test package. It seems that SQL query is not working, even though I executed the query without an error on the MS SQL Server Management Studio, the script shows an error.

How can I figure this out? Could you let me know a solution, please?

The brief information of my website is:

• Umbraco 4.7.1 (not 4.7.1.1)
• Courier 2.5.4 (not 2.5.4.1)
• ASP.NET 4 on IIS 7.5 on Windows Server 2008 R2

Kind regards,

Justin

--

error:Umbraco.Courier.Core.Exceptions.PackageException: Unable to load item with id '62e84db3-c2d4-4fe1-a99c-1c4aff31046e' from provider 'PropertyData' ---> System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> NHibernate.Exceptions.GenericADOException: could not execute query
[ SELECT uniqueId from umbracoNode WHERE id = @p0 AND nodeObjecType = @p1 ]
  Name:id - Value:27594  Name:type - Value:c66ba18e-eaf3-4cff-8a22-41b16d66a972
[SQL: SELECT uniqueId from umbracoNode WHERE id = @p0 AND nodeObjecType = @p1] ---> System.Data.SqlClient.SqlException: Invalid column name 'nodeObjecType'.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
   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)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
   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.Loader.Loader.GetResultSet(IDbCommand st, Boolean autoDiscoverTypes, Boolean callable, RowSelection selection, ISessionImplementor session)
   at NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies)
   at NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies)
   at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters)
   --- End of inner exception stack trace ---
   at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters)
   at NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters)
   at NHibernate.Impl.SessionImpl.ListCustomQuery(ICustomQuery customQuery, QueryParameters queryParameters, IList results)
   at NHibernate.Impl.SessionImpl.List(NativeSQLQuerySpecification spec, QueryParameters queryParameters, IList results)
   at NHibernate.Impl.SessionImpl.List(NativeSQLQuerySpecification spec, QueryParameters queryParameters)
   at NHibernate.Impl.SqlQueryImpl.List()
   at NHibernate.Impl.AbstractQueryImpl.UniqueResult[T]()
   at Umbraco.Courier.Persistence.V4.NHibernate.NHibernateProvider.GetUniqueId(Int32 nodeId, Guid nodeObjectType) in c:\Program Files (x86)\teamcity\buildAgent\work\d94035a1177dda67\Umbraco.Courier.Persistence.NHibernate\NHibernate.cs:line 362
   at Umbraco.Courier.DataResolvers.ContentPicker.Packaging(Item item) in c:\Program Files (x86)\teamcity\buildAgent\work\d94035a1177dda67\Umbraco.Courier.DataResolvers\DataResolvers\ContentPicker.cs:line 102
   --- End of inner exception stack trace ---
   at System.RuntimeMethodHandle._InvokeMethodFast(IRuntimeMethodInfo method, Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeType typeOwner)
   at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks)
   at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
   at Umbraco.Courier.Core.ResolutionManager.(Item item, ItemEvent e, ItemProvider provider)
   at Umbraco.Courier.Core.ItemProvider.Package(ItemIdentifier id)
   at Umbraco.Courier.RepositoryProviders.Local.Package(ItemIdentifier itemId) in c:\Program Files (x86)\teamcity\buildAgent\work\d94035a1177dda67\Umbraco.Courier.RepositoryProviders\Local\Local.cs:line 225
   at Umbraco.Courier.Core.Packaging.RevisionPackaging.‡(ItemIdentifier itemId, ItemProvider provider, QueuedItemIdentifier itemInQueue)
   --- End of inner exception stack trace ---
   at Umbraco.Courier.Core.Packaging.RevisionPackaging.‡(ItemIdentifier itemId, ItemProvider provider, QueuedItemIdentifier itemInQueue)
   at Umbraco.Courier.Core.Packaging.RevisionPackaging.†()
   at Umbraco.Courier.Core.Packaging.RevisionPackaging.Package()
   at Umbraco.Courier.Core.TaskManager.(IRevisionTask value)
 5/14/2012 7:33:51 PM