Pivot Table - memory access out of bounds

[Dionisio Luis]

Good Evening,

I'm getting this error : memory access out of bounds   RuntimeError: memory access out of bounds .

This error happens when I past more then 1800 rows to PivotTable.

Any one have found the way to bypass or fix this situation ?

Below you have my code.

Best Regards,

Dionisio Luis

This is my code:

Controller:

<EjsPivotView TValue="ChartAndPivotGenericDataSourceModel" ShowFieldList="false">

        <PivotViewDataSourceSettings DataSource="DataSource" AllowLabelFilter="false">

            <PivotViewRows>

                <PivotViewRow Name="XNAME" Caption="Store House" />

            </PivotViewRows>

            <PivotViewValues>

                <PivotViewValue Name="PROD_QTD" Caption="Quantity" />

                <PivotViewValue Name="PVA_GROSS" Caption="Gross" />

                <PivotViewValue Name="PVA_NET" Caption="Net" />

            </PivotViewValues>

            <PivotViewFormatSettings>

                <PivotViewFormatSetting Name="PVA_GROSS" Format="000,00€" />

                <PivotViewFormatSetting Name="PVA_NET" Format="000,00€" />

            </PivotViewFormatSettings>

            <PivotViewFilterSettings>

            </PivotViewFilterSettings>

        </PivotViewDataSourceSettings>

    </EjsPivotView>

 public void Load(IEnumerable<ChartAndPivotGenericDataSourceModel> dataSource)

    {

        Console.WriteLine($"PivotControl - Load:{dataSource.Count()}");

        DataSource = dataSource;

        StateHasChanged();

    }

Blazor Page:

 pivotCustomerSales.Load(

                SalesEntity.Customer

                            .Select(s => new ChartAndPivotGenericDataSourceModel()

                            {

                                XNAME = s.CUSTOMER_NOME,

                                DATA_SALES = s.DATA_SALES,

                                PROD_QTD = s.PROD_QTD,

                                PROD_QTD_PYG = 0,//(Int32)Math.Abs(s.PROD_QTD * ((decimal)new Random().Next(25, 176) / 100)),

                                PROD_BONUS = s.PROD_BONUS,

                                PROD_BONUS_PYG = 0,//(Int32)Math.Abs(s.PROD_BONUS * ((decimal)new Random().Next(25, 176) / 100)),

                                PVA_NET = s.PVA_NET,

                                PVA_NET_PYG = 0,//s.PVA_NET * ((decimal)new Random().Next(25, 176) / 100),

                                PVA_GROSS = s.PVA_GROSS,

                                PVA_GROSS_PYG = 0,//s.PVA_GROSS * ((decimal)new Random().Next(25, 176) / 100),

                            }).OrderByDescending(o => o.PVA_GROSS).Take(1800));

[Sivamathi Natarajan]

Hi Dionisio, 

 

Thanks for using Syncfusion products.

We suspect that the issue arises due to the lack of buffer size in the application. So, could you please increase the buffer size in Startup.cs file with the help of below code example.  

 

Code Example: 

 

[ Startup.cs ] 

 

        public void ConfigureServices(IServiceCollection services) 

        {
            ……. 

            ……. 

            services.AddSignalR(e => 

            { 

                e.MaximumReceiveMessageSize = 102400000; 

            });
           ….
        } 

If this doesn’t work could you please provide us more details like type of project(Server side or WASM) or a sample with replication steps.

Regards, 

Sivamathi. 

[Dionisio Luis]

Good Evening, 
Sorry i didnt know that you guys answered the question, I was waiting for an EMAIL saying that you repply ...

The application type is WASM ( Client Side )

I've tryed to add your line of code but it says :

     IServiceCollection does not contain a definition for 'AddSignalIR' .

So the application is:
WASM Client side that request huge  JSON information ( to an API.)

Then on the client We want to display it on PIVOT ( that error occur )


The way i try to solve the situation : but still got other problem. 
If I use EnableVirtualization="true"  it Solve the situation, BUT --> when I update the DataSource for the Pivot, the Pivot doesnt update, its like the "EnableVirtualization" keep the Last memory and doesnt update ...

[Sivamathi Natarajan]

Hi Dionisio, 

 

Sorry for the inconvenience cause. 

 

The provided code is applicable for server side Blazor application but you are using client side(WASM) Blazor application. So, it made the compilation problem. 

 

And, you are using large size of data source. So, we suggest you to enable the feature “Virtual Scrolling” to avoid such kind of memory problems. But, in the feature, the dynamic data source update isn’t working. So, we considered it as a bug and created a defect report in our data base. And the fix will be available in our weekly patch release which is estimated to be rolled out on (15th April, 2020). Kindly track the bug in the following link. 

 

https://www.syncfusion.com/feedback/13081 

 

We appreciate your patience until then. 

 

Regards, 

Sivamathi. 

[Dionisio Luis]

Hi Dionisio, 

 

Sorry for the inconvenience cause. 

 

The provided code is applicable for server side Blazor application but you are using client side(WASM) Blazor application. So, it made the compilation problem. 

 

And, you are using large size of data source. So, we suggest you to enable the feature “Virtual Scrolling” to avoid such kind of memory problems. But, in the feature, the dynamic data source update isn’t working. So, we considered it as a bug and created a defect report in our data base. And the fix will be available in our weekly patch release which is estimated to be rolled out on (15th April, 2020). Kindly track the bug in the following link. 

 

https://www.syncfusion.com/feedback/13081 

 

We appreciate your patience until then. 

 

Regards, 

Sivamathi. 

Good Evening, i know there is an issue reported already :

 
will this update will be out on day 15 ?
This situation still happening with the current version - 18.1.0.42 

The VirtualScroll is not letting me update the datasource data.

I need to know, for me to decide, if i change from Pivot to Grid

[Sivamathi Natarajan]

Hi Dionisio, 

 

The reported issue has been fixed and the fix will be available in our upcoming weekly patch release which is estimated to be rolled out on tomorrow (April 15, 2020). 

 

We appreciate your patience until then. 

 

Regards, 

Sivamathi. 

[Sivamathi Natarajan]

Hi Dionisio, 

Thanks for the patience. 

Our weekly patch release (v18.1.0.44) has been rolled out where we have included the fix for the reported problem. Now, with virtual scrolling the component will be refreshed by dynamically changing its data source. Meanwhile we have prepared a sample for your reference which is available in below link. 

Sample link:  https://www.syncfusion.com/downloads/support/directtrac/general/ze/PivotClient-1783999506  

Regards,
Sivamathi. 

[Dionisio Luis]

Good Evening, 

I've tested your example project, and its working 100% success.

On my project is not working at all.

I'm breaking my code to smaller  example to see what  i'm doing "wrong" .

But :
The PivotView is in an Controller, and after the dataTable is updated, I do StateHasChanged, and nothing ...

But I will see if the problem is mine or not ...

Will give you feedback tommorow .

[Manikandan Murugesan]

Hi Dionisio, 

 

Thanks for the update. 

 

We will wait until we hear from you. 

Also, please let us know the more details about the problem with screen shot/video (if possible), so that we can work towards to resolve it. 

 

Thanks, 

Manikandan. 

[Dionisio Luis]

Good Morning,

The issue is corrected :) 

Thank you for the fast resolving and patching.

You can close this case .

Best Regards,

Dionisio Luis

[Sivamathi Natarajan]

Hi Dionisio Luis, 

 

Thanks for the reply. As always, we will happy to assist you. And we will close the forum. 

 

Regards, 

Sivamathi.