In SAS/ACCESS^® Interface to ODBC or SAS/ACCESS^® Interface to Microsoft SQL, tables that contain the NVARCHAR(MAX) data type are loaded into SAS^® Cloud Analytic Services (CAS) slowly.

When sampling the data in SAS^® Visual Analytics, you see this error:

When loading data into CAS, you might receive this warning:

Click the Hot Fix tab in this note to access the hot fix for this issue.

After you apply the hot fix, specify this option when loading the table. Set the blobThreshold value to the length of your longest column, as shown here:

SAS does some performance tuning and quickly loads your table containing NVARCHAR(MAX).

Operating System and Release Information

Product Family	Product	System	Product Release		SAS Release
			Reported	Fixed*	Reported	Fixed*
SAS System	SAS Data Connector to Microsoft SQL Server	Linux for x64	V.03.03	V.03.05	Viya	Viya
SAS System	SAS Data Connector to ODBC	Linux for x64	V.03.03	V.03.05	Viya	Viya

* 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.

---

An update for this issue is available for SAS Viya 3.3. For instructions on how to access and apply software updates, see the Managing Your Software section of the SAS Viya 3.3 Administration document at

http://documentation.sas.com/?softwareId=administration&softwareVersion=3.3&softwareContextId=softwareUpdates

---

In SAS/ACCESS® Interface to ODBC or SAS/ACCESS® Interface to Microsoft SQL, tables are slow to load into CAS when they contain the NVARCHAR(MAX) data type. Also, when sampling the data in SAS® Visual Analytics, you see the error "An unexpected error has occurred."

Type:	Problem Note
Priority:	high

Date Modified:	2018-09-10 14:44:21
Date Created:	2018-08-07 14:43:33