I am using a table with optimistic table buffering. I am trying to append from another table. Every time I try this I get 'Uniqueness of index myindexname violated. The records that I am adding do not exist in the table I am appending to.

Can anyone help or explain?