Hi Thomas,

Is it the site that you migrate from SQLCE to MSSQL, if did you remember to change the connections strings in the web.config so it now point to the MSSQL database instead of the SQLCE. If then you could try to go the the /App_Data/Logs, to see if the log file can reveal more information about why you are getting this error.

Hope this helps,

/Dennis

Hi Thomas

Just noticed that this is a double post - Sören and I have replied on this post as well https://our.umbraco.org/forum/umbraco-as-a-service/issues/61548-Content-node-throws-error?p=0#comment208914 - Just to let you know.

/Jan

 Yes, this is the site which I migrated from SQL CE database to MSSQL before.  In log, it shows like

System.IndexOutOfRangeException:Index was outside the bounds of the array.

   at Lucene.Net.Util.BitVector.Get(Int32 bit)
   at Lucene.Net.Index.SegmentTermDocs.Read(Int32[] docs,Int32[] freqs)
   at Lucene.Net.Search.MultiTermQueryWrapperFilter.TermGenerator.Generate(MultiTermQuery query,IndexReader reader,TermEnum enumerator)
   at Lucene.Net.Search.MultiTermQueryWrapperFilter.GetDocIdSet(IndexReader reader)
   at Lucene.Net.Search.ConstantScoreQuery.ConstantScorer..ctor(ConstantScoreQuery enclosingInstance,Similarity similarity,IndexReader reader,Weight w)
   at Lucene.Net.Search.ConstantScoreQuery.ConstantWeight.Scorer(IndexReader reader,Boolean scoreDocsInOrder,Boolean topScorer)
   at Lucene.Net.Search.BooleanQuery.BooleanWeight.Scorer(IndexReader reader,Boolean scoreDocsInOrder,Boolean topScorer)
   at Lucene.Net.Search.BooleanQuery.BooleanWeight.Scorer(IndexReader reader,Boolean scoreDocsInOrder,Boolean topScorer)
   at Lucene.Net.Search.IndexSearcher.Search(Weight weight,Filter filter,Collector collector)
   at Lucene.Net.Search.IndexSearcher.Search(Weight weight,Filter filter,Int32 nDocs,Sort sort,Boolean fillFields)
   at Lucene.Net.Search.IndexSearcher.Search(Weight weight,Filter filter,Int32 nDocs,Sort sort)
   at Lucene.Net.Search.Searcher.Search(Query query,Filter filter,Int32 n,Sort sort)
   at Examine.LuceneEngine.SearchResults.DoSearch(Query query,IEnumerable`1 sortField, Int32 maxResults)
   at Examine.LuceneEngine.Providers.BaseLuceneSearcher.Search(ISearchCriteria searchParams, Int32 maxResults)
   at Examine.LuceneEngine.Providers.BaseLuceneSearcher.Search(ISearchCriteria searchParams)
   at Umbraco.Web.PublishedCache.XmlPublishedCache.PublishedMediaCache.GetUmbracoMedia(Int32 id)
   at Umbraco.Web.PublishedCache.XmlPublishedCache.PublishedMediaCache.GetById(UmbracoContext umbracoContext, Boolean preview, Int32 nodeId)
   at Umbraco.Web.PublishedCache.ContextualPublishedCache`1.GetById(Boolean preview,Int32 contentId)
   at Umbraco.Web.UmbracoHelper.TypedMedia(Int32 id)
   at ASP._Page_Views_Partials_homepageCarouselIndicators_cshtml.Execute()in c:\Users\Mindzpark\Documents\MyWebSites\DemoSite\Views\Partials\homepageCarouselIndicators.cshtml:line 8
   at System.Web.WebPages.WebPageBase.ExecutePageHierarchy()
   at System.Web.Mvc.WebViewPage.ExecutePageHierarchy()
   at System.Web.WebPages.WebPageBase.ExecutePageHierarchy(WebPageContext pageContext,TextWriter writer,WebPageRenderingBase startPage)
   at System.Web.Mvc.RazorView.RenderView(ViewContext viewContext,TextWriter writer,Object instance)
   at System.Web.Mvc.BuildManagerCompiledView.Render(ViewContext viewContext,TextWriter writer)
   at Umbraco.Core.Profiling.ProfilingView.Render(ViewContext viewContext,TextWriter writer)
   at System.Web.Mvc.HtmlHelper.RenderPartialInternal(String partialViewName,ViewDataDictionary viewData,Object model,TextWriter writer,ViewEngineCollection viewEngineCollection)
   at System.Web.Mvc.Html.RenderPartialExtensions.RenderPartial(HtmlHelper htmlHelper,String partialViewName)
   at ASP._Page_Views_HomePage_cshtml.Execute()in c:\Users\Mindzpark\Documents\MyWebSites\DemoSite\Views\HomePage.cshtml:line 22
   at System.Web.WebPages.WebPageBase.ExecutePageHierarchy()
   at System.Web.Mvc.WebViewPage.ExecutePageHierarchy()
   at System.Web.WebPages.WebPageBase.ExecutePageHierarchy(WebPageContext pageContext,TextWriter writer,WebPageRenderingBase startPage)
   at System.Web.Mvc.RazorView.RenderView(ViewContext viewContext,TextWriter writer,Object instance)
   at System.Web.Mvc.BuildManagerCompiledView.Render(ViewContext viewContext,TextWriter writer)
   at Umbraco.Core.Profiling.ProfilingView.Render(ViewContext viewContext,TextWriter writer)
   at System.Web.Mvc.ViewResultBase.ExecuteResult(ControllerContext context)
   at System.Web.Mvc.ControllerActionInvoker.InvokeActionResult(ControllerContext controllerContext,ActionResult actionResult)
   at System.Web.Mvc.ControllerActionInvoker.<>c__DisplayClass1a.<InvokeActionResultWithFilters>b__17()
   at System.Web.Mvc.ControllerActionInvoker.InvokeActionResultFilter(IResultFilter filter,ResultExecutingContext preContext,Func`1 continuation)
   at System.Web.Mvc.ControllerActionInvoker.<>c__DisplayClass1a.<>c__DisplayClass1c.<InvokeActionResultWithFilters>b__19()
   at System.Web.Mvc.ControllerActionInvoker.InvokeActionResultFilter(IResultFilter filter, ResultExecutingContext preContext, Func`1 continuation)
   at System.Web.Mvc.ControllerActionInvoker.<>c__DisplayClass1a.<>c__DisplayClass1c.<InvokeActionResultWithFilters>b__19()
   at System.Web.Mvc.ControllerActionInvoker.InvokeActionResultWithFilters(ControllerContext controllerContext,IList`1 filters, ActionResult actionResult)
   at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c__DisplayClass25.<>c__DisplayClass2a.<BeginInvokeAction>b__20()
   at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c__DisplayClass25.<BeginInvokeAction>b__22(IAsyncResult asyncResult)
   at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncResult`1.End()
   at System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeAction(IAsyncResult asyncResult)
   at System.Web.Mvc.Controller.<>c__DisplayClass1d.<BeginExecuteCore>b__18(IAsyncResult asyncResult)
   at System.Web.Mvc.Async.AsyncResultWrapper.<>c__DisplayClass4.<MakeVoidDelegate>b__3(IAsyncResult ar)
   at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncResult`1.End()
   at System.Web.Mvc.Controller.EndExecuteCore(IAsyncResult asyncResult)
   at System.Web.Mvc.Async.AsyncResultWrapper.<>c__DisplayClass4.<MakeVoidDelegate>b__3(IAsyncResult ar)
   at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncResult`1.End()
   at System.Web.Mvc.Controller.EndExecute(IAsyncResult asyncResult)
   at System.Web.Mvc.Controller.System.Web.Mvc.Async.IAsyncController.EndExecute(IAsyncResult asyncResult)
   at System.Web.Mvc.MvcHandler.<>c__DisplayClass8.<BeginProcessRequest>b__3(IAsyncResult asyncResult)
   at System.Web.Mvc.Async.AsyncResultWrapper.<>c__DisplayClass4.<MakeVoidDelegate>b__3(IAsyncResult ar)
   at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncResult`1.End()
   at System.Web.Mvc.MvcHandler.EndProcessRequest(IAsyncResult asyncResult)
   at System.Web.Mvc.MvcHandler.System.Web.IHttpAsyncHandler.EndProcessRequest(IAsyncResult result)
   at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
   at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

is working on a reply...