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:
| Files | ||
|---|---|---|
|
DataImage86.png 28 KB |
Get help for this page
Jitbit HelpDesk