Skip to Content
avatar image
Former Member

Empty message generated in target side for Multimapping (splitting)


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++)




Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • 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.




    Add comment
    10|10000 characters needed characters exceeded