on 11-03-2011 2:50 PM
Dear Frndz,
I'm new to SAP PI. I want to post a flat file to ECC.
The Souce Structure is:
Record(1-unbounded)
|_Header(1.1)
field1
field2
field3
|_Detail(1.unbounded0
field4
field5
field6
Sample File:
first header - xx,yy,zz
Detail 1 - 1,b,c
Detail 2 - 2,e,f
second header - aa,bb,cc
Detail 1 - 1,g,d
I wrote the file content conversion as follows
Recordset name - Record
Recordset Structure - Header,1,Detail,*
Header.fieldNames field1,field2,field3
Header.feldseparator ,
Header.endseparator 'nl'
Detail.fieldNames field4,field5,field6
Detail.fieldseparator ,
Detail.endseparator 'nl'
Conversion initialization failed: java.lang.Exception: java.lang.Exception: java.lang.Exception: Error(s) in XML conversion parameters found: Mandatory parameter 'xml.keyfieldName': no value found
It's asking me to give the input to keyfieldname. But I dont have such field in my record. Ther's no common field . no field is repeating like record type or doc_type as in other cases.
So, Coud you please guide me to proceed with this.
Thanks in advance.....
Hi,
i wrote the file content conversion as follows
Recordset name - Record
Recordset Structure - Header,1,Detail,*
Header.fieldNames field1,field2,field3
Header.feldseparator ,
Header.endseparator 'nl'
Detail.fieldNames field4,field5,field6
Detail.fieldseparator ,
Detail.endseparator 'nl'
can you check what are fcc parameters you have passed, there is some typo mistake can you check it once.
Header.feldseparator -
Header.fieldSeparator
Header.endseparator -
Header.endSeparator
refere this thread i hope this will help you
regards,
ganesh.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
>>>>>Conversion initialization failed: java.lang.Exception: java.lang.Exception: java.lang.Exception: Error(s) in XML conversion parameters found: Mandatory parameter 'xml.keyfieldName': no value found
In case you have multiple records and they have various occurances, then make sure you have a key field for each record specified in your content conversion
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
>Recordset Structure - Header,1,Detail,*
You specified recordset substructure *, so it requires keyfieldName.
SAP document says...
"If you specified a variable number of substructures under Recordset Structure (at
least one structure with the value *), the substructures must be identified by the
parser from their content. This means that a key field must be set with different
constants for the different substructures. You must specify a key field and the
field name must appear in all substructures."
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi.
If you put Key Fiel Name you must specify "keyFieldValue" .
For more information check please
http://help.sap.com/saphelp_nw04/helpdata/en/bc/bb79d6061007419a081e58cbeaaf28/frameset.htm.
In your case you don't have any keyValue so please check this thread must be help you.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
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.