Embedded message: Error adding index; Caused by: The Document Cache setting allows only one entry per document in a given index.

Error:

 Embedded message: Error adding index; Caused by: The Document Cache setting allows only one entry per document in a given index. Multiple document entries were produced for index: 

Root cause :

you will get this error if you selected Enforce one index entry per document option in document cache shape and you incoming document has multiple records.

there will be confusion which record value has to take for index.

Enforce one index entry per document option we will to get all document when we retrive data from document cache .

Solution:

Add Data Process Shape to split the document send each row as separate document.

separate index will create for each row .