Problem Note 65330: Report objects that contain a large amount of data take longer to render in SAS® Visual Analytics 7.5x than in SAS® Visual Analytics 7.4 or earlier
After upgrading to SAS Visual Analytics 7.5 from an earlier release, report objects might take longer to return results. This problem is more apparent if the data being returned contains more than 50,000 rows. In earlier versions, if row limits were exceeded, SAS Visual Analytics quickly returned a warning that too much data was returned. When this issue occurred, the object would either contain no results or truncated results. In release 7.5, the row limit is no longer in place, and the full result is processed until completion. Then, depending on the report object, you see truncated results. If the result set is large enough, it might cause the SAS® LASR™ Analytic Server to crash.
For SAS® Visual Analytics 7.5 on SAS® 9.4M6 (TS1M6), click the Hot Fix tab in this note to access the hot fix for this issue. After you apply the hot fix, follow the steps below to set a new property.
For SAS® Visual Analytics 7.51 on SAS® 9.4M7 (TS1M7), no hot fix is necessary. Follow the steps below to set a new property.
- Log on to SAS® Management Console as an administrator.
- On the Plug-ins tab, select Application Management ► Configuration Manager ► SAS Application Infrastructure.
- Expand Visual Analytics 7.5 ► Visual Analytics Services 7.5.
- Right-click Visual Analytics Transport Service 7.5, and select Properties.
- In the Properties dialog box, click the Advanced tab.
- Click Add to open the Define New Property dialog box.
- For the Property Name, enter va.RemoveMaxRowsBehaviorTruncate
- For the Property Value, enter true.
- Click OK twice to exit both dialog boxes and save the changes.
- Restart your web application server to enforce the new setting.
Operating System and Release Information
SAS System | SAS Visual Analytics | Microsoft® Windows® for x64 | 7.5 | 7.51 | 9.4 TS1M6 | 9.4 TS1M7 |
Linux for x64 | 7.5 | 7.51 | 9.4 TS1M6 | 9.4 TS1M7 |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
After upgrading to SAS Visual Analytics 7.5x from an earlier release, report objects might take longer to return results. This problem is more apparent if the data being returned contains more than 50,000 rows.
Type: | Problem Note |
Priority: | high |
Date Modified: | 2020-02-14 15:59:11 |
Date Created: | 2020-01-10 10:42:59 |