Unplanned
Last Updated: 16 Sep 2021 10:37 by ADMIN
LindenauAtSOG
Created on: 06 Aug 2021 12:29
Category: UI for WPF
Type: Bug Report
2
pivot grid never finishes loading
Bug can be observed using the Demo => PivotGrid => More OLAP Examples

Setup like so and hit refresh


A customer reported this issue. We could observe that the memory of the process was exploding, this doesnt happen in the demo for some reason.
Using the old RadarSoft  WinForms Pivot Control, the same view that our customer had issues with, is loading in a reasonable time.



Please also make sure that in future releases you add some cancel functionality so one doesn't have to restart the application....
7 comments
ADMIN
Dilyan Traykov
Posted on: 16 Sep 2021 10:37

Hello,

It is not of importance what data is used as long as we manage to replicate the same exception which is causing the issue at your end. If you find it useful, you can use the data from the database used in our demo application. The connection string for it is the following:

            <pivot:AdomdDataProvider.ConnectionSettings>
                <pivot:AdomdConnectionSettings 
           Cube="Adventure Works" 
                    Database="Adventure Works DW 2008R2" 
             ConnectionString = "Data Source=https://demos.telerik.com/olap/msmdpump.dll;Catalog=Adventure Works DW 2008R2">
                </pivot:AdomdConnectionSettings>
            </pivot:AdomdDataProvider.ConnectionSettings>

Please let me know if you find this helpful.

Regards,
Dilyan Traykov
Progress Telerik

Love the Telerik and Kendo UI products and believe more people should try them? Invite a fellow developer to become a Progress customer and each of you can get a $50 Amazon gift voucher.

LindenauAtSOG
Posted on: 15 Sep 2021 13:23

Hello Dilyan,

 

I do not believe it is possible to provide you the SSAS-Database of our customer.

Is there any other approach we can try to reproduce this issue?
Do you have any "Adomd-Testdata" that i could play arround with?
Or is it the configuration in SSAS that is of importance for you, not so much the data behind it?

ADMIN
Dilyan Traykov
Posted on: 09 Sep 2021 09:07

Hello,

Indeed, if you're not using the XmlaDataProvider which is used in the demo application in which I tested this exception, it is possible that the cause of the exception is different.

With this said, we would need to be able to replicate this exception at our end to be able to investigate a possible solution for it. If you do not wish to share your project publicly, you can open a new support ticket and provide it there. Please let me know if you would find this possible.

Regards,
Dilyan Traykov
Progress Telerik

Virtual Classroom, the free self-paced technical training that gets you up to speed with Telerik and Kendo UI products quickly just got a fresh new look + new and improved content including a brand new Blazor course! Check it out at https://learn.telerik.com/.

LindenauAtSOG
Posted on: 03 Sep 2021 07:02

Hello Dilyan,

unfortunately, we are allready using the Adomd one.
This might imply that the problem in the demo application is different to ours? 
I am not sure I can provide a working example then.

ADMIN
Dilyan Traykov
Posted on: 19 Aug 2021 15:23

Hello,

For the time being, you can try to use the AdomdDataProvider instead. I tested it in our demos application with the setup from the image you provided and received a response rather quicker than the XmlaDataProvider (which is used by default) without any exceptions.

Please let me know whether the AdomdDataProvider resolves the exception in your original application as well.

Regards,
Dilyan Traykov
Progress Telerik

Love the Telerik and Kendo UI products and believe more people should try them? Invite a fellow developer to become a Progress customer and each of you can get a $50 Amazon gift voucher.

ADMIN
Dilyan Traykov
Posted on: 13 Aug 2021 08:51

Hello,

Thank you for the provided image and feedback.

I can confirm that I was able to replicate the issue in the demo and have thus logged it in our internal backlog. We will also consider implementing the cancel functionality.

Regards,
Dilyan Traykov
Progress Telerik

Virtual Classroom, the free self-paced technical training that gets you up to speed with Telerik and Kendo UI products quickly just got a fresh new look + new and improved content including a brand new Blazor course! Check it out at https://learn.telerik.com/.

LindenauAtSOG
Posted on: 06 Aug 2021 12:30
Sorry I meant "More PivotGrid Exaples" => "Olap Support"