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