Yes, sometimes it works the first time but fails thereafter.

Also as the base table fills up with records, the update failures increase.

Any ideas on what the "Error 2166 - The refresh key for the basetable is not found " is pointing to. I have been trying for 7 days to figure it out .