Tuesday, December 27, 2016

Graphical mapping error: java.lang.NumberFormatException supposed to be int, but long


Mapping error, for existing javacode, treating input number as interger,

Graphicall mapping in SAP PI , ( Java code)

RuntimeException in Message-Mapping transformation: Exception:[java.lang.NumberFormatException: For input string: "9999206925"] in class com.sap.xi.tf._MM_WMiS2006_InvoiceBridge_to_WHSCON_ method removeLeadZeroes$[9999206925, com.sap.aii.mappingtool.tf3.rt.Context@280d2982]

Reason for failure of this message:

number is not suppoed by int, it supports upto 
Maximum value is 2,147,483,647(inclusive) (2^31 -1
but input number 9999206925

Tuesday, December 13, 2016

Verify delivary number status as SAP PI consultant.


Some times, we are supposed to be asked to verify delivary status in SAP PI

but we do not get idoc number,
We need to search the idoc number, 
( some times, it might not be posted to external system/SAP PI system)

go to VL03N
enter the delivery number

In general: we verify document history based on document flow( before document and after document numbers Ex: sales order , invoice number, asn if any) and reliationships(which gives inbound and outbound idoc numbers)

Check this document output options, if it is moved to target or not
Below snap shows, successfuly moved to target. (shows green flag)

Below document is not posted from SAP ECC. problem in SAP ECC system.

Successful idoc and view process log to view the idoc number.

Thursday, December 1, 2016

Removing duplicate rows in notepad++ regular expression


This Information is useful for support , tesitng phase for both ABAP and SAP PI  workaround.

This blog helps to how to remove duplicate rows in your list , which is pasted in notepad++We can also achive easily in excel, but  as a programmer, it would be easy to use in notepad++,we can do better search in notepad++

                           first paste the content in notepad++ and select all,
                               then go for line operation, sort lexically as shown in figure.

Once you sort , control f , for search, mark option, book mark(for your analysis)
Check, how the duplicate occurrence is appeared, this might be useful for further analysis

Find what:    ^(.+?)\R(\1\R)+
Replace with \1\r\n

use below replace functionality, to remove duplicates.