SUPPORT / SAMPLES & SAS NOTES
Problem Note 70838: Inserting missing values into AWS Redshift using the SAS/ACCESS® Interface to JDBC might fail with “ERROR: invalid input syntax for type date: "N"”
 |  |  |  |  |
The following error might occur when using SAS/ACCESS Interface to JDBC to insert missing values:
ERROR: Execute error: com.amazon.redshift.util.RedshiftException: ERROR: invalid input syntax for type time: "N"
This error occurs when all the following are true:
- You use Unicode SAS (that is ENCODING=UTF-8).
- You use the SAS/ACCESS Interface to JDBC with Amazon Redshift - Cloud Data Warehouse.
- You use the SAS LIBNAME or data set option BULKLOAD=NO .
- Missing values are present in your source data for DATE, DATETIME, and/or TIME values.
The only workarounds are to do the following:
- Use the default SAS LIBNAME or data set option BULKLOAD=YES.
- Change your code to use the SQL Pass-Through Facility.
- Upgrade to SAS® 9.4M8 (TS1M8).
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to JDBC | 64-bit Enabled AIX | 9.4 TS1M7 | 9.4 TS1M8 |
| 64-bit Enabled Solaris | 9.4 TS1M7 | 9.4 TS1M8 | ||
| HP-UX IPF | 9.4 TS1M7 | 9.4 TS1M8 | ||
| Linux for x64 | 9.4 TS1M7 | 9.4 TS1M8 | ||
| Solaris for x64 | 9.4 TS1M7 | 9.4 TS1M8 | ||