Error: F_JR072F Upsert Refresh Is Unsupported for Tables With Parameter TimeKey

Issue

While trying to perform upsert refresh, the following error appears:

F_JR072F Upsert refresh is unsupported for tables with action ColumnProperties with parameter TimeKey

Environment

• HVR6
• Tables using the ColumnProperties action with the TimeKey parameter
• Replication topology: Many-to-one

Resolution

To avoid this issue, use one of the following approaches:

• Use separate landing tables or channels for each source, then combine the data downstream using views or transformations.
• Use a channel without TimeKey if you require upsert refresh.
• Perform a full rebuild or load instead of an upsert refresh on only the secondary source. This typically requires reloading the entire shared target table.

Cause

The TimeKey parameter creates an append-only history in the target. This behavior is incompatible with upsert refresh, which merges changes into existing target data. This restriction applies only to refresh workflows. Normal change data capture (CDC) integrations using TimeKey are unaffected.