Skip to Content

Creating Excel log file

Hi All,

I have a requirement, whatever the messages passes from PI that I have to create a log file in FTP server.

Ex:


Message1

<tag1>value1</tag1>

......

......

<tagn>value2</tagn>

Message2

<msg1>abc</msg1>

.....

......

<msgn>xyz</msgn>

Like this I have 30,000 messages for different interfaces with different structure, I have to create a log Excel file in FTP by EOD.

Thanks,

Nag

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Posted on Oct 12, 2015 at 02:01 PM

    Hi Nag,

    I am not sure that feature is available in PI. though i would suggest you to create an RFC lookup for all interfaces which you need to track..and map to target root node in mapping level.

    and take help from ecc people to post that in ecc using that lookup and EOD you can get log report and would be shared to FTP server..

    not sure this is recommended 😊

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 12, 2015 at 02:24 PM

    Hello Nagesh,

    You can poll the status table of SAP PI using JDBC and get the number of messages processed.Then write this as file.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 12, 2015 at 02:35 PM

    Nageswara,

    SAP PI, do log details of messages and Payload, for all processed messages. In most of the cases, it is sufficient.

    If you want to log to external system, please check

    Writing Log Entries of a Java Application to an External Centralized Log Management System

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.