Problem with Receiver FCC

[Former Member]

Hi,

Our receiver file has the following structure:

<Record>

<header>

<head1>

<head2>

<Item>

<item1>

<item2>

</Item>

<header>

</Record>

I have defined my Receiver file adapter as:

ReceordsetStructure: Header,Item

header.fieldFixedLengths

Item.fieldFixedLengths

item.fieldSeparator

item.endSeparator

header.fieldSeparator

header.endSeparator

But when I test this it is throwing an error in Receiver CC saying that

Error occurred while connecting to the FTP server :java.lang.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 '8')', probably configuration error in file adapter (XML parser error)'

The value '8' here is the first element in the Item node.

Idon't know why it is taking only the header lelements and throwing error for Item node.

can somebody throw a light on this.

Thanks in advance

With Regards

Deepika.

[Former Member]

Hi,

Since you have not given the parameters header.fieldnames and item.fieldnames , its identifying the fields based on the fixedlength parameter. The error is either because the length of one of the fields is more than what you have specified ...

Also, check your end separator value...

Give the parameters header.fieldnames and item.fieldnames .

regards,

Ramya Shenoy

[Former Member]

Hi ,

you should provide fields in Fcc of Datatype fields

The fields are must be same as Datatype and FCC

[former_member5086]

Hi,

I think you are not specified correctly content conversion.

If you can use some character as field separator, you don't need fixedFieldValues parameter.

If you don't have any separator, you can't use fieldSeparator parameter.

Regards,

Carme.

[Former Member]

Hi Carme,

Thanks for the reply.

As you said with this it will work fine but my target file should be a fixed length file, means I should get empty spces if the data in the field is not matching with length of the field.

My o/p data is as below:

@12@23@56@89@45@12@65@98@458@87@12

But I need it in this format:

@ 12@23@ 56@ 89@ 45@12@ 65@ 98@ 458@87@ 12

The empty spaces are getting trimmed if fixed lengths are not used.

Also I need header and item in seperate lines.

With Regards

Deepika.

[Former Member]

I should get empty spces if the data in the field is not matching with length of the field.

You need to adjust fields to their maximum length in maping....

you can use leading zeros/ spaces... that suits the requirement

[Former Member]

Hi,

To preserve the spaces You need to indicate to your data type(xsd structure) that. Inside your datatype editor, go to "Details" column and in "whitespace" field select "preserve".

Regards

Ivan

[Former Member]

Hi Mugdha,

Thanks for the reply.

In that way it will work fine.

Also how can we make the header data and Item data to appear in sperate lines i.e

head1,head2

Item1,Item2

Item1,Item2

.

.

.

.

Thanks & Regards

Deepika.

[Former Member]

Header and Items will get separated by newline, newline is default separator in receiver content conversion

Also check maximum possible hierarchy for receiver structure

http://help.sap.com/saphelp_nw70/helpdata/en/d2/bab440c97f3716e10000000a155106/content.htm