The following issues occurred when using Database Connectors with a primary key allowing duplicates:

1. Rewriting or deleting a row sometimes affected more than a single row
2. Executing READ followed by READ NEXT returned the wrong record.

Full article: https://portal.microfocus.com/s/article/KM000010086