Open DigitbaseCom opened 2 years ago
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.
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
@.***
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, 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, TaskCompletionSource
1 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, 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 https://github.com/vanjarosoftware/Vanjaro.Platform/issues/2171#issuecomment-1105603996, 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>
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 https://github.com/vanjarosoftware/Vanjaro.Platform/issues/2171#issuecomment-1105603996, or unsubscribe https://github.com/notifications/unsubscribe-auth/AYW73OHPEYFFVNUOJTULYIDVGGMEHANCNFSM5TOP4FGQ . You are receiving this because you authored the thread.Message ID: @.***>
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, 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(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, 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 Managed.com