cancel
Showing results for 
Search instead for 
Did you mean: 

Empty message generated in target side for Multimapping (splitting)

0 Kudos

mappingsource.xmlruntimerecieverpayload.txt

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

{

result.addValue(var2[j]);

}

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member182412
Active Contributor
0 Kudos

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.

Regards,

Praveen.

mappingsource.xml