Verify that the primary key constraints are defined for the source tables that you added to the partition exchange interim tables. By default, pre-packaged accelerators include key constraints. If you modified or added metadata within the pre-packaged accelerators or if you have custom applications, verify that the primary key constraints exist.
The archive job uses a combination of the row ID and the primary key to delete from the source. If the primary key constraint is not defined, then you receive an error in the job log. The job cannot populate the keep table without the primary key.