Question Re: CPI - DATA Store - WRITE and GET Operation in Technology Q&A

CPI - DATA Store - WRITE and GET Operation

BiswaPal — Wed, 12 Dec 2018 14:50:14 GMT

Hi All,

We have a scenario in CPI in which we need to store data in Data store (in case of connectivity issue) and fetch data for resending it.

We are using Write operation to store data with DATAStore mentioned, we can mention some entry ID to store data.

While retrieving the data using GET Operation in second Independent process of Iflow how to check Router condition using Entry ID?

How to check for empty file router condition?

Write operation to Store DATA (Entry ID we have kept it empty)

GET operation to retrieve file (Non-XML) from DATA Store.

Best Regards,
Suresh S

Re: CPI - DATA Store - WRITE and GET Operation

Former Member — Wed, 12 Dec 2018 17:58:25 GMT

HI Suresh,

I guess your aim is to prevent failing of the Iflow if there is no data store entry?

Why you are not checking in the router for an empty body of the message?

If no data store entry is fetched via GET the body should be empty.

Thanks and regards

Maik

Re: CPI - DATA Store - WRITE and GET Operation

BiswaPal — Thu, 13 Dec 2018 09:45:56 GMT

Hi Maik,

Thanks for your inputs.

There are 2 cases here,

1. Maintaing Entry ID in Write DATA store operation and how to fetch same Entry ID in separate Process of same Integration flow as mentioned in pic above?

2. As you mentioned, we need to end iFlow in case Entry ID is empty or Empty message .

I have added routing condition ${header.SAPDataStoreID} = ' ' and eventhough we dont have message in data store, condition is not checked.

How to maintain routing condition entry in SAP HCI?

Best Regards,
Suresh S

Re: CPI - DATA Store - WRITE and GET Operation

Former Member — Thu, 13 Dec 2018 12:25:41 GMT

What about condition like ${in.body} = '' instead?

Re: CPI - DATA Store - WRITE and GET Operation

BiswaPal — Tue, 19 Feb 2019 13:59:03 GMT

Hi maik.offerle ,

Tried with above option also, We are getting null exception.

No message available in Data store and in turn throws Null Exception.

Could you kindly say how to check for null condition (DATA store message) at Router Condition?

Best Regards,
Suresh S

Re: CPI - DATA Store - WRITE and GET Operation

Sriprasadsbhat — Tue, 19 Feb 2019 14:21:35 GMT

Hello Suresh,

Add a select step and add below condition which might help you to check whether message details are retrieved or not.

https://answers.sap.com/questions/756399/how-to-read-the-number-of-available-data-store-rec.html?childToView=755501#answer-755501

Regards,

Sriprasad Shivaram Bhat

Re: CPI - DATA Store - WRITE and GET Operation

BiswaPal — Wed, 20 Feb 2019 08:30:40 GMT

Hi Sriprasad,

Thank you for the inputs.

Currently i am unable to create new DATA Store for storing data.

Can you throw some light on the same.

Best Regards,
Suresh S