Developer forum

Forum » Dynamicweb 9.0 Upgrade issues » After upgrade to 9.10.15 Marketing not working

After upgrade to 9.10.15 Marketing not working

Andrejs Zavorotnijs
Reply

Hi

I find out, that after update Marketing not working

 

And the problem is

2021-10-21 10:15:30.203: TopFolderDescription. System.IndexOutOfRangeException: TopFolderDescription
at System.Data.ProviderBase.FieldNameLookup.GetOrdinal(String fieldName)
at System.Data.SqlClient.SqlDataReader.GetOrdinal(String name)
at System.Data.SqlClient.SqlDataReader.get_Item(String name)
at Dynamicweb.EmailMarketing.TopFolder.Fill(IDataReader reader)
at Dynamicweb.EmailMarketing.TopFolder.GetTopFolderBySql(CommandBuilder sql)
at Dynamicweb.Management.Marketing.MarketingNavigator.GetEmailRootNodes(Nullable`1 selectMode)
at Dynamicweb.Management.Marketing.MarketingNavigator.GetEmailMarketingNodes(Nullable`1 selectMode, String path, IDictionary`2 requestParams)
at Dynamicweb.Management.Marketing.MarketingNavigator.GetNodes(String path, IDictionary`2 requestParameters)
at Dynamicweb.Management.NavigatorController.GetNodes(String path, IDictionary`2 requestParams, List`1 navigators)
at Dynamicweb.Management.NavigatorController.Nodes(String navigator, String path, IDictionary`2 requestParams)
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.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 System.Web.Mvc.Controller.<BeginExecuteCore>b__1d(IAsyncResult asyncResult, ExecuteCoreState innerState)
at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncVoid`1.CallEndDelegate(IAsyncResult asyncResult)
at System.Web.Mvc.Controller.EndExecuteCore(IAsyncResult asyncResult)
at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncVoid`1.CallEndDelegate(IAsyncResult asyncResult)
at System.Web.Mvc.Controller.EndExecute(IAsyncResult asyncResult)
at System.Web.Mvc.MvcHandler.<BeginProcessRequest>b__5(IAsyncResult asyncResult, ProcessRequestState innerState)
at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncVoid`1.CallEndDelegate(IAsyncResult asyncResult)
at System.Web.Mvc.MvcHandler.EndProcessRequest(IAsyncResult asyncResult)
at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step)
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
2021-10-21 10:15:30.203: Request headers: [   "Connection",   "Accept",   "Accept-Encoding",   "Accept-Language",   "Cookie",   "Host",   "Referer",   "User-Agent",   "sec-ch-ua",   "DNT",   "X-Requested-With",   "sec-ch-ua-mobile",   "sec-ch-ua-platform",   "Sec-Fetch-Site",   "Sec-Fetch-Mode",   "Sec-Fetch-Dest" ]
2021-10-21 10:15:30.219: Request item keys: [   "owin.Environment",   "ExecutionTableMapper",   "Translate.IsFrontEnd",   "AspSession",   "Dynamicweb.Environment.Web",   "All emails.False",   "Permissions.False",   {},   "PermissionContextStack",   "alternateUrlKey",   "Dynamicweb.RewriteUrl",   "AspSessionIDManagerInitializeRequestCalled" ]
2021-10-21 10:15:30.219: Request form: []

 

So after update Column TopFolderDescription in table EmailMarketingTopFolder not creates.

I check Local solution and last 3 solution which we updated some time ago, all have same issue.

 


Replies

 
Oleg Rodionov Dynamicweb Employee
Oleg Rodionov
Reply
This post has been marked as an answer

Hi,

Yes, appropriate code was not added to update script on DW9.10 (OK on DW9.12 admin). I've created new task #5313 will fix the bug. I hope the fix will be provided in upcoming DW9.10 release. As workaroud now you can solve it wiith pefroming the following SQL command in Settings-Database-SQL Farehose: 

ALTER TABLE [EmailMarketingTopFolder] ADD [TopFolderDescription] NVARCHAR(MAX) NULL 

and recycle IIS pool of your solution via Settings-Web and HTTP-Host headers-Recycle application pool

Thanks for finding, sorry for inconvinience.

BR, Oleg QA   

Votes for this answer: 2

 

You must be logged in to post in the forum