Using test message option in SAP PI for production message

Om

During my support activates in SAP PI, I need to identify the failed messages in message monitoring.

If any failed messages that are due to no value mapping entry and there would be one fix required to avoid this error at SAP ECC side.

until we fix this change in ABAP , we could not wait for rest of entries/row (xml file) where data is not related to this error. we are supposed to move the data from sap pi to target system by skipping error entries in xml file ( by manual correction).

After getting firefighter id/support id, (manager approval and basis involvement to get this), we can use test option in sap pi to reprocess correct xml file to target system (production).

Other challenges 

1. Support option supports up to 11887 entries only, if the payload has more than this number entries/rows, we could send entire xml files to target. it throws mapping error again in monitoring page of sap pi.

What I did  ;-)

I simply split the corrected xml file into two files, each file has less than 11887 rows.

(by adding required tag start and end of xml file, like namespace and end tag)

Fixing value mapping errors in sap pi mapping

Om

My value mapping error as follows.

opened the value mapping list, if that specific value is maintained in value mapping or not, and also find the solution to avoid mapping in this case also( as per my technical team advice)

By changing value mapping properties, usedefault value, we send some default value, if the value is not maintained in value mapping list.

Debugging SAP PI mapping based on manager query

Om

In one of my project, My manager asked me to verify specific parameter has been passed to target system or not, in delivery idoc from sap system.

As technical consultant, we could not find the corresponding filed in idoc.

but 

In this way, I have searched the right parameter in my idoc,

open the xsd structure of that idoc,

Search for the "reason code" and finding right segment in idoc.

As follows.

My manager query as follows

I have interface sheet, which was download from SAP PI message monitoring.

(save this as my reference)

I used this excel sheet to search based on my requirement.

identifying right idoc and mapping information.

 Searching sender idoc segment based on field description. for this i have opened idoc xsd searched the key word "Order Reason" as follows

Order reason corresponding filed name is AUGRU,

Now search this filed in mapping, where it is mapped to target.

copy the target field name and give it to my manager.

I hope , this would help you to solve your similar problems.

Finding Message id based on delivery number in sap pi Dual stack system

om

Real time scenario

Delivery number given by other non sap team.

Need to check whether the message is processed in xi/pi side or not.

Steps to check

Step1:

Step2:

Step3:

Step4:

Step5:

By seeing port it is a dual stack system.

Step6:

 checking is not possible with IDOC number

Step7:

 So Take message id in details Tab

Step8:

 Pstee message id in Dual stack system in SXMB_MONI

Step9:

 Click on execute

Step10:

 By seeing Message Flag Message Processed Successfully.

Step11:

Step12:

Finally verified message processed Successfully

Xls to Xml conversion and real time use

om

Steps to create .XML from .xls XML data file

Step 1:

Sample xls file with XML tabular data

Step 2:

Click on Office button on top right corner

then save as other formats

Step 3:

Save the file in desired location

Step 4:

click on continue button

Step 5:

converted xml file

Step 6:

Open the xml file with notepad ++

Our desired XML format is obtained.

Scenarios faced in real-time:

• Client sent  xls file in mail attachment.It contains xml data
• To test inbound proxy scenario in sap pi
• I need XML file to test in the sap
• I tried many online tools won't work
• Finally I converted the xls file to XML based on above steps and I Successfully converted xls file to xml and tested in proxy scenario.

Xml to Xls xml tabular format conversion

om

Steps to convert Xml data to .xls format

Step1:

Sample Xml file

Step2:

Open the excel blank document,

Step3:

Drag the sample xml file into excel book

Step4:

Select the radio button As an Xml Table

Step5:

click on ok button

Step6:

 xml is converted to tabular format.

Save the document.

SAP PI steps to launch esr in sapi 7.5 and steps to resolve errors

om

Prerequisite

------  > > > JAVA 1.8 supports for SAP PI 7.5

Step1:Click on esr

 

Step2:open the JNLP files

 

Step3: wait for verifying applications

 

Step5: Click on run

 

Step6:Click on Don't Block

 

Step7: Application Error

 

Step8: Details of error

Solution Steps to resolve Error

 

Again try to open from index page with out error you can open

Other supporting links:
https://www.google.com/url?q=https%3A%2F%2Fwiki.scn.sap.com%2Fwiki%2Fdisplay%2FXI%2FTroubleshooting%2BPI%2BESR%2Band%2BIntegration%2BBuilder%2BLogon%2BIssues&sa=D&sntz=1&usg=AFQjCNEJXJ6xinhGfr0UWp_E2zsofTcQKA