SAS Viya - reset a server limit to allow more than 40,000 rows

barbe1lj — Tue, 04 Aug 2020 19:57:37 GMT

Hello,

Does anyone know how to reset a server limit to allow more than 40,000 rows to show within a disaggregated listbox in SAS Viya VA? We reset the ListBox settings from 40,000 to 2,000,000 and the dataset is still only showing up to 84,000 rows.

After we increased the limit we see the error: Not all of the data appears because the client query row limit exceeds the server threshold.

Re: SAS Viya - reset a server limit to allow more than 40,000 rows

Madelyn_SAS — Tue, 04 Aug 2020 20:05:33 GMT

You are likely running into a server-side limit. This note explains the limits:

https://support.sas.com/kb/62/148.html

topic Re: SAS Viya - reset a server limit to allow more than 40,000 rows in SAS Visual Analytics

SAS Viya - reset a server limit to allow more than 40,000 rows

Re: SAS Viya - reset a server limit to allow more than 40,000 rows