Problem Note 70697: The message "WARNING: Invalid date value '1581-1-1'" occurs when loading Oracle DATE and TIMESTAMP values into SAS® Cloud Analytic Services (CAS)
 |  |  |  |  |
When loading Oracle DATE and TIMESTAMP data types to CAS, some of the rows might not load.
This issue occurs for values that are in the year range 0100-1581.
If using the numReadNodes=1 data connector option, a WARNING is written to the SAS log for each row that is not loaded. Here is an example:
If more than one CAS Worker node is available, and numReadNodes is 0 or greater than 1, no messages are written to the SAS log. However, CAS Worker logs might display a WARN message that is similar to the following:
In addition, for each invalid date, an INFO message similar to the following occurs:
Workaround
The only workaround for this issue is to use an Oracle LIBNAME to load your data to CAS.
Click the Hot Fix tab in this note for a link to instructions about accessing and applying the software update.
After applying the hot fix, you can add the invalidDate= option to your CASLIB. Here are the valid options:
- ERROR specifies that when an invalid DATE or DATETIME value is detected, loading the record fails, and an error is printed in the SAS log.
- SILENT specifies that SAS converts an invalid DATE or DATETIME value to a missing value, and no message is printed in the SAS log.
- WARN specifies that SAS converts an invalid DATE or DATETIME value to a missing value and prints a warning in the SAS log.
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 | Viya | ||
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| Type: | Problem Note |
| Priority: | alert |
| Date Modified: | 2024-03-20 17:07:29 |
| Date Created: | 2024-03-11 06:08:16 |