Our Vanjaro site entered an application reboot cycle and terminated after several attempts to restart.

[DigitbaseCom]

Mandeep Singh ask me to post this here. Thank you.

Our Vanjaro aliased portal/site began to crash after adding & arranging a few new pages on Friday evening. It is hosted at Managed.com and Vanjaro_Platform_1.3.0 was installed by Managed. The domain is internetcookbooks.com and is now disabled in Plesk, otherwise it will disable the other two domains on the Managed subscription. The main domain is digitbase.com and a temp domain is something.tempdomain.com. They both work fine until internetcookbooks.com is reactivate in Plesk. 

The following is what Managed tech reported:

Hello,

It appears the application is Vanjaro, and that makes it a bit hard to say where exactly the issue stems from. I would send the following information to a Vanjaro developer to see if they can provide some information to you about what is happening:

Portal = Internet Cookbooks UserName = name LogType = GENERAL_EXCEPTION AbsoluteURL = /API/Pages/pages/updatehireracy DefaultDataProvider = DotNetNuke.Data.SqlDataProvider, DotNetNuke ExceptionGUID = 80d62263-714e-4952-931b-3658253321f4 LogGUID = bc2b2a9f-50ac-41f6-adfa-11dba1b52387 LogTypeKey = GENERAL_EXCEPTION LogConfigID = 4 LogPortalID = 3 LogServerName = GW1004 LogEventID = 6206 ExceptionHash = aBDxZ7F4w5n0UDLml71bRPolXH0= Message = Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32). StackTrace = at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at PetaPoco.Database.ExecuteInternal(CommandType commandType, String sql, Object[] args) at DotNetNuke.Data.PetaPoco.PetaPocoHelper.ExecuteNonQuery(String connectionString, CommandType type, Int32 timeoutSec, String sql, Object[] args) at DotNetNuke.Data.SqlDataProvider.ExecuteNonQuery(String procedureName, Object[] commandParameters) at DotNetNuke.Entities.Tabs.TabController.MoveTabBefore(TabInfo tab, Int32 beforeTabId) at Dnn.PersonaBar.Pages.Components.PagesControllerImpl.MovePage(PageMoveRequest request) at Vanjaro.UXManager.Extensions.Menu.Pages.Managers.PagesManager.UpdateHireracy(Object dynamicdata) at Vanjaro.UXManager.Extensions.Menu.Pages.Controllers.PagesController.UpdateHireracy(Object dynamicdata) at lambda_method(Closure , Object , Object[] ) at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.<>c__DisplayClass6_2.b__2(Object instance, Object[] methodParameters) at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ExecuteAsync(HttpControllerContext controllerContext, IDictionary2 arguments, CancellationToken cancellationToken) --- End of stack trace from previous location where exception was thrown ---

This error message contains the full stack trace for the error that caused the site to crash. I've never seen this before and it appears to be something related to the following: 

Vanjaro.UXManager.Extensions.Menu.Pages.Managers.PagesManager.UpdateHireracy(Object dynamicdata)

Thank you,

Jacob Sims
Support Technician
Managed.com

[meetmandeep]

Can you possibly provide a screenshot of your page structure? How many pages? How deeply nested? Any other information you can provide to help us duplicate the issue.

[DigitbaseCom]

Dear Mr. Singh: Right now the site is disabled in Plesk, if I make it active it will crash the other two sites within a short time. We will try to reactivate it this weekend and do some screenshots. Until then, below is from my sister Heather, who was building the Internet Cookbooks site: *Webpage nested structure:* *home/header categories/subcategories/sub pages* *The three header categories included about 7 subcategories each out of a * *total of about 27 subcategories.* *The website error/freeze up seemed to occur when the header * *subcategories made into actual working webpages not just placeholders.* For reference, below is my original message to you: Name Leonard Wikberg III Email ***@***.*** Subject Our Vanjaro site entered an application reboot cycle and terminated after several attempts to restart. Phone +14705904717 Message *Our Vanjaro aliased portal/site began to crash after adding & arranging a few new pages on Friday evening. It is hosted at Managed.com and Vanjaro_Platform_1.3.0 was installed by Managed. The domain is internetcookbooks.com <http://internetcookbooks.com/> and is now disabled in Plesk, otherwise it will disable the other two domains on the Managed subscription. The main domain is digitbase.com <http://digitbase.com/> and a temp domain is bkwinc.net.tempdomain.com <http://bkwinc.net.tempdomain.com/>. They both work fine until internetcookbooks.com <http://internetcookbooks.com/> is reactivate in Plesk. * *The following is what Managed tech reported:* Hello, It appears the application is Vanjaro, and that makes it a bit hard to say where exactly the issue stems from. I would send the following information to a Vanjaro developer to see if they can provide some information to you about what is happening: Portal = Internet Cookbooks UserName = ***@***.*** LogType = GENERAL_EXCEPTION AbsoluteURL = /API/Pages/pages/updatehireracy DefaultDataProvider = DotNetNuke.Data.SqlDataProvider, DotNetNuke ExceptionGUID = 80d62263-714e-4952-931b-3658253321f4 LogGUID = bc2b2a9f-50ac-41f6-adfa-11dba1b52387 LogTypeKey = GENERAL_EXCEPTION LogConfigID = 4 LogPortalID = 3 LogServerName = GW1004 LogEventID = 6206 ExceptionHash = aBDxZ7F4w5n0UDLml71bRPolXH0= Message = Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32). StackTrace = at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at PetaPoco.Database.ExecuteInternal(CommandType commandType, String sql, Object[] args) at DotNetNuke.Data.PetaPoco.PetaPocoHelper.ExecuteNonQuery(String connectionString, CommandType type, Int32 timeoutSec, String sql, Object[] args) at DotNetNuke.Data.SqlDataProvider.ExecuteNonQuery(String procedureName, Object[] commandParameters) at DotNetNuke.Entities.Tabs.TabController.MoveTabBefore(TabInfo tab, Int32 beforeTabId) at Dnn.PersonaBar.Pages.Components.PagesControllerImpl.MovePage(PageMoveRequest request) at Vanjaro.UXManager.Extensions.Menu.Pages.Managers.PagesManager.UpdateHireracy(Object dynamicdata) at Vanjaro.UXManager.Extensions.Menu.Pages.Controllers.PagesController.UpdateHireracy(Object dynamicdata) at lambda_method(Closure , Object , Object[] ) at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.<>c__DisplayClass6_2.b__2(Object instance, Object[] methodParameters) 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 --- This error message contains the full stack trace for the error that caused the site to crash. I've never seen this before and it appears to be something related to the following: Vanjaro.UXManager.Extensions.Menu.Pages.Managers.PagesManager.UpdateHireracy(Object dynamicdata) Thank you, *Jacob Sims* Support Technician

…

On Thu, Apr 21, 2022, 2:21 PM Mandeep Singh ***@***.***> wrote: Can you possibly provide a screenshot of your page structure? How many pages? How deeply nested? Any other information you can provide to help us duplicate the issue. — Reply to this email directly, view it on GitHub <#2171 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AYW73OHPEYFFVNUOJTULYIDVGGMEHANCNFSM5TOP4FGQ> . You are receiving this because you authored the thread. Message ID: <vanjarosoftware/Vanjaro.Platform/issues/2171/1105603996@ github.com>

[DigitbaseCom]

Would upgrading to 1.4 resolve any issues?

…

On Thu, Apr 21, 2022, 2:21 PM Mandeep Singh ***@***.***> wrote: Can you possibly provide a screenshot of your page structure? How many pages? How deeply nested? Any other information you can provide to help us duplicate the issue. — Reply to this email directly, view it on GitHub <#2171 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AYW73OHPEYFFVNUOJTULYIDVGGMEHANCNFSM5TOP4FGQ> . You are receiving this because you authored the thread.Message ID: ***@***.***>