BuyLog In
Bug Report T319091
Visible to All Users

OutOfMemoryException is thrown in prefilter if a field provides many unique values

created 9 years ago

Hi,
I use PivotGrid in server-mode. My tables have are 150 000 rows.
I open Prefilter. Then choice column with 150 0000 unique values. I get OutOfMemoryException.

It possible disable fetch values in prefilter?

Comments (1)
DevExpress Support Team 9 years ago

    The MVCxPivotGrid control does not provide a way to change prefilter editor. It will require some time to research it in greater detail. I have passed this issue to our developers for further research. We will update the thread once we have any results.

    Sign in to comment on this post

    Answers approved by DevExpress Support

    created 9 years ago

    We have fixed the issue described in this ticket and will include the fix in our next maintenance update. To apply this solution before the official update, request a hotfix by clicking the corresponding link for product versions you require.

    Note: Hotfixes may be unavailable for beta versions and updates that are about to be released.

    Additional information:

    By default, the ComboBox editor is shown in the PivotGrid's Prefilter window. The ComboBox editor is not designed to show many items in it. So, we introduced the new Prefilter.MaxComboBoxItems property. When the number of items in a filtered column is greater than the number specified in the Prefilter.MaxComboBoxItems property, the Text editor will be shown in the Prefilter window instead of the ComboBox editor. The default value of this property is 10000. Please use it to avoid performance degradation when showing many items in the PivotGrid's Prefilter window.

      Comments (2)
      FY FY
      Frolov Yurii 9 years ago

        Hello,
        In the empty grid, opening a prefilter is causing the error.
        Working draft has been updated through the Upgrade Project.
        No changes have been made more.
        Error:
        Value cannot be null.
        Parameter name: source
        StackTrace:
         at System.Linq.Enumerable.Select[TSource,TResult](IEnumerable`1 source, Func`2 selector)
          at DevExpress.PivotGrid.ServerMode.MultipleLevelsQueryExecutor.QueryValuesCore(ISelectCriteriaConvertible column, SortCriteria sort, List`1 filter, Int32 topCount, Boolean isTopPercentage)
          at DevExpress.PivotGrid.ServerMode.MultipleLevelsQueryExecutor.DevExpress.PivotGrid.ServerMode.IServerModeQueryExecutor.QueryValues(IServerModeHelpersOwner owner, QueryColumn column, Dictionary`2 values)
          at DevExpress.PivotGrid.ServerMode.ServerModeDataSource.DevExpress.PivotGrid.ServerMode.IServerModeHelpersOwner.QueryValues(QueryColumn column, Dictionary`2 values)
          at DevExpress.PivotGrid.QueryMode.UniqueValues`1.GetUniqueValues(AreasType column)
          at DevExpress.PivotGrid.QueryMode.UniqueValues`1.GetUniqueValues(PivotGridFieldBase field)
          at DevExpress.Web.ASPxPivotGrid.PivotGridField.DevExpress.Web.FilterControl.IFilterColumn.get_PropertiesEdit()
          at DevExpress.Web.FilterControl.FilterControlColumnBuilder.CreateFilterControlColumn(IFilterColumn externalColumn)
          at DevExpress.Web.FilterControl.FilterControlColumnBuilder.CreateMissingExternalColumns()
          at DevExpress.Web.FilterControl.FilterControlColumnBuilder.GenerateColumns(Object sourceType, Boolean allowHierarchicalColumns, Int32 maxHierarchyDepth, Boolean showAllDataSourceColumns, IEnumerable`1 externalColumns)
          at DevExpress.Web.ASPxPivotGrid.ASPxPivotGrid.GenerateFilterColumns()
          at DevExpress.Web.ASPxPivotGrid.ASPxPivotGrid.DevExpress.Web.FilterControl.IFilterControlOwner.GetFilterColumns()
          at DevExpress.Web.FilterControl.WebFilterCriteriaDisplayTextGenerator.GetFilterColumnName(String propertyName)
          at DevExpress.Web.ASPxPivotGrid.Internal.PivotWebFilterCriteriaDisplayTextGenerator.GetFilterColumnName(String propertyName)
          at DevExpress.Web.FilterControl.WebFilterCriteriaDisplayTextGenerator.DevExpress.Data.Filtering.Helpers.IDisplayCriteriaGeneratorNamesSource.GetDisplayPropertyName(OperandProperty property)
          at DevExpress.Data.Filtering.Helpers.DisplayCriteriaGenerator.Convert(OperandProperty theOperand)
          at DevExpress.Data.Filtering.Helpers.DisplayCriteriaGenerator.Visit(BinaryOperator theOperator)
          at DevExpress.Web.FilterControl.WebFilterCriteriaDisplayTextGenerator…ctor(IFilterControlOwner filterOwner, CriteriaOperator criteria, Boolean encodeValue)
          at DevExpress.Web.ASPxPivotGrid.Internal.PivotWebFilterControlPopupRow.CreateFilterCriteriaDisplayTextGenerator(IFilterControlOwner filterOwner, Boolean encodeValue)
          at DevExpress.Web.FilterControl.WebFilterControlPopupRow.GetFilterCriteriaText(IFilterControlOwner filterOwner, Boolean encodeValue)
          at DevExpress.Web.FilterControl.WebFilterControlPopupRow.CreateControlHierarchy()
          at DevExpress.Web.Internal.InternalTable.CreateChildControls()
          at System.Web.UI.Control.EnsureChildControls()
          at DevExpress.Web.Internal.RenderUtils.EnsureChildControlsRecursive(Control control, Predicate`1 skipControlCondition)
          at DevExpress.Web.Internal.RenderUtils.EnsureChildControlsRecursive(Control control, Predicate`1 skipControlCondition)
          at DevExpress.Web.Internal.RenderUtils.EnsureChildControlsRecursive(Control control, Predicate`1 skipControlCondition)
          at DevExpress.Web.Internal.RenderUtils.EnsureChildControlsRecursive(Control control, Predicate`1 skipControlCondition)
          at DevExpress.Web.Internal.RenderUtils.EnsureChildControlsRecursive(Control control, Predicate`1 skipControlCondition)
          at DevExpress.Web.Internal.RenderUtils.EnsureChildControlsRecursive(Control control, Predicate`1 skipControlCondition)
          at DevExpress.Web.Internal.RenderUtils.EnsureChildControlsRecursive(Control control, Predicate`1 skipControlCondition)
          at DevExpress.Web.Internal.RenderUtils.EnsureChildControlsRecursive(Control control, Predicate`1 skipControlCondition)
          at DevExpress.Web.ASPxPivotGrid.ASPxPivotGrid.EnsureChildControlsRecursive(Control control, Boolean skipContentContainers)
          at DevExpress.Web.ASPxWebControlBase.EnsureChildControlsRecursive(Control control)
          at DevExpress.Web.ASPxWebControlBase.CreateChildControls()
          at DevExpress.Web.ASPxWebControl.CreateChildControls()
          at System.Web.UI.Control.EnsureChildControls()
          at DevExpress.Web.ASPxPivotGrid.ASPxPivotGrid.GetCallbackResult()
          at DevExpress.Web.ASPxWebControl.System.Web.UI.ICallbackEventHandler.GetCallbackResult()

        DevExpress Support Team 9 years ago

          Hello,

          To process your recent post more efficiently, I created a separate ticket on your behalf: T334565: Exception is raised in prefilter if datasource is empty. This ticket is currently in our processing queue. Our team will address it as soon as we have any updates.

          Sign in to comment on this post

          Disclaimer: The information provided on DevExpress.com and affiliated web properties (including the DevExpress Support Center) is provided "as is" without warranty of any kind. Developer Express Inc disclaims all warranties, either express or implied, including the warranties of merchantability and fitness for a particular purpose. Please refer to the DevExpress.com Website Terms of Use for more information in this regard.

          Confidential Information: Developer Express Inc does not wish to receive, will not act to procure, nor will it solicit, confidential or proprietary materials and information from you through the DevExpress Support Center or its web properties. Any and all materials or information divulged during chats, email communications, online discussions, Support Center tickets, or made available to Developer Express Inc in any manner will be deemed NOT to be confidential by Developer Express Inc. Please refer to the DevExpress.com Website Terms of Use for more information in this regard.