Insert Statement failed for empty values using Snowflake Destination

Error:


Insert statement failed ---> System.Data.Odbc.OdbcException: 
ERROR [22000] NULL result in a non-nullable column

Reason:


Empty values in SAP tables are converted as NULL values by default in Snowflake. 
This leads to errors with primary key fields with non-nullable constraints when inserting the records.

Solution:


Update Xtract Universal to the latest version and disable the default settings for Snowflake property EMPTY_FIELD_AS_NULL.



Additional information to this function can be found in the Online Help, see the following link:

Creation date: 8/19/2022 5:10 PM      Updated: 6/26/2024 5:03 PM
DataImage86.png

DataImage86.png
Files
DataImage86.png
28 KB
get help Get help for this page