Hi All,

I'm hoping someone can help me out here, I've had an issue recently where DNN search isn't working at all, it's only started recently.

Get get the following error

AssemblyVersion:7.2.2

PortalID:-1

PortalName:

UserID:-1

UserName:

ActiveTabID:-1

ActiveTabName:

RawURL:

AbsoluteURL:

AbsoluteURLReferrer:

UserAgent:

DefaultDataProvider:DotNetNuke.Data.SqlDataProvider, DotNetNuke

ExceptionGUID:e691e011-ad2c-45cb-8676-0b22c9e4ea30

InnerException:Index was outside the bounds of the array.

FileName:

FileLineNumber:0

FileColumnNumber:0

Method:Lucene.Net.Index.TermInfosReader.SeekEnum

StackTrace:

Message:

System.IndexOutOfRangeException: Index was outside the bounds of the array.
   at Lucene.Net.Index.TermInfosReader.SeekEnum(SegmentTermEnum enumerator, Int32 indexOffset)
   at Lucene.Net.Index.TermInfosReader.Get(Term term, Boolean useCache)
   at Lucene.Net.Index.TermInfosReader.Terms(Term term)
   at Lucene.Net.Index.SegmentReader.Terms(Term t)
   at Lucene.Net.Search.NumericRangeQuery`1.NumericRangeTermEnum.Next()
   at Lucene.Net.Search.NumericRangeQuery`1.NumericRangeTermEnum..ctor(NumericRangeQuery`1 enclosingInstance, IndexReader reader)
   at Lucene.Net.Search.NumericRangeQuery`1.GetEnum(IndexReader reader)
   at Lucene.Net.Search.MultiTermQuery.ScoringBooleanQueryRewrite.Rewrite(IndexReader reader, MultiTermQuery query)
   at Lucene.Net.Search.MultiTermQuery.ConstantScoreBooleanQueryRewrite.Rewrite(IndexReader reader, MultiTermQuery query)
   at Lucene.Net.Search.MultiTermQuery.Rewrite(IndexReader reader)
   at Lucene.Net.Search.BooleanQuery.Rewrite(IndexReader reader)
   at Lucene.Net.Search.IndexSearcher.Rewrite(Query original)
   at Lucene.Net.Search.Query.Weight(Searcher searcher)
   at Lucene.Net.Index.DocumentsWriter.ApplyDeletes(IndexReader reader, Int32 docIDStart)
   at Lucene.Net.Index.DocumentsWriter.ApplyDeletes(SegmentInfos infos)
   at Lucene.Net.Index.IndexWriter.ApplyDeletes()
   at Lucene.Net.Index.IndexWriter.DoFlushInternal(Boolean flushDocStores, Boolean flushDeletes)
   at Lucene.Net.Index.IndexWriter.DoFlush(Boolean flushDocStores, Boolean flushDeletes)
   at Lucene.Net.Index.IndexWriter.PrepareCommit(IDictionary`2 commitUserData)
   at Lucene.Net.Index.IndexWriter.Commit(IDictionary`2 commitUserData)
   at DotNetNuke.Services.Search.Internals.LuceneControllerImpl.Commit()
   at DotNetNuke.Services.Search.Internals.InternalSearchControllerImpl.AddSearchDocuments(IEnumerable`1 searchDocuments)
   at DotNetNuke.Services.Search.SearchEngine.StoreSearchDocuments(IEnumerable`1 searchDocs)
   at DotNetNuke.Services.Search.SearchEngine.IndexContent(DateTime startDate)
   at DotNetNuke.Services.Search.SearchEngineScheduler.DoWork()

I have also had an issue (unclosed string literal) where the text was larger than 2000 characters allowed in the ItemData column of the Journal table. I managed to clear this issue by trimming the last 40 chars then closing off the Description and the rest of the "object".

Has anyone seen/fixed this error before?
Could the "enclosed string literal" be causing it?
Can I directly delete rows from the Journal table or are there relationships with other tables?

Thanks for any help you can give.