List of Items Cannot Be Displayed

Description

When user clicks any modules to display list in the web access, list is not displayed, only error information will pop up.

Web access log contains this error:

2018-02-23 11:32:51,701 ERROR [42] eWay.WebAccess.Presentation.Web.Full.Site.Global: Unhandled exception.
System.Web.HttpUnhandledException (0x80004005): Exception of type 'System.Web.HttpUnhandledException' was thrown. ---> System.InvalidOperationException: DevExpress sort info prescribes sort by property 'State' but no matching descriptor exists in the 'descriptors' argument.
   at eWay.WebAccess.Web.Shared.DevExpress.ConstraintConvertor.ConvertPredicate(FunctionOperator dxOperator, IEnumerable`1 descriptors)
   at eWay.WebAccess.Web.Shared.DevExpress.ConstraintConvertor.ConvertOperator(GroupOperator dxOperator, IEnumerable`1 descriptors)
   at eWay.WebAccess.Presentation.Web.Full.UIModel.Controls.Grid.DevExpress.DataSource.ListServerLogic.SetQueryConstraint(CriteriaOperator filterCriteria, ICollection`1 sortInfo)
   at DevExpress.Data.ServerModeDataController.DoSortRows()
   at DevExpress.Data.DataController.OnRefresh(Boolean useRowsKeeper)
   at DevExpress.Data.DataController.DoRefreshCore(Boolean useRowsKeeper)
   at DevExpress.Data.DataController.DoRefresh(Boolean useRowsKeeper)
   at DevExpress.Data.DataController.EndUpdateCore(Boolean sortUpdate)
   at DevExpress.Web.Data.WebDataControllerProvider.SortGroupChanged(List`1 sortList, Int32 groupCount, String filterExpression, IList groupSummary, IList totalSummary, IList formatConditionSummary)
   at DevExpress.Web.Data.WebDataProxy.SortGroupChanged(List`1 sortList, Int32 groupCount, String filterExpression)
   at DevExpress.Web.ASPxGridBase.SynchronizeDataProxy()
   at DevExpress.Web.ASPxGridBase.BindAndSynchronizeDataProxy()
   at DevExpress.Web.ASPxGridBase.OnFilterChanged()
   at eWay.WebAccess.Presentation.Web.Full.UIModel.Controls.Grid.DevExpress.ASPxItemGrid.ASPxGridView_OnLoad(Object sender, EventArgs e)
   at System.Web.UI.Control.OnLoad(EventArgs e)
   at DevExpress.Web.ASPxWebControl.OnLoad(EventArgs e)
   at DevExpress.Web.ASPxGridBase.OnLoad(EventArgs e)
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
   at System.Web.UI.Page.HandleError(Exception e)
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
   at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
   at System.Web.UI.Page.ProcessRequest()
   at System.Web.UI.Page.ProcessRequest(HttpContext context)
   at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
   at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

Version

All versions of eWay-CRM

Difficulty

Medium

Resolution

The error is caused by the setting of the list when, for example, some columns do not exist in database anymore. It is needed to run procedure that deletes the incorrect setting.

Important: The procedure will erase all user settings that is related to the user on web access.

Procedure is run over the database by this command:

EXEC [eWaySP_DeleteWebAccessSettings] 'username'

The 'username' text must be change to username of user whose lists settings you want to delete

 When the procedure is done, lists in web access will be displayed correctly.