RadPivotGrid no data after update

10 posts, 0 answers
  1. Lip Kee
    Lip Kee avatar
    3 posts
    Member since:
    Mar 2015

    Posted 20 Aug 2015 Link to this post

    I have a problem where after I dragged Branch ID into the Row Area and update, the pivotgrid will load for some time and show empty result. Results will show if Branch ID is not dragged into row area. 

    I have tried the same scenario in Visual Studio 2008 SSAS and it successfully shows the result.

    Thanks.

  2. Angel Petrov
    Admin
    Angel Petrov avatar
    1006 posts

    Posted 25 Aug 2015 Link to this post

    Hello,

    I am sorry to say but the provided information is not sufficient for us to determine what causes this problem. Could you please share with us the page contents(markup and code-behind) so we could examine the setup?

    Regards,
    Angel Petrov
    Telerik
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
  3. UI for ASP.NET Ajax is Ready for VS 2017
  4. Lip Kee
    Lip Kee avatar
    3 posts
    Member since:
    Mar 2015

    Posted 25 Aug 2015 in reply to Angel Petrov Link to this post

    Here my code:

     <%@ Page Title="Home Page" Language="VB" MasterPageFile="~/Site.Master" AutoEventWireup="false"
        CodeFile="Default.aspx.vb" Inherits="_Default" %>

    <%@ Register Assembly="Telerik.Web.UI" Namespace="Telerik.Web.UI" TagPrefix="telerik" %>

    <asp:Content ID="HeaderContent" runat="server" ContentPlaceHolderID="HeadContent">
    </asp:Content>
    <asp:Content ID="BodyContent" runat="server" ContentPlaceHolderID="MainContent">
        <telerik:RadScriptManager runat="server" ID="RadScriptManager1" />

        <telerik:RadPivotGrid AllowSorting="True" ID="RadPivotGrid1" 
            FieldsPopupSettings-AggregateFieldsMinCount="2" AllowPaging="True"
                PageSize="20" runat="server" EnableConfigurationPanel="True" EnableZoneContextMenu="True"
                AggregatesPosition="Rows" ResolvedRenderMode="Classic">
                <PagerStyle AlwaysVisible="true" />
                <OlapSettings ProviderType="Adomd">
                    <AdomdConnectionSettings Cube="TSBA_Movement"
                        ConnectionString="Provider=MSOLAP;Data Source=N0903;Initial Catalog=TSBA_Movement;"></AdomdConnectionSettings>
                </OlapSettings>
                <RowHeaderCellStyle Width="100px" />
                <ConfigurationPanelSettings Position="FieldsWindow" LayoutType="OneByFour" DefaultDeferedLayoutUpdate="true" />
                <ClientSettings>
                    <Scrolling AllowVerticalScroll="false" ScrollHeight="600px" />
                </ClientSettings>
            </telerik:RadPivotGrid>
    </asp:Content>

     

    Pretty straightforward but I have no idea why it does not work.

     

    I have simplified my question. I have attached results with and without measurement. With measurement with multiple column fields will results in empty data.

  5. Angel Petrov
    Admin
    Angel Petrov avatar
    1006 posts

    Posted 28 Aug 2015 Link to this post

    Hello,

    We managed to reproduce the problem on our end. We are currently researching what is causing it and hope to find the root cause soon. I will post additional details regarding the matter in this thread as soon as possible.


    Regards,
    Angel Petrov
    Telerik
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
  6. Lip Kee
    Lip Kee avatar
    3 posts
    Member since:
    Mar 2015

    Posted 31 Aug 2015 in reply to Angel Petrov Link to this post

    Appreciated. Hope to hear from you soon.
  7. Angel Petrov
    Admin
    Angel Petrov avatar
    1006 posts

    Posted 03 Sep 2015 Link to this post

    Hi,

    We have thoroughly investigated the matter and it seems that there is a problem in the pivot engine. It is already logged into the system and our dev team will do their best to provide a fix for it as soon as possible. You can monitor our progress on the matter from here.

    We apologize for any inconvenience this problem may have caused you.

    Regards,
    Angel Petrov
    Telerik
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
  8. Fanny
    Fanny avatar
    1 posts
    Member since:
    Sep 2015

    Posted 08 Sep 2015 in reply to Angel Petrov Link to this post

    Hi,

    I am having the same problem, the pivotgrid show empty result after update.

     

    How can I know is the fix has been provided? or when it will be?

     I did click on the link you wrote but i cannot see anything related to the pivotgrid.

     

    Thanks

     

     

  9. Angel Petrov
    Admin
    Angel Petrov avatar
    1006 posts

    Posted 11 Sep 2015 Link to this post

    Hi,

    The RadPivotGrid for ASP.NET AJAX uses the pivot engine of the WPF pivot grid and this is the feedback item logged for the problem when OLAP binding is used and no data is displayed. In order to speed things up I suggest voting for the item thus increasing its priority.

    As for the fix I am sorry to say but I can not provide a certain time frame in which it will be available. That said I suggest monitoring the feedback item for progress on the matter.

    Regards,
    Angel Petrov
    Telerik
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
  10. Prasad
    Prasad avatar
    2 posts
    Member since:
    Jul 2016

    Posted 28 Sep in reply to Angel Petrov Link to this post

    Was this bug fixed? I am having the same problem. Google the error and got this page, so wondering if this is fixed?
  11. Maria Ilieva
    Admin
    Maria Ilieva avatar
    4017 posts

    Posted 03 Oct Link to this post

    Hi Prasad,

    Unfortunately the mentioned issue is still not fixed in the Pivot engine. I would suggest you to vote and follow the public item below so that you can check its progress in future:
    http://feedback.telerik.com/Project/143/Feedback/Details/168231-pivotgrid-outofmemoryexception-is-thrown-when-heavy-grouping-is-performed-and-th

    Excuse us for inconvenience this issue may lead.


    Regards,
    Maria Ilieva
    Telerik by Progress
    Do you need help with upgrading your ASP.NET AJAX, WPF or WinForms projects? Check the Telerik API Analyzer and share your thoughts.
Back to Top
UI for ASP.NET Ajax is Ready for VS 2017