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.

1. Log on to SAS^® Management Console as an administrator.
2. On the Plug-ins tab, select Application Management ► Configuration Manager ► SAS Application Infrastructure.
3. Expand Visual Analytics 7.5 ► Visual Analytics Services 7.5.
4. Right-click Visual Analytics Transport Service 7.5, and select Properties.
5. In the Properties dialog box, click the Advanced tab.
6. Click Add to open the Define New Property dialog box.
   1. For the Property Name, enter va.RemoveMaxRowsBehaviorTruncate
   2. For the Property Value, enter true.
7. Click OK twice to exit both dialog boxes and save the changes.
8. Restart your web application server to enforce the new setting.

Operating System and Release Information

Product Family	Product	System	Product Release		SAS Release
			Reported	Fixed*	Reported	Fixed*
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.

---

A fix for this issue for SAS Visual Analytics 7.5 is available at:

https://tshf.sas.com/techsup/download/hotfix/HF2/F9L.html#65330

---

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