GeoMap error: QVX_SYNTAX_ERROR Too many rows in dataset . Maximum allowed is 20000 rows.

[jasjm90]

Hi Community

We are using  enterprise license, but we are having the following error in oranges occur when loading geomap data

There is no issue loading the same dataset last last week but it occurred both last week and this week.  the last data loaded was at least 5m data set, not sure why now it show max allowed is 20000 rows.

For your advise please

The following error occurred:

Connector reply error: QVX_SYNTAX_ERROR: Failed to process query: Failed to create dataset : Too many rows in dataset . Maximum allowed is 20000 rows.

[Sebastian_Linser · Accepted solution]

Hello @jasjm90 

The Connector has a limit of 20000 rows and 400 routes at a time by default,

if you need to load more rows than that with a single call then you need to allow it on the Server side. This feature is named “bigdata”, to enable it you have to go to Access Module ->Multialiases. Select the name “access:multi:GEOANALYTICSBASIC”. Click on the button Add / Remove Services. This will bring up a window where you can see allowed services in the list to the right, while the list to the left shows more services you can add to the allowed list.

Select geoanalytics:datasets:bigdata which should be in the left list, click on the -> arrow to add it to the allowed services. Then click Done. Now it should be listed under GEOANALYTICSBASIC multialias. If you later want to remove bigdata you can do so by again using Add / Remove Services window but this time find and select the service in the list to the right and use the <- arrow.

The reason that bigdata is not enabled by default is because it can cause trouble and slow down the Server too much with too many users and/or loading too many rows.

https://community.qlik.com/t5/Knowledge/GeoAnalytics-getting-error-QVX-SYNTAX-ERROR-Size-of-dataset-...

Best regards

Sebastian

[giociva]

You save my day with this.

My 2 cents suggestion: since Qlik GeoAnalytics Server is mainly used in an enterprise scenario and this feature is a typical enterprise feature, I think that should be well documented in the Qlik Help GeoAnalytics Site.

I can only find this info in the .docx version of the Qlik GeoAnalytics Data Package Installation Guide.

Thanks and best!