Current filter:
                                You should refresh the page.
                                  • Getting the following error when using large data sets in pivot grid.  Seems to happen every time when we go over 200k rows, and about 9MB of data

                                    core.js:15714 ERROR TypeError: dimension.selector is not a function
                                        at fillHierarchyItemIndexesCore (local_store.js:126)
                                        at generateHierarchyItems (local_store.js:149)
                                        at generateAggregationCells (local_store.js:155)
                                        at processData (local_store.js:363)
                                        at ZoneDelegate.push../node_modules/zone.js/dist/zone.js.ZoneDelegate.invokeTask (zone.js:421)
                                        at Object.onInvokeTask (core.js:17280)
                                        at ZoneDelegate.push../node_modules/zone.js/dist/zone.js.ZoneDelegate.invokeTask (zone.js:420)
                                        at Zone.push../node_modules/zone.js/dist/zone.js.Zone.runTask (zone.js:188)
                                        at push../node_modules/zone.js/dist/zone.js.ZoneTask.invokeTask (zone.js:496)
                                        at ZoneTask.invoke (zone.js:485)

                                    Sometimes we get this error instead, it depends on the state of the layout.

                                    core.js:15714 ERROR TypeError: cellField.selector is not a function
                                        at aggregationStep (local_store.js:224)
                                        at processData (local_store.js:364)
                                        at ZoneDelegate.push../node_modules/zone.js/dist/zone.js.ZoneDelegate.invokeTask (zone.js:421)
                                        at Object.onInvokeTask (core.js:17280)
                                        at ZoneDelegate.push../node_modules/zone.js/dist/zone.js.ZoneDelegate.invokeTask (zone.js:420)
                                        at Zone.push../node_modules/zone.js/dist/zone.js.Zone.runTask (zone.js:188)
                                        at push../node_modules/zone.js/dist/zone.js.ZoneTask.invokeTask (zone.js:496)
                                        at ZoneTask.invoke (zone.js:485)
                                        at timer (zone.js:2054)

                                    We're using Angular 7.2.2 with Devextreme 19.1.5 (it also happened in 18.x, tried upgraded to 19.1.5 to see if it fixed the issue)

                                • Ilya (DevExpress Support) 08.22.2019

                                  Hi,
                                  Would you please share your data file along with your PivotGrid configuration so I can reproduce the issue on my side? Alternatively, share a link to an online sample. You can edit one of our demo apps in CodeSandBox to show your scenario.

                                • Customer95394 08.22.2019

                                  I'll try and get a sample together that reproduces the bug.  I don't have any test data I can give, and our app will not run on its own

                                • Ilya (DevExpress Support) 08.22.2019

                                  I appreciate your cooperation and look forward to your sample.

                                1 Solution

                                Creation Date Importance Sort by

                                So, in the process of making a demo I figured out the issue.

                                We store the grid state separately, and we set it when the user loads the page via:

                                this.DataSource.state(this.layout);

                                We do this asynchronously though., and when the grid is processing the data, setting the state causes this error.  Around 200k items in my case seems to be where the grid was taking long enough to process that we were setting the state at a bad time.

                                Is there a way to know if the grid is currently processing data? I'll not try to set the state it till I know that has finished.  

                                • Lex (DevExpress Support) 08.23.2019

                                  Hi,
                                   
                                  I'm happy to hear that the issue has been resolved!
                                   
                                  As for the event, you can try the approaches from the following threads:
                                  dxDataGrid - How to determine if datasource is loaded
                                  DataGrid - How to know when the data grid is fully loaded
                                   
                                  Although these threads describe how to accomplish this task in our jQuery DataGrid, similar approaches can be used in Angular too.
                                   
                                  Let me know if you have further questions.
                                   

                                • Customer95394 08.23.2019

                                  Does Pivot Grid have a similar api?

                                • Lex (DevExpress Support) 08.23.2019

                                  Yes, our PivotGrid has a similar API.