Skip to Content

Empty message generated in target side for Multimapping (splitting)

Oct 19, 2016 at 04:50 PM


avatar image


Hi Team,

I configured one Splitting(multimapping) scenario i.e SFTP to JDBC, here source structure is xml.

so my mapping is working fine in Message mapping level, here i used UDF for row and field splitting In message mapping we have achieved expected result.
while doing end to end testing empty message generated at target side. Attached payload for your reference

below screen shot is my mapping for row

Below are the UDF i used for splitting

public void calculate(String[] var2, ResultList result, Container container) throws StreamTransformationException{

//write your code here

int x = 0;

int clm= var2.length;

for(int j=0;j<clm;j++)




10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Praveen Gandepalli Oct 20, 2016 at 03:19 AM

Hi Sudheer,

Your source XML contains Messages and Message1 nodes, i think you placed this same XML in the source folder and you are getting empty payload in the target side. You need to remove these two nodes when you place the file in the source directory because these two nodes PI will add when performing the multi mapping, only in the message mapping test you can include these two nodes not in the original source file.

I have corrected the file and attached here, you can place the same file in the source and you will get expected result.




10 |10000 characters needed characters left characters exceeded