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

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:

Click the Hot Fix tab in this note to access the hot fix for this issue.

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

A fix for this issue for SAS/ACCESS Interface to JDBC 9.41 is available at:

UNICODE SAS fails to insert missing values into the DATE, DATETIME, and TIME columns when using the JDBC engine

Type:	Problem Note
Priority:	high

Date Modified:	2024-07-15 10:35:06
Date Created:	2024-06-11 04:20:35