Copy Command for Snowflake Destination failing

Error:

Theobald.Extractors.Table.TheoReadTableException: An error occured in PROCESS_PACKAGE callback. --->
System.AggregateException: One or more errors occurred. ---> System.NullReferenceException: Object reference not set to an instance of an object.

Reason:

For any reason, an empty value exists in a primary key field in SAP. The default destination setting 'Replace empty values with SQL NULL' violates the DB constraint for a non-nullable column, see sample SQL error message from the Snowflake Query History section:

Solution:

Disable the mentioned destination setting as described in our Online Help, see the following link:

https://help.theobald-software.com/en/xtract-universal/destinations/snowflake#empty-values

hxu1 non-nullable column replace empty values with sql null

Creation date: 4/5/2024 8:22 PM Updated: 6/26/2024 5:02 PM

DataImage6.png

DataImage82.png

Files		Sort by Name Sort by Date
	DataImage6.png 96 KB
	DataImage82.png 29 KB