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:

Creation date: 4/5/2024 8:22 PM      Updated: 6/26/2024 5:02 PM
Files   
DataImage6.png
96 KB
DataImage82.png
29 KB