Error while using the variable name "VARIABLE" in variable substitution

[Former Member]

Hi Experts,

I am using variable substitution to have my output filename set as a payload field value. It is working fine when I am using the variable name as fname, subs etc but channel goes in error when I am using the variable name as "VARIABLE". This is probably a reserved word but i would like to know where i can find a detailed documentation on this. Say things to note / restrictions while using variable substitution.

This is the error in the channel:

Message processing failed. Cause: com.sap.aii.af.ra.ms.api.RecoverableException: Error during variable substitution: java.text.ParseException: Variable 'variable' not found in variable substitution table: com.sap.aii.adapter.file.configuration.DynamicConfigurationException: Error during variable substitution: java.text.ParseException: Variable 'variable' not found in variable substitution table

Thanks,

Diya

[Former Member · Accepted solution]

Hi Zevik,

Thanks for the reply. The output file is created correctly by merely changing the variable name to something else and hence the doubt.

Below is the configuration:

Variable Substituition

VARIABLE payload:interface_dummy,1,Recordset,1,Header,1,field1,1

*********************************************************

Filename schema : TEST_%VARIABLE%.txt

*****************************************************

Output xml structure:

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

- <ns:interface_dummy xmlns:ns="http://training.eu.unilever.com">

- <ns:Recordset xmlns:ns="http://training.eu.unilever.com">

- <Header>

<identifier>HDR</identifier>

<field1>001</field1>

<field2>001</field2>

<field3>R</field3>

</Header>

- <Detail>

<identifier>A</identifier>

<field1>000000002</field1>

<field2 />

<field3>Doretha.Walker</field3>

</Detail>

I thimk my configuration is correct as it is working correctly with the variable name change, However, maybe i missed something !

[Former Member · Accepted solution]

Hi Thomas,

It looks perfectly fine, if you change the variable and it works than the only thing that makes sense is that it is reserved.

however i have found no documentation on it.

[former_member854360 · Accepted solution]

Hi,

VariableName should always be in small case.

You cant specify variable name in CAPITAL letters for variable substitution. It should be in small lettter.

If you specify the variable name with any capital letter it will not work.

Please find the below thread for details.

Thanks,

[Former Member · Accepted solution]

Hi Debashish,

You were right. CAPS are not allowed for variable names. I changed case and it worked. Thanks a lot !

Diya

[Former Member]

Hi Thomas,

I use variable substitution a lot, this error happens a lot, this is usually because of error in configuration.

variable substitution is case sensitive, check also the payload path.

as far as i know there is no reserved names in variable substitution.

could you provide the configuration youve done ?

Edited by: Zevik Heinoch on Jun 28, 2011 10:31 AM