Error on Set Access Rights page after nuget updates (The given key was not present in the dictionary.)

Vote:
 

After we updated to latest version of Episerver (from 11 to 11) we get this message when trying to sett access rights.

[KeyNotFoundException: The given key was not present in the dictionary.]
   System.Collections.Generic.Dictionary`2.get_Item(TKey key) +65
   EPiServer.DataAccess.Internal.ContentListDB.ReadCommonMetadata(DbDataReader reader, Dictionary`2 allFetchedItems) +84
   EPiServer.DataAccess.Internal.ContentListDB.ReadPublishedList(DbCommand cmd) +206
   EPiServer.DataAccess.Internal.<>c__DisplayClass19_0.b__0() +529
   EPiServer.Data.Providers.Internal.<>c__DisplayClass31_0`1.b__0() +59
   EPiServer.Data.Providers.SqlTransientErrorsRetryPolicy.Execute(Func`1 method) +51
   EPiServer.Data.Providers.Internal.SqlDatabaseExecutor.Execute(Func`1 action) +203
   EPiServer.DataAccess.Internal.ContentListDB.LoadSpecificContentInstances(IList`1 contentLinks, Int32 languageBranchID) +112
   EPiServer.Core.Internal.DefaultContentProviderDatabase.LoadSpecificContentInstances(IList`1 contentLinks, Int32 languageBranchID) +31
   EPiServer.Core.Internal.<>c__DisplayClass14_0.b__1(IList`1 refs) +22
   EPiServer.Core.Internal.DefaultContentProvider.BatchLoad(IList`1 contentLinks, Func`2 dbLoader) +169
   EPiServer.Core.Internal.DefaultContentProvider.LoadContents(IList`1 contentReferences, ILanguageSelector selector) +316
   EPiServer.Core.ContentProvider.GetContentBatch(IList`1 batch, ILanguageSelector selector, List`1& contents, Dictionary`2& contentMap) +85
   EPiServer.Core.ContentProvider.GetScatteredContents(IEnumerable`1 contentLinks, ILanguageSelector selector) +671
   EPiServer.Core.ContentProvider.LoadBatched(IList`1 contentReferences, ILanguageSelector selector) +61
   EPiServer.Core.Internal.ProviderPipelineImplementation.GetItems(ContentProvider provider, IList`1 contentLinks, LoaderOptions loaderOptions) +225
   EPiServer.Core.Internal.DefaultContentLoader.GetChildren(ContentReference contentLink, LoaderOptions loaderOptions, Int32 startIndex, Int32 maxRows) +1166
   EPiServer.Core.Internal.DefaultContentLoader.GetChildren(ContentReference contentLink, LoaderOptions loaderOptions) +67
   EPiServer.Core.Internal.DefaultContentRepository.GetChildren(ContentReference contentLink, LoaderOptions loaderOptions) +66
   EPiServer.UI.WebControls.ContentDataSource.ContentDataSource.GetFilteredChildren(ContentReference contentLink) +137
   EPiServer.UI.WebControls.ContentDataSource.ContentHierarchyData.EnsureChildrenLoaded() +46
   EPiServer.UI.WebControls.ContentDataSource.ContentHierarchyData.GetChildren() +14
   EPiServer.UI.WebControls.PageTreeView.PopulateChildNodes(IHierarchicalEnumerable enumerable, Int32 depth, Int32 expandDepth, PageTreeNode parentNode, ArrayList populationPath) +588
   EPiServer.UI.WebControls.PageTreeView.PopulateRecursive(String viewPath) +216
   EPiServer.UI.WebControls.PageTreeView.PerformDataBinding() +130
   System.Web.UI.WebControls.HierarchicalDataBoundControl.PerformSelect() +107
   System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +71
   System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() +93
   EPiServer.UI.WebControls.PageTreeView.CreateChildControls() +96
   System.Web.UI.Control.EnsureChildControls() +116
   System.Web.UI.Control.PreRenderRecursiveInternal() +49
   System.Web.UI.Control.PreRenderRecursiveInternal() +236
   System.Web.UI.Control.PreRenderRecursiveInternal() +236
   System.Web.UI.Control.PreRenderRecursiveInternal() +236
   System.Web.UI.Control.PreRenderRecursiveInternal() +236
   System.Web.UI.Control.PreRenderRecursiveInternal() +236
   System.Web.UI.Control.PreRenderRecursiveInternal() +236
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +4727

Anyone else seen this?

#193329
May 29, 2018 10:16
Vote:
 

As the answer were in another thread: https://world.episerver.com/Modules/Forum/Pages/Thread.aspx?id=149428 the problem was with content that only existed in tblContent and not in tblContentLanguage.

I used another way to find it that is faster but is depending on that you have access to the database.

To be able to find if you have this problem run this command:

Select *
From tblContent c
	left outer join tblContentLanguage cl on c.pkID = cl.fkContentID
Where cl.fkContentID is null
#193358
May 29, 2018 13:12
This topic was created over six months ago and has been resolved. If you have a similar question, please create a new topic and refer to this one.
* You are NOT allowed to include any hyperlinks in the post because your account hasn't associated to your company. User profile should be updated.