Question Re: Export message processing log from CPI in Technology Q&A

Export message processing log from CPI

VishnAndr — Tue, 26 Mar 2019 04:01:47 GMT

Dear Community,

Is there any way to export CPI message processing log for failed messages in mass with error details? Not going one by one and check in UI.

What I tried so far is using SAP CPI odata API and I used it to export required entries to MS Excel taking the source as oData Feed. Something like .../api/v1/MessageProcessingLogs?$filter=Status eq 'FAILED' and LogStart gt datetime'2019-03-11T16:00:00'

This gives me a header information of message processing logs. But when I'm trying to expand record column ErrorInformation seems like MS Excel going crazy and reading hundreds of megabytes of data and becomes irresponsive. Actually, it won't probably help at all. Because I'm more after to get .../MessageProcessingLogs(<messageid>)/ErrorInformation/$value which is a stream and contains a real error message from the log.

Have anyone experienced the same and how did you tackle it?

Re: Export message processing log from CPI

Former Member — Tue, 26 Mar 2019 06:41:17 GMT

We should be able to build an iflow with combination to extract these messages ids in the main flow then pass: MessageGuid alone by splitting this response to a subprocess to extract error information of the same. Finally, gather the second response only the fetching error tag and create a single CSV file at the end with less fields.

Re: Export message processing log from CPI

VishnAndr — Tue, 26 Mar 2019 22:27:58 GMT

Good approach, thank you! But I would prefer something more user friendly...

Re: Export message processing log from CPI

VishnAndr — Thu, 28 Mar 2019 03:11:07 GMT

Solved using proper Power Query in MS Excel. Just needed to gain more knowledge in M-language 🙂

Re: Export message processing log from CPI

former_member205889 — Thu, 07 Nov 2019 09:06:04 GMT

Hi,

Can you please share the steps on how to fetch the logs through OData call?

Thanks,

Poorna

Re: Export message processing log from CPI

JaySchwendemann — Wed, 09 Jun 2021 08:38:59 GMT

Would be swell if you'd share your wisdom 😉

Re: Export message processing log from CPI

nj_007 — Fri, 09 Jul 2021 13:40:08 GMT

Hi Andrie,

Could you please share the process of fetching SAP logs for a time frame.

Regards,

Nehul