Overview

Page setting menu is not accessible with "There was an error retrieving your content. Please check your internet connection", as can be seen by the screenshot below :

Internet is working fine without any issue. General exception logged the following stack trace :

AbsoluteURL /API/PersonaBar/EvoqPages/GetPageDetails DefaultDataProvider D 
AbsoluteURL:/API/PersonaBar/EvoqPages/GetPageDetails

DefaultDataProvider:DotNetNuke.Data.SqlDataProvider, DotNetNuke

ExceptionGUID:ad6bcf1a-f201-4270-abbf-6005cae6c88a

AssemblyVersion:

PortalId:-1
UserId:-1
TabId:-1

Message:Object reference not set to an instance of an object.

StackTrace:

at Dnn.PersonaBar.Pages.Components.PageUrlsController.AddUrlToList(List`1 tabs, Int32 portalId, Int32 id, PortalAliasInfo alias, Locale urlLocale, String path, String queryString, Int32 statusCode, Boolean isSystem, FriendlyUrlSettings friendlyUrlSettings, Nullable`1 lastModifiedByUserId) at Dnn.PersonaBar.Pages.Components.PageUrlsController.GetSortedUrls(TabInfo tab, Int32 portalId, Lazy`1 locales, Int32 sortColumn, Boolean sortOrder, Boolean isSystem) at Dnn.PersonaBar.Pages.Components.PageUrlsController.GetPageUrls(TabInfo tab, Int32 portalId) at Dnn.PersonaBar.Pages.Components.PagesControllerImpl.GetPageUrls(Int32 tabId) at Dnn.PersonaBar.Pages.Components.PagesControllerImpl.GetPageSettings(Int32 pageId) at Evoq.PersonaBar.Pages.Services.EvoqPagesController.GetPageDetails(Int32 pageId) at lambda_method(Closure , Object , Object[] ) at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.<>c__DisplayClass10.b__9(Object instance, Object[] methodParameters) at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.Execute(Object instance, Object[] arguments) at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ExecuteAsync(HttpControllerContext controllerContext, IDictionary`2 arguments, CancellationToken cancellationToken) --- End of stack trace from previous location where exception was thrown --- at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Web.Http.Tracing.ITraceWriterExtensions.d__18`1.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Web.Http.Controllers.ApiControllerActionInvoker.d__0.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Web.Http.Tracing.ITraceWriterExtensions.d__18`1.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Web.Http.Controllers.ActionFilterResult.d__2.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Web.Http.Filters.AuthorizationFilterAttribute.d__2.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Web.Http.Filters.AuthorizationFilterAttribute.d__2.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Web.Http.Controllers.ExceptionFilterResult.d__0.MoveNext()
InnerMessage:

InnerStackTrace:

Source:Dnn.PersonaBar.Pages

Environment

DNN 9.x

Root Cause

The root cause of this issue is because "PortalAliasId" column in "TabUrls" table consists of value "1", by default this should be NULL instead.

Resolution

Before we proceed please ensure that you have full access to the database of your DNN instance and create a backup of your database for safety precaution. Once your database backup has been verified, please follow the steps below:

1. First, we would need to find the problematic entry in 'TabUrls" table by executing the SQL query below:

SELECT * FROM TabUrls WHERE PortalAliasId IS NOT NULL

2. Take note of the TabId and SeqNum of the problematic row that you would like to modify.
3. Execute the following SQL query to fix the problematic entry.

UPDATE TabUrls SET PortalAliasId = NULL Where TabId = <Enter TabId from Step 3> AND SeqNum = <Enter SeqNum from Step 3>

4. Refresh Cache, restart application pool and restart DNN.