Variable substitution problem

[Former Member]

Hy,

I get following problem with Varibale Substitution in Receiver File Adapter.

<b>"2006-04-19 14:10:39 CEST: Error: Message processing failed: Exception: Exception in XML Parser (format problem?):'java.lang.Exception: Message processing failed in XML parser: 'java.lang.Exception: Consistency error: more fields found in XML structure than specified in conversion parameters! (Value '001')', probably configuration error in file adapter (XML parser error)'"</b>

My file has following structure(message typ)

level1

recordset

fieldsa String 1

fieldsb String 1

level2 Element 1

fields1 String 1

fields2 String 1

and Adapter configuration is

Folder : data\%w%\

filename : file%r%.txt

w payload:level1,1,level2,1,fields1,1

r payload:level1,1,level2,1,fields2,1

Could anyone see my problem

cheers

[Shabarish_Nair · Accepted solution]

Hi,

Can you disable the variable substitution and try i guess the probs is in the content conv.

ShabZ

[moorthy]

HI,

Just check with the Message Type so that your variable substitution is right. Variable Substitution should start with Root Node and subsequent Nodes.

Also make sure that, if you have any _(underscore characters ) in the Data Type, then just remove it and try.(Below SP12 )

Also have a look into

http://help.sap.com/saphelp_nw2004s/helpdata/en/bc/bb79d6061007419a081e58cbeaaf28/frameset.htm

Hope this helps,

Regards,

Moorthy

[bhavesh_kantilal]

hi Mattia,

Can you please give us the file datatype in more detail with the nested strucuture. the input you have given is not very clear. <i>Recordset..??</i>

level1

recordset

fieldsa String 1

fieldsb String 1

level2 Element 1

fields1 String 1

fields2 String 1

Also,you will also have to specify the root name(Datatype name) in the variable name substitution and give its occurrence which I think you have not done.

Regards,

Bhavesh

[Former Member]

Hy all,

this the file structure:

level_1

-level_x

-fields_a String 1

-fields_b String 1

-level_2 Element 1

-fields_1 String 1

-fields_2 String 1

and Adapter configuration is

Folder : data\%w%\

filename : file%r%.txt

w payload:level_1,1,level_2,1,fields_1,1

r payload:level_1,1,level_2,1,fields_2,1

I hope ist the file structure now clear.

Cheers

MAt

[moorthy]

Hi,

Is this is your structure

level_1

-level_x

-fields_a String 1

-fields_b String 1

-level_2 Element 1

-fields_1 String 1

-fields_2 String 1

If so the variable substitution looks ok.

w payload:level_1,1,level_2,1,fields_1,1

r payload:level_1,1,level_2,1,fields_2,1

First Option-

1) Remove the _ (Underscores) and check it -Refer SAP Note 850694

2) Remove the Directory Susbtsitution - by giving static path for the File Directory

3) If it works in 2nd step, there is a error in the Variable Sustitution for the Directory .( check SAP help mentioned in my earlier reply)

Hope this helps,

Regards,

Moorthy

[Former Member]

Mattia,

When you are not sure of the structure my suggestion would be first to have the naming conventions properly.

---Mohan