cancel
Showing results for 
Search instead for 
Did you mean: 

SCPI ERRO : DuplicateEntryException: An entry with id x does already exist in data store XX

vinchen
Discoverer
0 Kudos

Hi Experts,

I have a local integration process, Transaction Handling is set with value "Required for JDBC", and inside this process, I will write data to datastore, and the Overwrite Existing Message checkbox is checked.

However, we noticed when we send data with same Entry ID in a short period, still we will get below error:

org.apache.camel.RuntimeCamelException: com.sap.esb.datastore.DuplicateEntryException: An entry with id x does already exist in data store XX, cause: com.sap.esb.datastore.DuplicateEntryException: An entry with id x does already exist in data store XX

Do you have any idea why this happens, and how to solve the issue?

Accepted Solutions (0)

Answers (1)

Answers (1)

vinchen
Discoverer
0 Kudos

The error is thrown at Write.

My assumption,

Two process A & B try to get Entity with ID x, and the ID does not exists, both A & B will enter the Exception handling section.

A write a record with Entity ID x,

B try to write a record with the same Entity ID x again,

For some reason behind, the Overwrite Existing Message mechanism does not work at this phase, and error reported.

Is there any way we can add a lock?