Due to an internal event from 27 to 29 January, there may be delays in the processing of requests. Thank you for your understanding.

Theobald Software Support

General

Xtract IS

Troubleshooting

Xtract Universal

Troubleshooting

ERPConnect

Print...

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://helpcenter.theobald-software.com/xtract-universal/documentation/destinations/snowflake/#empty-values

hxu1 non-nullable column replace empty values with sql null

Creation date: 4/5/2024 8:22 PM Updated: 1/22/2025 9:51 AM

DataImage6.png

DataImage82.png

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