topic Re: Remove Warning From SAS VA List/Cross Objects in SAS Visual Analytics

Remove Warning From SAS VA List/Cross Objects

Akash93 — Fri, 18 Feb 2022 12:53:51 GMT

Hi Team, Is there option to hide warning shown in attached from VA objects. We are able see all data (maximum rows is 30 k & 29 columns).However, We are getting in viewer. Is there option to remove such warning. Regards, Akash

Re: Remove Warning From SAS VA List/Cross Objects

Akash93 — Fri, 18 Feb 2022 12:59:43 GMT

Hi Team,

Please find attached for warning.

Regards,

Akash

Re: Remove Warning From SAS VA List/Cross Objects

Madelyn_SAS — Fri, 18 Feb 2022 14:44:09 GMT

The warning means that there are more rows to display. Even one extra row would cause that message. On the Options tab, try increasing the value in the Override system data limit option.

Re: Remove Warning From SAS VA List/Cross Objects

Akash93 — Tue, 22 Feb 2022 15:43:28 GMT

Hi

We row limit is already set to 40k and our total data is 29k only.

Regards,
Akash

Re: Remove Warning From SAS VA List/Cross Objects

Madelyn_SAS — Tue, 22 Feb 2022 18:46:30 GMT

To see how many rows that are actually being returned, you can do this:

Note: I do not recommend posting any query results to the community.

Open the report and select the list table.
Press CTRL+ALT+Q to open the query diagnostics window.
Next to the drop-down list with the name of the list table is a > icon. Click that icon to run the query just for that table.
When it is finished, more tabs will display in the window.
On the o Results tab, look at the bottom for the section that starts <DataFile>.
There are two values to look at here: rowCount and availableRowCount. rowCount is how many rows the table is displaying. availableRowCount is the number of rows actually returned. In this case, the availableRowCount is likely higher than the rowCount.
Next, look at the Server tab.
Scroll to the bottom where you will see propery names and their values. One of the values should match the rowCount you see on the oResults tab. This is the property that would have to be increased in order to display all available rows and avoid the warning.

More information about cardinality can be found here: https://support.sas.com/kb/62/148.html . If you have trouble with the query diagnsotics, then let us know what version you are using.

Re: Remove Warning From SAS VA List/Cross Objects

Akash93 — Wed, 02 Mar 2022 09:35:41 GMT

Hi Madelyn,

We are getting desired details by following suggested steps till point # 6.

We are unable to get details for below points :

7. Next, look at the Server tab.
8. Scroll to the bottom where you will see propery names and their values. One of the values should match the rowCount you see on the oResults tab.
This is the property that would have to be increased in order to display all available rows and avoid the warning.

Our Current SAS VA version is : 7.51

Regards,
Akash

Re: Remove Warning From SAS VA List/Cross Objects

Madelyn_SAS — Wed, 02 Mar 2022 21:49:57 GMT

Unfortunately, the query diagnostics in 7.51 do not work as well as the diagnostics in Visual Analytics on SAS Viya.

But the most likely limit that is being exceeded is viewerservices.default.max.cells.produced on Transport Services. This property is mentioned in Reference for Selected Properties for All Transport Services Clients

The default is 250,000. Typically, that value is sufficient. You can try increasing this to 400,000 and see if it allows all rows to display. You do this in SAS Management Console. The documentation above has the steps to change a limit on transport services. Note that increasing limits can cause the system to become unstable. You will need to reduce the limit if that occurs.