cancel
Showing results for 
Search instead for 
Did you mean: 

Creating Excel log file

nageswararao_v2
Participant
0 Kudos

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

Accepted Solutions (0)

Answers (3)

Answers (3)

RaghuVamseedhar
Active Contributor
0 Kudos

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

former_member186851
Active Contributor
0 Kudos

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.

maheswarareddykonda
Active Contributor
0 Kudos

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