Edit GUI doesn't see Form blocks after upgrading

Vote:
 

I have this peculiar problem where after upgrading EPiServer and rolling out code to my system integration test server, all Form blocks are gone from the view in Edit mode: They're gone from the XHtmlString fields where they are used, also the Forms AND the various folders they were stored in are gone from the Forms tab in Edit. (The Forms tab itself is still there.) Currently headscratching as I didn't experience this problem locally, although my config files for local and system integration test should be similar. From what I can find, I can still see the forms in dbo.tblBigTable by using the WHERE StoreName LIKE 'FormData_%' query, so they've not been deleted (as far as I can tell), I just can't see them.

Versions upgrade:

EPiServer.CMS.Core: 10.3.0, upgrading to 10.10.1
EPiServer.CMS.UI.Core: 10.3.1, upgrading to 10.10.5
EPiServer.Forms: 4.2.1, upgrading to 4.4.0

Database is untouched, save for automatic database version upgrade.

No obviously related errors in browser log.

Anyone else ever experienced this or similar problems, or have any suggestions for where I should start digging?

#181162
Edited, Aug 10, 2017 10:17
Vote:
 

Can you see in the log file if it shows any exception? Also, try to clean APS.NET temp files in: [C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Temporary ASP.NET Files] to re-synchronize content types.

#181164
Aug 10, 2017 10:52
Vote:
 

Thanks, I tried deleting the files (and restarting the app pool in IIS), no luck.

The log has the following error which might be related:

LOGGER="CW.Core.Web.Common.HttpModules.LoggingModule" MESSAGE="
Url=http://(nameofsite)/EPiServer/cms/Stores/contentdata/13072_36260?dojo.preventCache=1502204717608
Method=GET
Status=-1
ErrorId=e3f87a03-a95c-4be8-ab9a-5d8be44863d7
Host=IP Address {1} 7.255.229.171
IP Address {2} 10.47.253.101
IP Address {3} ::1

Client=148.121.176.202
User-Agent=Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/57.0.2987.98 Safari/537.36
Referer=http://(nameofsite)/EPiServer/CMS/?language=no
CustomerId=

System.AggregateException: One or more errors occurred. ---> System.Data.SqlClient.SqlException: Procedure or function 'netApprovalListByQuery' expects parameter '@StartIndex', which was not supplied.
   at System.Data.SqlClient.SqlConnection.OnError(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.SqlDataReader.TryConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.CompleteAsyncExecuteReader()
   at System.Data.SqlClient.SqlCommand.InternalEndExecuteReader(IAsyncResult asyncResult, String endMethod)
   at System.Data.SqlClient.SqlCommand.EndExecuteReaderInternal(IAsyncResult asyncResult)
   at System.Data.SqlClient.SqlCommand.EndExecuteReaderAsync(IAsyncResult asyncResult)
   at System.Threading.Tasks.TaskFactory`1.FromAsyncCoreLogic(IAsyncResult iar, Func`2 endFunction, Action`1 endAction, Task`1 promise, Boolean requiresSynchronization)
--- 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 EPiServer.DataAccess.Internal.ApprovalDB.<>c__DisplayClass14_0.<<ListAsync>b__0>d.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 EPiServer.Data.Providers.Internal.SqlDatabaseHandler.<>c__DisplayClass26_0.<<ExecuteTransactionAsync>b__0>d.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 EPiServer.Data.Providers.SqlTransientErrorsRetryPolicy.<ExecuteAsync>d__12`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 EPiServer.Data.Providers.Internal.SqlDatabaseHandler.<ExecuteTransactionAsync>d__26.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 EPiServer.DataAccess.Internal.ApprovalDB.<ListAsync>d__14.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 EPiServer.Approvals.Internal.DefaultApprovalRepository.<ListAsync>d__7.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 EPiServer.Approvals.ApprovalRepositoryExtensions.<ListAsync>d__4`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 EPiServer.Cms.Shell.UI.Rest.Approvals.Internal.ApprovalService.<GetApprovalAsync>d__7.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 EPiServer.Cms.Shell.UI.Rest.StatusTransition.StatusTransitionService.<GetTransitionsAsync>d__5.MoveNext()
   --- End of inner exception stack trace ---
   at System.Threading.Tasks.Task`1.GetResultCore(Boolean waitCompletionNotification)
   at EPiServer.Cms.Shell.UI.Rest.Models.Transforms.Internal.ContentDataStoreModelTransform.TransformInstance(IContent source, ContentDataStoreModel target, IModelTransformContext context)
   at EPiServer.Cms.Shell.UI.Rest.Models.Transforms.TransformBase`1.<Execute>d__4.MoveNext()
   at EPiServer.Cms.Shell.UI.Rest.Models.Transforms.TransformBase`1.<Execute>d__4.MoveNext()
   at System.Linq.Enumerable.WhereSelectEnumerableIterator`2.MoveNext()
   at System.Linq.Enumerable.First[TSource](IEnumerable`1 source)
   at EPiServer.Cms.Shell.UI.Rest.Internal.ContentDataStore.<>c__DisplayClass10_0.<GetContent>b__0(IContent content)
   at EPiServer.Cms.Shell.UI.Rest.Internal.RestStatusUtil.ExecuteWithSecurityCheck[T](ContentReference contentLink, IContentLoader contentLoader, AccessLevel accessLevel, Func`2 func)
   at EPiServer.Cms.Shell.UI.Rest.Internal.ContentDataStore.GetContent(ContentReference contentReference, DefaultQueryParameters queryParameters)
   at lambda_method(Closure , ControllerBase , Object[] )
   at System.Web.Mvc.ReflectedActionDescriptor.Execute(ControllerContext controllerContext, IDictionary`2 parameters)
   at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext, ActionDescriptor actionDescriptor, IDictionary`2 parameters)
   at System.Web.Mvc.Async.AsyncControllerActionInvoker.<BeginInvokeSynchronousActionMethod>b__39(IAsyncResult asyncResult, ActionInvocation innerInvokeState)
   at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncResult`2.CallEndDelegate(IAsyncResult asyncResult)
   at System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethod(IAsyncResult asyncResult)
   at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<InvokeActionMethodFilterAsynchronouslyRecursive>b__3d()
   at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<>c__DisplayClass46.<InvokeActionMethodFilterAsynchronouslyRecursive>b__3f()
   at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<>c__DisplayClass46.<InvokeActionMethodFilterAsynchronouslyRecursive>b__3f()
   at System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethodWithFilters(IAsyncResult asyncResult)
   at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c__DisplayClass21.<>c__DisplayClass2b.<BeginInvokeAction>b__1c()
   at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c__DisplayClass21.<BeginInvokeAction>b__1e(IAsyncResult asyncResult)
   at System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeAction(IAsyncResult asyncResult)
   at EPiServer.Shell.Services.Rest.RestControllerBase.EndExecute(IAsyncResult asyncResult)
   at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
   at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)"

Which basically tells me "dojo asked for something in the db that went wrong" :P

I have the option of rolling everything back and restoring the epi database now, so I'm going to try one more time.

#181168
Edited, Aug 10, 2017 13:27
Vote:
 

Okay I rolled back the db and the code, and commited the upgrade again, and this time it worked. Apparently something went wrong during the build, so I need to check the build messages more closly if something goes wrong when I roll out this code to other systems.

Thanks for your input!

#181170
Aug 10, 2017 14:09
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.