When we rebuild the search index in our Umbraco instance we get this exception in the logs. Does anyone have any ideas why it fails creating the search indexes?
2019-08-20 17:06:24,963 [7] DEBUG - LogType=System, Login=admin, UserName=xyz, UserId=0, NodeId=-1, Path=, ContentName=, Message=Loading content from disk cache...
2019-08-20 17:06:25,106 [7] DEBUG - LogType=Error, Login=admin, UserName=xyz, UserId=0, NodeId=-1, Path=, ContentName=, Message=Error loading application startup handler: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.TypeInitializationException: The type initializer for 'Examine.ExamineManager' threw an exception. ---> umbraco.DataLayer.SqlHelperException: Umbraco Exception (DataLayer): SQL helper exception in ExecuteXmlReader ---> System.ArgumentException: The query didn't return a value.
at umbraco.DataLayer.SqlHelper1.ExecuteXmlReader(String commandText, P[] parameters)
at umbraco.DataLayer.SqlHelper1.ExecuteXmlReader(String commandText, IParameter[] parameters)
--- End of inner exception stack trace ---
at umbraco.DataLayer.SqlHelper1.ExecuteXmlReader(String commandText, IParameter[] parameters)
at umbraco.cms.businesslogic.web.Document.importXml()
at umbraco.cms.businesslogic.web.Document.ToXml(XmlDocument xd, Boolean Deep)
at umbraco.cms.businesslogic.web.Document.ToXml(XmlDocument xd, Boolean Deep)
at umbraco.cms.businesslogic.web.Document.ToXml(XmlDocument xd, Boolean Deep)
at umbraco.cms.businesslogic.web.Document.ToXml(XmlDocument xd, Boolean Deep)
at umbraco.cms.businesslogic.web.Document.XmlPopulate(XmlDocument xd, XmlNode& x, Boolean Deep)
at UmbracoExamine.DataServices.UmbracoContentService.GetLatestContentByXPath(String xpath)
at UmbracoExamine.BaseUmbracoIndexer.AddNodesToIndex(String xPath, String type)
at UmbracoExamine.BaseUmbracoIndexer.PerformIndexAll(String type)
at UmbracoExamine.BaseUmbracoIndexer.PerformIndexRebuild()
at UmbracoExamine.UmbracoContentIndexer.RebuildIndex()
at Examine.ExamineManager.LoadProviders()
at Examine.ExamineManager..cctor()
--- End of inner exception stack trace ---
at umbraco.presentation.umbraco.Search.ExamineEvents..ctor()
--- End of inner exception stack trace ---
at System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean publicOnly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHandleInternal& ctor, Boolean& bNeedSecurityCheck)
at System.RuntimeType.CreateInstanceSlow(Boolean publicOnly, Boolean skipCheckThis, Boolean fillCache, StackCrawlMark& stackMark)
at System.Activator.CreateInstance(Type type, Boolean nonPublic)
at System.Activator.CreateInstance(Type type)
at umbraco.businesslogic.ApplicationStartupHandler..cctor()
2019-08-20 17:06:25,114 [7] DEBUG - LogType=Error, Login=admin, UserName=xyz, UserId=0, NodeId=-1, Path=, ContentName=, Message=Error loading application startup handler: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.TypeInitializationException: The type initializer for 'Examine.ExamineManager' threw an exception. ---> umbraco.DataLayer.SqlHelperException: Umbraco Exception (DataLayer): SQL helper exception in ExecuteXmlReader ---> System.ArgumentException: The query didn't return a value.
at umbraco.DataLayer.SqlHelper1.ExecuteXmlReader(String commandText, P[] parameters)
at umbraco.DataLayer.SqlHelper1.ExecuteXmlReader(String commandText, IParameter[] parameters)
--- End of inner exception stack trace ---
at umbraco.DataLayer.SqlHelper1.ExecuteXmlReader(String commandText, IParameter[] parameters)
at umbraco.cms.businesslogic.web.Document.importXml()
at umbraco.cms.businesslogic.web.Document.ToXml(XmlDocument xd, Boolean Deep)
at umbraco.cms.businesslogic.web.Document.ToXml(XmlDocument xd, Boolean Deep)
at umbraco.cms.businesslogic.web.Document.ToXml(XmlDocument xd, Boolean Deep)
at umbraco.cms.businesslogic.web.Document.ToXml(XmlDocument xd, Boolean Deep)
at umbraco.cms.businesslogic.web.Document.XmlPopulate(XmlDocument xd, XmlNode& x, Boolean Deep)
at UmbracoExamine.DataServices.UmbracoContentService.GetLatestContentByXPath(String xpath)
at UmbracoExamine.BaseUmbracoIndexer.AddNodesToIndex(String xPath, String type)
at UmbracoExamine.BaseUmbracoIndexer.PerformIndexAll(String type)
at UmbracoExamine.BaseUmbracoIndexer.PerformIndexRebuild()
at UmbracoExamine.UmbracoContentIndexer.RebuildIndex()
at Examine.ExamineManager.LoadProviders()
at Examine.ExamineManager..cctor()
--- End of inner exception stack trace ---
at UmbracoExamine.UmbracoEventManager..ctor()
--- End of inner exception stack trace ---
at System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean publicOnly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHandleInternal& ctor, Boolean& bNeedSecurityCheck)
at System.RuntimeType.CreateInstanceSlow(Boolean publicOnly, Boolean skipCheckThis, Boolean fillCache, StackCrawlMark& stackMark)
at System.Activator.CreateInstance(Type type, Boolean nonPublic)
at System.Activator.CreateInstance(Type type)
at umbraco.businesslogic.ApplicationStartupHandler..cctor()
Examine.ExamineManager exception
When we rebuild the search index in our Umbraco instance we get this exception in the logs. Does anyone have any ideas why it fails creating the search indexes?
2019-08-20 17:06:24,963 [7] DEBUG - LogType=System, Login=admin, UserName=xyz, UserId=0, NodeId=-1, Path=, ContentName=, Message=Loading content from disk cache... 2019-08-20 17:06:25,106 [7] DEBUG - LogType=Error, Login=admin, UserName=xyz, UserId=0, NodeId=-1, Path=, ContentName=, Message=Error loading application startup handler: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.TypeInitializationException: The type initializer for 'Examine.ExamineManager' threw an exception. ---> umbraco.DataLayer.SqlHelperException: Umbraco Exception (DataLayer): SQL helper exception in ExecuteXmlReader ---> System.ArgumentException: The query didn't return a value. at umbraco.DataLayer.SqlHelper
1.ExecuteXmlReader(String commandText, P[] parameters) at umbraco.DataLayer.SqlHelper
1.ExecuteXmlReader(String commandText, IParameter[] parameters) --- End of inner exception stack trace --- at umbraco.DataLayer.SqlHelper1.ExecuteXmlReader(String commandText, IParameter[] parameters) at umbraco.cms.businesslogic.web.Document.importXml() at umbraco.cms.businesslogic.web.Document.ToXml(XmlDocument xd, Boolean Deep) at umbraco.cms.businesslogic.web.Document.ToXml(XmlDocument xd, Boolean Deep) at umbraco.cms.businesslogic.web.Document.ToXml(XmlDocument xd, Boolean Deep) at umbraco.cms.businesslogic.web.Document.ToXml(XmlDocument xd, Boolean Deep) at umbraco.cms.businesslogic.web.Document.XmlPopulate(XmlDocument xd, XmlNode& x, Boolean Deep) at UmbracoExamine.DataServices.UmbracoContentService.GetLatestContentByXPath(String xpath) at UmbracoExamine.BaseUmbracoIndexer.AddNodesToIndex(String xPath, String type) at UmbracoExamine.BaseUmbracoIndexer.PerformIndexAll(String type) at UmbracoExamine.BaseUmbracoIndexer.PerformIndexRebuild() at UmbracoExamine.UmbracoContentIndexer.RebuildIndex() at Examine.ExamineManager.LoadProviders() at Examine.ExamineManager..cctor() --- End of inner exception stack trace --- at umbraco.presentation.umbraco.Search.ExamineEvents..ctor() --- End of inner exception stack trace --- at System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean publicOnly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHandleInternal& ctor, Boolean& bNeedSecurityCheck) at System.RuntimeType.CreateInstanceSlow(Boolean publicOnly, Boolean skipCheckThis, Boolean fillCache, StackCrawlMark& stackMark) at System.Activator.CreateInstance(Type type, Boolean nonPublic) at System.Activator.CreateInstance(Type type) at umbraco.businesslogic.ApplicationStartupHandler..cctor() 2019-08-20 17:06:25,114 [7] DEBUG - LogType=Error, Login=admin, UserName=xyz, UserId=0, NodeId=-1, Path=, ContentName=, Message=Error loading application startup handler: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.TypeInitializationException: The type initializer for 'Examine.ExamineManager' threw an exception. ---> umbraco.DataLayer.SqlHelperException: Umbraco Exception (DataLayer): SQL helper exception in ExecuteXmlReader ---> System.ArgumentException: The query didn't return a value. at umbraco.DataLayer.SqlHelper
1.ExecuteXmlReader(String commandText, P[] parameters) at umbraco.DataLayer.SqlHelper1.ExecuteXmlReader(String commandText, IParameter[] parameters) --- End of inner exception stack trace --- at umbraco.DataLayer.SqlHelper
1.ExecuteXmlReader(String commandText, IParameter[] parameters) at umbraco.cms.businesslogic.web.Document.importXml() at umbraco.cms.businesslogic.web.Document.ToXml(XmlDocument xd, Boolean Deep) at umbraco.cms.businesslogic.web.Document.ToXml(XmlDocument xd, Boolean Deep) at umbraco.cms.businesslogic.web.Document.ToXml(XmlDocument xd, Boolean Deep) at umbraco.cms.businesslogic.web.Document.ToXml(XmlDocument xd, Boolean Deep) at umbraco.cms.businesslogic.web.Document.XmlPopulate(XmlDocument xd, XmlNode& x, Boolean Deep) at UmbracoExamine.DataServices.UmbracoContentService.GetLatestContentByXPath(String xpath) at UmbracoExamine.BaseUmbracoIndexer.AddNodesToIndex(String xPath, String type) at UmbracoExamine.BaseUmbracoIndexer.PerformIndexAll(String type) at UmbracoExamine.BaseUmbracoIndexer.PerformIndexRebuild() at UmbracoExamine.UmbracoContentIndexer.RebuildIndex() at Examine.ExamineManager.LoadProviders() at Examine.ExamineManager..cctor() --- End of inner exception stack trace --- at UmbracoExamine.UmbracoEventManager..ctor() --- End of inner exception stack trace --- at System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean publicOnly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHandleInternal& ctor, Boolean& bNeedSecurityCheck) at System.RuntimeType.CreateInstanceSlow(Boolean publicOnly, Boolean skipCheckThis, Boolean fillCache, StackCrawlMark& stackMark) at System.Activator.CreateInstance(Type type, Boolean nonPublic) at System.Activator.CreateInstance(Type type) at umbraco.businesslogic.ApplicationStartupHandler..cctor()is working on a reply...
This forum is in read-only mode while we transition to the new forum.
You can continue this topic on the new forum by tapping the "Continue discussion" link below.