Skip to Content
0
Feb 09, 2015 at 10:16 AM

multiple mapping and variable substitution - error

18 Views

how to use varaible substitution with multiple mapping ?

My structure is :

<?xml version="1.0" encoding="UTF-8"?>

<ns0:Messages xmlns:ns0="http://sap.com/xi/XI/SplitAndMerge">

<ns0:Message1>

<ns1:ABC xmlns:ns1="http://abc.xyz.com">

<ABC>

<Field1>2015-01-23</Field1>

<Field2_ID>1111</Field2_ID>

<Field3>hello</Field3>

<Field4>Car</Field4>

</ABC>

<ABC>

<Field1>2015-01-23</Field1>

<Field2_ID>2222</Field2_ID>

<Field3>hello</Field3>

<Field4>Car</Field4>

</ABC>

<ABC>

<Field1>2015-01-23</Field1>

<Field2_ID>3333</Field2_ID>

<Field3>hello</Field3>

<Field4>Car</Field4>

</ABC>

</ns1:ABC>

</ns0:Message1>

</ns0:Messages>

my variable substitution i am putting in the channel is : - var1 payload:ABC,1,ABC,1,Field2_ID,1

Error :-

MP: exception caught with cause com.sap.engine.interfaces.messaging.api.exception.MessagingException: com.sap.aii.adapter.file.configuration.DynamicConfigurationException: Error during variable substitution: com.sap.aii.adapter.file.varsubst.VariableDataSourceException: The following variable was not found in the message payload: var1