Theobald Software Community Day 2024: Jetzt Early Bird Ticket SICHERN und mit dem Code EARLY20 20% sparen

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

non-nullable column replace empty values with sql null

Creation date: 4/5/2024 8:22 PM Updated: 4/8/2024 9:05 AM

DataImage6.png

DataImage82.png

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