Due to public holidays in Germany until April the 1st, there will be delays in the processing of tickets. Thank you for your understanding.

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: 8/19/2022 5:12 PM
Files
DataImage86.png
28.4 KB