Skip to main content
Question

Full loads performed successfully but Delta loads failed?

  • November 8, 2023
  • 1 reply
  • 21 views
ミ
Level 0
Forum|alt.badge.img+3

Hi expert,

 

I have a question regarding Delta loads. I've been using a data connection from AWS RedShift to Celonis. Before performing both the full loads and delta loads, I copy the target table, rename, and re-tied to perform Full loads and Delta loads. The full load consistently succeeds, but the delta load encounters issues.

 

Here's the error message for the a_size_result table:

  • Datatype of the column size_l changed from FLOAT to STRING.
  • Table won't be delta loaded. Please perform a full load instead.

When I reviewed the delta load log, I noticed that there was a change in the metadata for the 'ds_if_scm$_CELONIS_a_size_result' table.

After full loads the data, I checked the data type in RedShift (String) and the Celonis Data Pool (Varchar).

 

Could an expert please explain why this error occurs during delta loads?

 

Thanks,

1 reply

V
Celonaut

Hi,

 

Thank you for contacting us.

 

In order to be able to assist you further we would suggest you raise a case or send an email to servicedesk@celonis.de and provide the Data Model ID or the full URL of the Data Model.

 

Thank you in advance.

 

Best,

Valmira Abdiu

Community Code of ConductAccessibility statement