cancel
Showing results for 
Search instead for 
Did you mean: 

Error in Sender File content Conversion - how to ignore keyfieldName

Former Member
0 Kudos

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.....

Accepted Solutions (0)

Answers (5)

Answers (5)

Former Member
0 Kudos

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.

Former Member
0 Kudos

Hi,

I have tried evrything as u said and referred all the blogs. but still the problem is not solved. The main issue is, since i gave my record substructure as - header,1,details,*, it is asking for key field. but there is no keyfield in both heade. and detail.

Any suggestions please.....

Former Member
0 Kudos

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

rodrigoalejandro_pertierr
Active Contributor
0 Kudos

Hi,

Please, take a look to these Blogs related to FCC

Rgds

RP-.

baskar_gopalakrishnan2
Active Contributor
0 Kudos

>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."

Former Member
0 Kudos

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.