on 10-19-2016 5:50 PM
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]);
}
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
78 | |
10 | |
9 | |
7 | |
6 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.