When you try to load Oracle tables using the CASUTIL procedure, the procedure might fail with errors under the following conditions:

• The CASLIB statement contains NUMREADNODES=0.
• The Oracle table contains a column with a DOUBLE data type and some of the values are 0.

In this scenario, you might see the following error in the log:

In addition, the Worker Nodes logs might show the following error:

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

Operating System and Release Information

Product Family	Product	System	Product Release		SAS Release
			Reported	Fixed*	Reported	Fixed*
SAS System	SAS Data Connector to Oracle	Linux for x64	V.03.05	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.

---

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

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

---

Loading an Oracle table fails when you use NUMREADNODES=0 in the CASLIB statement and the Oracle table contains a DOUBLE data type column that has values of 0. In addition to the error in the title, the Worker Nodes logs might return "General error ORA-01428: argument '0' is out of range."

Type:	Problem Note
Priority:	high

Date Modified:	2020-12-18 14:38:47
Date Created:	2020-10-26 16:11:50