Error: Primary Key updatedAt Is null in Object

Issue

The connection fails to sync the USER_HISTORY table. The following error appears:

Failed to sync 1 endpoint(s) with error: {USER_HISTORY=com.fivetran.core.interfaces.data.PrimaryKeyContainsNullException: Null primary key found while syncing table. Primary Key updatedAt is null in object.}

Environment

Connector: Iterable

Resolution

To resolve this issue, do the following:

1. In Iterable, enable the profileUpdatedAt user profile field. For more information, see Iterable's Managing User Profiles documentation.

2. In Fivetran, save and test your connection.

   i. Go to your Iterable connection page.

   ii. Select the Setup tab.

   iii. Click Edit connection.

   iv. Click Save & Test.

Cause

This issue occurs when Fivetran can't populate the mandatory primary key column updated_at in the USER_HISTORY table because the corresponding profileUpdatedAt field is hidden in Iterable.