You encounter slow performance and log messages when you use the multinode mode to load data if one of the following conditions is true:

• Your database management table (DBMS) table does not contain a variable of one of these data types: INT (includes INTEGER, SMALLINT, TINYINT), DECIMAL, or NUMERIC.
• Your DBMS does not support the use of the MOD function on the data type for the variable you chose.

In this scenario, you might see a message similar to the following in your SAS Client log:

Or, you might see a message similar to the following in your CAS log:

Click the Hot Fix tab in this note for a link to instructions about accessing and applying the software update.

This hot fix adds functionality that allows the BIGINT and DOUBLE data types to be included with the variable types that are considered during multinode data transfer.

Operating System and Release Information

Product Family	Product	System	SAS Release
			Reported	Fixed*
SAS System	SAS Data Connector to Vertica	Linux for x64	Viya
SAS System	SAS Data Connector to Amazon Redshift	Linux for x64	Viya
SAS System	SAS Data Connector to Impala	Linux for x64	Viya
SAS System	SAS Data Connector to DB2	Linux for x64	Viya
SAS System	SAS Data Connector to MySQL	Linux for x64	Viya
SAS System	SAS Data Connector to Teradata	Linux for x64	Viya
SAS System	SAS Data Connector to PostgreSQL	Linux for x64	Viya
		Microsoft® Windows® for x64	Viya
SAS System	SAS Data Connector to Microsoft SQL Server	Linux for x64	Viya
		Microsoft® Windows® for x64	Viya
SAS System	SAS Data Connector to Oracle	Linux for x64	Viya
		Microsoft® Windows® for x64	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.4. For instructions on how to access and apply software updates, see the Updating Your SAS Viya software section in the SAS Viya 3.4 for Linux Deployment Guide at

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

---

Viya on Linux: An update for this issue is available for SAS Viya 3.4. For instructions on how to access and apply software updates, see the Updating Your SAS Viya software section in the SAS Viya 3.4 for Linux Deployment Guide at

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

---

When you use the multinode mode, you might see the following in your SAS Client log: “WARNING: Unable to find an acceptable column … Load will proceed with numReadNodes = 1.” Also, you might see the following in your CAS log: “[tkcastkts_load.c:581] - LoadTable: Unable to find column to slice on.”

Type:	Problem Note
Priority:	high

Date Modified:	2019-03-14 14:51:16
Date Created:	2018-07-26 16:10:45