Skip to Content

WRITE Data Store SAP entry ID is taking local variable type as its ID instead of unique message ID

Hi Experts,

I am storing the exceptions in data stores using WRITE component. I am not giving any entry ID. but during runtime SapDataStoreId is taking the local variable type from header. which is why other exceptions are not being stored due to this.

Error: com.sap.esb.datastore.DuplicateEntryException: An entry with id XXXXX does already exist in data store INT399A_20200625070225894_Exception

Thanks in Advance.

BR,

Sunitha

picdatastore.png (19.9 kB)
Add comment
10|10000 characters needed characters exceeded

  • Hi Sunitha

    Kindly share some detail screenshots of your Integration Flow modelling.

    Regards,
    Sunny

  • Additional Info:

    I have created a few message headers which includes LastRunDate as local variable type. During runtime the 'SapDataStoreId' is taking that local variable as its entry ID.

    Tried deleting this SapDataStoreId after this content modifier but then also the unique message ID is not getting created for each exception. Please find below error for the same.

    org.apache.camel.RuntimeCamelException: com.sap.esb.datastore.DuplicateEntryException: An entry with id 1f83adfa-c0d6-44e9-bf0a-68e75be8609d does already exist in data store INT399A_20200625134816145_Exception, cause: com.sap.esb.datastore.DuplicateEntryException: An entry with id 1f83adfa-c0d6-44e9-bf0a-68e75be8609d does already exist in data store INT399A_20200625134816145_Exception


    Kindly suggest.

    Thanks.

    piclsrd.png (44.8 kB)

3 Answers

  • Posted on Jun 25 at 09:30 AM

    Hello Sunita,

    First thing is goto monitoring and see whether the Datastore entry you are creating is already exist or not.

    If already exist then the error you are getting is obvious and you get rid of it by checking below option in you write step.Also make sure you are getting values into header you are passing in Entry Field in Write step

    Regards,

    Sriprasad Shivaram Bhat


    Add comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 26 at 07:10 AM

    Hi ,

    try creating the Number range in the Monitoring page, and use that in the content modifier to create header and use that in the Entry id. this might solve your problem.

    Thanks and Regards,

    Vijay.

    Add comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 26 at 10:15 AM

    Hi,

    I used ${header.KeyField} in the entry ID of WRITE step, wherever I used the data store. Now I'm able to create dynamic entries in dataStore.

    Thanks,

    Sunitha

    Add comment
    10|10000 characters needed characters exceeded