Theobald Software Community Day 2024: Jetzt Early Bird Ticket SICHERN und mit dem Code EARLY20 20% sparen

Insert Statement failed for empty values using Snowflake Destination


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


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.


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