Error: Variable not found in variable substitution table

[Former Member]

Hi,

I am getting following error in file adapter receiver communication channel.

error:Could not process due to error: com.sap.aii.adapter.file.configuration.DynamicConfigurationException: Error during variable substitution: java.text.ParseException: Variable 'file' not found in variable substitution table

<b>variable substitution values:</b>

Variable name: File

reference :payload:MT_DC_Recr,1,Target,1,Filename,1

file name scheme : %File%.txt

<b>inpu file:</b>

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

<ns0:MT_DC_Send xmlns:ns0="http://urn:psr/ff/DC">

<Source>

<Filename>dat1</Filename>

<Record>

<Name1>123</Name1>

<Name2>abc</Name2>

<Name3>XYZ</Name3>

</Record>

</Source>

</ns0:MT_DC_Send>

Regards,

Srini

[former_member192892 · Accepted solution]

>>>>>>>>>>>>>reference :payload:MT_DC_Recr,1,Target,1,Filename,1

Try payload:root,1,Target,1,Filename,1

[Former Member · Accepted solution]

Hi Varun,

there is no 'root' in the structure.the o/p MT str is

<MT_DC_Recr>

< Target>

<Filename>. How can I give root in the reference>

Regards,

[former_member192892 · Accepted solution]

its d standard format in which XI accepts d message...Just try givin it, and tell me d output

[Former Member · Accepted solution]

Hi varun,

This is the error i am getting now..

Could not process due to error: 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: File

what i am trying to get is reading filename from the message payload.

Reg,

Srini

[former_member192892 · Accepted solution]

Could you provide d output message type structure here??

[Former Member · Accepted solution]

Hi,

Pls find..

<ns0:MT_DC_Recr xmlns:ns0="http://urn:psr/ff/DC">

<Target>

<Filename>dat1</Filename>

<Record>

<Name1>123</Name1>

<Name2>abc</Name2>

<Name3>XYZ</Name3>

</Record>

</Target>

</ns0:MT_DC_Recr>

regds,

[Former Member]

Hi Varun,

Problem is solved.the error is in "variable name" where i had given it as 'File'.we should not give capital letters in the variable name.

Thanks for your help.

Regards,

Srinivas

[former_member192892]

Srini,

Plz try this...

payload:MT_DC_Recr,1,recordset,1,Target,1,Filename,1