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

[barbe1lj]

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.

[Madelyn_SAS]

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

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