U4-10327 - Ysod when opening Forms section

Created by Mads Rasmussen 18 Aug 2017, 10:52:27 Updated by Arnold Visser 16 Feb 2018, 09:43:03

Subtask of: UAASSCRUM-1073

The specified table does not exist. [ UFUserSecurity ]

at System.Data.SqlServerCe.SqlCeCommand.ProcessResults(Int32 hr) at System.Data.SqlServerCe.SqlCeCommand.CompileQueryPlan() at System.Data.SqlServerCe.SqlCeCommand.ExecuteCommand(CommandBehavior behavior, String method, ResultSetOptions options) at System.Data.SqlServerCe.SqlCeCommand.ExecuteDbDataReader(CommandBehavior behavior) at Umbraco.Core.Persistence.PetaPocoCommandExtensions.<>c__DisplayClass5_0.b__0() in \psf\Home\Documents\test\Umbraco-CMS\src\Umbraco.Core\Persistence\PetaPocoCommandExtensions.cs:line 125 at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func1 func) in \\psf\Home\Documents\test\Umbraco-CMS\src\Umbraco.Core\Persistence\FaultHandling\RetryPolicy.cs:line 174 at Umbraco.Core.Persistence.PetaPocoCommandExtensions.ExecuteReaderWithRetry(IDbCommand command, RetryPolicy cmdRetryPolicy, RetryPolicy conRetryPolicy) in \\psf\Home\Documents\test\Umbraco-CMS\src\Umbraco.Core\Persistence\PetaPocoCommandExtensions.cs:line 110 at Umbraco.Core.Persistence.PetaPocoCommandExtensions.ExecuteReaderWithRetry(IDbCommand command, RetryPolicy retryPolicy) in \\psf\Home\Documents\test\Umbraco-CMS\src\Umbraco.Core\Persistence\PetaPocoCommandExtensions.cs:line 93 at Umbraco.Core.Persistence.PetaPocoCommandExtensions.ExecuteReaderWithRetry(IDbCommand command) in \\psf\Home\Documents\test\Umbraco-CMS\src\Umbraco.Core\Persistence\PetaPocoCommandExtensions.cs:line 80 at Umbraco.Core.Persistence.Database.<Query>d__741.MoveNext() in \psf\Home\Documents\test\Umbraco-CMS\src\Umbraco.Core\Persistence\PetaPoco.cs:line 883 at System.Collections.Generic.List1..ctor(IEnumerable1 collection) at System.Linq.Enumerable.ToList[TSource](IEnumerable1 source) at Umbraco.Core.Persistence.Database.Fetch[T](String sql, Object[] args) in \\psf\Home\Documents\test\Umbraco-CMS\src\Umbraco.Core\Persistence\PetaPoco.cs:line 696 at Umbraco.Forms.Data.Storage.UserSecurityStorage.GetUserSecurity(Object userId) at Umbraco.Forms.Web.FormsSecurity.EnsureUserExists(IUser user) at Umbraco.Forms.Web.FormsSecurity.CanCurrentUserManageForms() at Umbraco.Forms.Web.Trees.FormTreeController.CreateRootNode(FormDataCollection queryStrings) at Umbraco.Web.Trees.TreeControllerBase.GetRootNode(FormDataCollection queryStrings) in \\psf\Home\Documents\test\Umbraco-CMS\src\Umbraco.Web\Trees\TreeControllerBase.cs:line 75 at Umbraco.Web.Trees.ApplicationTreeExtensions.<TryGetRootNodeFromControllerTree>d__5.MoveNext() in \\psf\Home\Documents\test\Umbraco-CMS\src\Umbraco.Web\Trees\ApplicationTreeExtensions.cs:line 162 --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Runtime.CompilerServices.TaskAwaiter1.GetResult() at Umbraco.Web.Trees.ApplicationTreeController.d__1.MoveNext() in \psf\Home\Documents\test\Umbraco-CMS\src\Umbraco.Web\Trees\ApplicationTreeController.cs:line 87 --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Runtime.CompilerServices.TaskAwaiter1.GetResult() at Umbraco.Web.Trees.ApplicationTreeController.<GetApplicationTrees>d__0.MoveNext() in \\psf\Home\Documents\test\Umbraco-CMS\src\Umbraco.Web\Trees\ApplicationTreeController.cs:line 65 --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Threading.Tasks.TaskHelpersExtensions.<CastToObject>d__31.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() 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.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Web.Http.Filters.ActionFilterAttribute.d__5.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Web.Http.Filters.ActionFilterAttribute.d__5.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Web.Http.Filters.ActionFilterAttribute.d__0.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Web.Http.Filters.ActionFilterAttribute.d__5.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Web.Http.Filters.ActionFilterAttribute.d__5.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Web.Http.Filters.ActionFilterAttribute.d__0.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Web.Http.Filters.ActionFilterAttribute.d__5.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Web.Http.Filters.ActionFilterAttribute.d__5.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Web.Http.Filters.ActionFilterAttribute.d__0.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Web.Http.Filters.ActionFilterAttribute.d__5.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Web.Http.Filters.ActionFilterAttribute.d__5.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Web.Http.Filters.ActionFilterAttribute.d__0.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() 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.ExceptionServices.ExceptionDispatchInfo.Throw() 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.ExceptionServices.ExceptionDispatchInfo.Throw() 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.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Web.Http.Dispatcher.HttpControllerDispatcher.d__1.MoveNext()

Comments

Mads Rasmussen 21 Aug 2017, 13:44:56

I have tested this again on a fresh build and it was just my local setup going crazy. I will close this issue again.


Arnold Visser 16 Feb 2018, 09:11:42

@madsrasmussen @warren.buckley

This keeps happening when working locally with forms in an Umbraco Cloud project. It seems to be looking at certain files to exists en then not creating the table. Seems to cause issues when restoring from cloud, since those files will be there in source control.

Would be really nice to have the information which files/things are checked before creating the table, so we can properly pinpoint what is happening.


Sebastiaan Janssen 16 Feb 2018, 09:39:28

@arnold What Umbraco and Forms version are we talking about?


Sebastiaan Janssen 16 Feb 2018, 09:41:16

As far as I know there's an installed marker in ~/App_Plugins/UmbracoForms if that file is there, Forms doesn't try to create new tables on startup. So I'd recommend not committing that file to git (it should be ignored by default).


Arnold Visser 16 Feb 2018, 09:41:59

@sebastiaan

  • Umbraco 7.7.11
  • Forms 6.0.5
  • Deploy 2.0.11


Arnold Visser 16 Feb 2018, 09:43:03

@sebastiaan thanks, that might do the trick! let you know!

Seems to do the trick, easy fix then, but nice to know how this works.

Might be something to add to the error message? Of maybe if this error create table?


Priority: Normal

Type: Task

State: Open

Assignee:

Difficulty: Normal

Category:

Backwards Compatible: True

Fix Submitted:

Affected versions: 7.7.0

Due in version:

Sprint: Sprint 66

Story Points: 0.5

Cycle: