Variable substitution error

[Former Member]

Hello All,

Below is my source structure:

<Messages>

<Message1>

<MT_BILL> (0...*)

<RECORD> (1....*)

<FILENAME> (1...1)

If using variable substitution for the filed FILE NAME which is in the source structure.

This is the declaration I used in channel:

payload:MT_BILL,0,RECORD,1,FILENAME,1

But i am getting this error in channel monitoring

DynamicConfigurationException: Error during variable substitution: com.sap.aii.adapter.file.varsubst.VariableDataSourceException: The following variable was not found in the message payload: var

Can anyone help me here

Regards,

Moorthy

[Former Member · Accepted solution]

Hi Dasika,

In variable substitution we use the receiver message type path.

Please map the required source field to any of the field at the reeiver side and use variable substitution.

For 1:N muti-mapping with variable substition go through the below links:

Regards,

Pranav

[KennethEriksen]

Hi,

I don't think you can use index 0 of the MT_BILL. Instead try the following:

var = payload:MT_BILL,1,RECORD,1,FILENAME,1

This will pick the value from the first FILENAME-field, of the first RECORD of the first MT_BILL for each message of your multimessage.

Br,

Kenneth

[Former Member]

No luck Kenneth..Stil I am getting same error

[KennethEriksen]

I don't know if this works, but have you tried adding the Messages and Message1 segments too?

as in: payload:Messages,1,Message1,1,MT_BILL,1,...

Give it a shot.

-Kenneth

[Former Member]

Hi,

Have a look at this thread.

[Former Member]

Hello Anand,

I am working on PI 7.1 SP06. So I dont think there is a problem with SP in my case.

Regards,

Moorthy