on 07-17-2008 6:42 AM
Hi
I am getting following error message for variable substitution
*Message processing failed. Cause: com.sap.aii.af.ra.ms.api.RecoverableException: Error during variable substitution: com.sap.aii.adapter.file.varsubst.VariableDataSourceException: The following variable was not found in the message payload: date_stamp: 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: date_stamp
<?xml version="1.0" encoding="UTF-8" ?>
- <I813_EModMCS_IB_MT>
- <Records>
<ModMod>111</ModMod>
<DesModdcr>222</DesModdcr>
- <Date_Stamp>
<Date_Stamp>20080338</Date_Stamp>
</Date_Stamp>
</Records>
</I813_EModMCS_IB_MT>
date_stamp payload:I813_EModMCS_IB_MT,1,Records,2,Date_Stamp,3,Date_Stamp,1
Would appriciate if you can correct the variable substitution...
Regards
To reference the element that is in bold in the example, the following expression is used: payload:root,1,e1,1,e2,2
The parser searches for the first occurrence of the root element at the first level. It then searches for the first occurrence of e1 at the second level and for the second occurrence of e2 at the third level. The content of the last element (u201CExample Valueu201D) is set as the value for a specified variable.
<?xml version="1.0" encoding="UTF-8" ?>
<root>
<dummy>
<e1>
<e2>Data_1</e2>
<f/>
<g attr="abc">text</g>
<e2>Data_2</e2>
</e1>
</dummy>
<e1>
<e2>illegal/value</e2>
<f/>
<g attr="abc">text</g>
<e2 attr="fghij">Example Value</e2>
</e1>
</root>
Edited by: Progirl Progirl on Jul 17, 2008 8:04 AM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
What I had observed earlier is that the Variable Name used in the adapter should not contain upper case letters. I faced similar errors when variable name had upper case letters.
Try having all variable names in lower case. i.e. using date_stamp as variable name should resolve the issue.
Hope this helps.
Regards,
Riyaz
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Chech the field name in variable substituion.
<Date_Stamp> and you use date_stamp. I beleive it is very much case sensitive.
Thanks
Farooq.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Use Date_Stamp with 'D' and 'S' capital
dont write date_stamp before payload ..remove that in variable subs
Edited by: Progirl Progirl on Jul 17, 2008 7:46 AM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
93 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
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.