When using the Data Store Write operation, each entry is stored with a unique Entry ID. By default, if you attempt to write a new entry with an Entry ID that already exists in the data store, the integration flow will fail to prevent data duplication. To avoid this failure and handle such cases, you must select the "Overwrite Existing Message" parameter. This option instructs the system to replace the existing entry with the new one, ensuring that no duplicate Entry IDs exist and the most recent message is stored.

B. Retention Threshold for Alerting: This parameter is for monitoring. It defines a time limit after which an alert is triggered for messages that have not been processed, and it does not affect the write logic.

C. Include Message Headers: This option determines whether to store the message headers along with the payload. It affects the content of the stored entry, not the duplicate handling mechanism.

D. Encrypted stored Message: This is a security feature that encrypts the message body at rest within the data store. It has no influence on how the system handles duplicate Entry IDs during a write operation.

1. SAP Help Portal

SAP Integration Suite Documentation: In the section describing Data Store operations

the Write operation's parameters are detailed. It explicitly states for the "Overwrite Existing Message" parameter: "If you select this option

an existing entry in the data store is overwritten if a new entry with the same ID is being written. If you do not select this option

the integration flow fails if an entry with the same ID already exists."

Source: SAP Help Portal

Cloud Integration -> Creating an Integration Flow -> Define Data Store Operations

Section: "Write".

2. SAP Learning Journey

Developing with SAP Integration Suite: The official training material for the CCPI2404 certification covers data persistence. In the unit on "Using Data Store and Variables

" the behavior of the Write operation is explained

highlighting that the "Overwrite Existing Message" checkbox is the specific mechanism to prevent the process from failing on duplicate keys.

Source: SAP Learning

SAP Integration Suite Certification Path (CCPI2404) -> Unit: Using Data Store and Variables.