I need a help, with a case. Recently, I upgrade Umbraco version and Courier version. And now I have the following error, and in all moment:
Somebody, please. Could Help me?
Error during packaging:
error:Umbraco.Courier.Core.Exceptions.PackageException:
Unable to load item with id '[XSLT]SecurityCertificatesScripts' from
provider 'Macros' --->
Umbraco.Courier.Core.Exceptions.RetrieveException: Error retrieving item
[[XSLT]SecurityCertificatesScripts] from provider
[2ab40e30-e292-11df-85ca-0800200c9a66]. --->
NHibernate.Exceptions.GenericADOException: could not execute query
[ SELECT this_.id as id32218_0_, this_.macroAlias as macroAlias32218_0_,
this_.macroCacheByPage as macroCac3_32218_0_,
this_.macroCachePersonalized as macroCac4_32218_0_,
this_.macroDontRender as macroDon5_32218_0_, this_.macroName as
macroName32218_0_, this_.macroPython as macroPyt7_32218_0_,
this_.macroRefreshRate as macroRef8_32218_0_, this_.macroScriptAssembly
as macroScr9_32218_0_, this_.macroScriptType as macroSc10_32218_0_,
this_.macroUseInEditor as macroUs11_32218_0_, this_.macroXSLT as
macroXSLT32218_0_ FROM cmsMacro this_ WHERE this_.macroAlias = ? ]
Positional parameters: #0>[XSLT]SecurityCertificatesScripts
[SQL: SELECT this_.id as id32218_0_, this_.macroAlias as
macroAlias32218_0_, this_.macroCacheByPage as macroCac3_32218_0_,
this_.macroCachePersonalized as macroCac4_32218_0_,
this_.macroDontRender as macroDon5_32218_0_, this_.macroName as
macroName32218_0_, this_.macroPython as macroPyt7_32218_0_,
this_.macroRefreshRate as macroRef8_32218_0_, this_.macroScriptAssembly
as macroScr9_32218_0_, this_.macroScriptType as macroSc10_32218_0_,
this_.macroUseInEditor as macroUs11_32218_0_, this_.macroXSLT as
macroXSLT32218_0_ FROM cmsMacro this_ WHERE this_.macroAlias = ?]
---> System.NullReferenceException: Object reference not set to an
instance of an object.
at NHibernate.AdoNet.AbstractBatcher.CheckReaders()
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.Loader.Criteria.CriteriaLoader.List(ISessionImplementor
session)
at NHibernate.Impl.SessionImpl.List(CriteriaImpl criteria, IList
results)
at NHibernate.Impl.CriteriaImpl.List(IList results)
at NHibernate.Impl.CriteriaImpl.List[T]()
at
Umbraco.Courier.Persistence.V6.NHibernate.Persisters.MacroItem.RetrieveItem[T](ItemIdentifier
itemId) in c:\Program Files
(x86)\teamcity\buildAgent\work\650bafc4b83aa858\Core\Umbraco.Courier.Persistence.V6.NHibernate\Persisters\Macro.cs:line
61
at
Umbraco.Courier.Core.ItemCrudProvider.RetrieveItem[T](ItemIdentifier
itemId)
--- End of inner exception stack trace ---
at
Umbraco.Courier.Core.ItemCrudProvider.RetrieveItem[T](ItemIdentifier
itemId)
at
Umbraco.Courier.ItemProviders.MacroItemProvider.HandlePack(ItemIdentifier
id)
at Umbraco.Courier.Core.ItemProvider.Package(ItemIdentifier id)
at Umbraco.Courier.RepositoryProviders.Local.Package(ItemIdentifier
itemId)
at
Umbraco.Courier.Core.Packaging.RevisionPackaging.PackageItem(ItemIdentifier
itemId, ItemProvider provider, QueuedItemIdentifier itemInQueue)
--- End of inner exception stack trace ---
at
Umbraco.Courier.Core.Packaging.RevisionPackaging.PackageItem(ItemIdentifier
itemId, ItemProvider provider, QueuedItemIdentifier itemInQueue)
at Umbraco.Courier.Core.Packaging.RevisionPackaging.PackageBatch()
at Umbraco.Courier.Core.Packaging.RevisionPackaging.PackageBatch()
at Umbraco.Courier.Core.Packaging.RevisionPackaging.PackageBatch()
at Umbraco.Courier.Core.Packaging.RevisionPackaging.PackageBatch()
at Umbraco.Courier.Core.Packaging.RevisionPackaging.PackageBatch()
at Umbraco.Courier.Core.Packaging.RevisionPackaging.PackageBatch()
at Umbraco.Courier.Core.Packaging.RevisionPackaging.PackageBatch()
at Umbraco.Courier.Core.Packaging.RevisionPackaging.PackageBatch()
at Umbraco.Courier.Core.Packaging.RevisionPackaging.Package()
at Umbraco.Courier.Core.TaskManager.manageTask(IRevisionTask value)
9/26/2013 6:05:24 PM
Error during packaging
Hi guys,
First, sorry for my english.
I need a help, with a case. Recently, I upgrade Umbraco version and Courier version.
And now I have the following error, and in all moment:
Somebody, please. Could Help me?
Error during packaging:
error:Umbraco.Courier.Core.Exceptions.PackageException: Unable to load item with id '[XSLT]SecurityCertificatesScripts' from provider 'Macros' ---> Umbraco.Courier.Core.Exceptions.RetrieveException: Error retrieving item [[XSLT]SecurityCertificatesScripts] from provider [2ab40e30-e292-11df-85ca-0800200c9a66]. ---> NHibernate.Exceptions.GenericADOException: could not execute query [ SELECT this_.id as id32218_0_, this_.macroAlias as macroAlias32218_0_, this_.macroCacheByPage as macroCac3_32218_0_, this_.macroCachePersonalized as macroCac4_32218_0_, this_.macroDontRender as macroDon5_32218_0_, this_.macroName as macroName32218_0_, this_.macroPython as macroPyt7_32218_0_, this_.macroRefreshRate as macroRef8_32218_0_, this_.macroScriptAssembly as macroScr9_32218_0_, this_.macroScriptType as macroSc10_32218_0_, this_.macroUseInEditor as macroUs11_32218_0_, this_.macroXSLT as macroXSLT32218_0_ FROM cmsMacro this_ WHERE this_.macroAlias = ? ] Positional parameters: #0>[XSLT]SecurityCertificatesScripts [SQL: SELECT this_.id as id32218_0_, this_.macroAlias as macroAlias32218_0_, this_.macroCacheByPage as macroCac3_32218_0_, this_.macroCachePersonalized as macroCac4_32218_0_, this_.macroDontRender as macroDon5_32218_0_, this_.macroName as macroName32218_0_, this_.macroPython as macroPyt7_32218_0_, this_.macroRefreshRate as macroRef8_32218_0_, this_.macroScriptAssembly as macroScr9_32218_0_, this_.macroScriptType as macroSc10_32218_0_, this_.macroUseInEditor as macroUs11_32218_0_, this_.macroXSLT as macroXSLT32218_0_ FROM cmsMacro this_ WHERE this_.macroAlias = ?] ---> System.NullReferenceException: Object reference not set to an instance of an object. at NHibernate.AdoNet.AbstractBatcher.CheckReaders() 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.Loader.Criteria.CriteriaLoader.List(ISessionImplementor session) at NHibernate.Impl.SessionImpl.List(CriteriaImpl criteria, IList results) at NHibernate.Impl.CriteriaImpl.List(IList results) at NHibernate.Impl.CriteriaImpl.List[T]() at Umbraco.Courier.Persistence.V6.NHibernate.Persisters.MacroItem.RetrieveItem[T](ItemIdentifier itemId) in c:\Program Files (x86)\teamcity\buildAgent\work\650bafc4b83aa858\Core\Umbraco.Courier.Persistence.V6.NHibernate\Persisters\Macro.cs:line 61 at Umbraco.Courier.Core.ItemCrudProvider.RetrieveItem[T](ItemIdentifier itemId) --- End of inner exception stack trace --- at Umbraco.Courier.Core.ItemCrudProvider.RetrieveItem[T](ItemIdentifier itemId) at Umbraco.Courier.ItemProviders.MacroItemProvider.HandlePack(ItemIdentifier id) at Umbraco.Courier.Core.ItemProvider.Package(ItemIdentifier id) at Umbraco.Courier.RepositoryProviders.Local.Package(ItemIdentifier itemId) at Umbraco.Courier.Core.Packaging.RevisionPackaging.PackageItem(ItemIdentifier itemId, ItemProvider provider, QueuedItemIdentifier itemInQueue) --- End of inner exception stack trace --- at Umbraco.Courier.Core.Packaging.RevisionPackaging.PackageItem(ItemIdentifier itemId, ItemProvider provider, QueuedItemIdentifier itemInQueue) at Umbraco.Courier.Core.Packaging.RevisionPackaging.PackageBatch() at Umbraco.Courier.Core.Packaging.RevisionPackaging.PackageBatch() at Umbraco.Courier.Core.Packaging.RevisionPackaging.PackageBatch() at Umbraco.Courier.Core.Packaging.RevisionPackaging.PackageBatch() at Umbraco.Courier.Core.Packaging.RevisionPackaging.PackageBatch() at Umbraco.Courier.Core.Packaging.RevisionPackaging.PackageBatch() at Umbraco.Courier.Core.Packaging.RevisionPackaging.PackageBatch() at Umbraco.Courier.Core.Packaging.RevisionPackaging.PackageBatch() at Umbraco.Courier.Core.Packaging.RevisionPackaging.Package() at Umbraco.Courier.Core.TaskManager.manageTask(IRevisionTask value) 9/26/2013 6:05:24 PM
Hi Luiz
First of all, clear /app_data/courier/cache to get rid of any old version data.
Next, how does the alias of this macro look like? is it using [xslt] as a prefix? - I believe this could most likely be causing the query to fail
is working on a reply...