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

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 KB