Sender file adapter error

[Former Member]

Hi,

The sender file adapter is reading a fixed width file . The file is not to be seen in the sxmb_moni. In the adapter monitoring is showing processed and green in color.

How do i resolve this issue.

In my recordset contains multiple substructures

<Recordset>

<Header>

type

code

id

</Header>

<Item>

type

qty

price

</Item>

</Recordset>

Header.fieldFixedLengths = 1,5,10

Header.endSeparator = 'nl'

Header.fieldNames = TYPE,CODE,ID

Header.keyFieldValue = 01

Item.fieldFixedLengths = 4,5

Item.endSeparator = 'nl'

Item.fieldNames = QTY,PRICE

Item.keyFieldValue = 02

What should i give in keyFieldValue . Is the above configuration correct.

Kindly suggest

Thanks

Varghese

[moorthy · Accepted solution]

Is your input file contains values which you have mentioned in the

Header.keyFieldValue = 01

Item.keyFieldValue = 02

Just check by giving only one record in ur file. '

If key value is changing dynamically, then you need to pick up the file with entire record into one row. In this case you will not get the all the fields with XML tags. Here you will get one Record that will contain all the fields for each record in your file.

Regards,

Moorthy

[Former Member · Accepted solution]

Thanks Bhanumurthy and Krishna for very good explanation on keyFieldValue.

My file is getting picked by the sender adapter , but i am not able to see the file in Message monitoring and in SXMB_MONI.

In adapter monitoring it is showing being picked correctly.

Any Suggestion why is the file not shown in the Integration Server.

Thanks & Regards

Monzy

[Former Member]

Hi Monzy,

you may have to define a keyfieldname. and the keyfieldvalue has to be the actual value (what comes in the input).

in Item.fieldnames , I see the "type" missing. since it is also a part of your item structure that needs to be there.

Also check this link for more information

http://help.sap.com/saphelp_nw04/helpdata/en/2c/181077dd7d6b4ea6a8029b20bf7e55/frameset.htm

Hope this fixes your problem,

Regards

Vishnu

[Former Member]

Hi,

The keyFieldvalue will change with every read from the file. It is not a static value.

And also i am not able to see the file in sxmb_moni.

Regards

Monzy

[Former Member]

Hi,

The key field value is normally a record type identifier. For example, a header record may always start with '1' or 'HD', and an item record may always start with '2' or 'IT' in your file. The 'type' field, which appears in both header and item records in your example, fits in as the identifier.

So, your parameters should be:

Header.fieldFixedLengths = 1,5,10 (or maybe 2,5,10)

Header.endSeparator = 'nl'

Header.fieldNames = TYPE,CODE,ID

Header.keyFieldValue = 1 (or maybe HD)

Item.fieldFixedLengths = 1,4,5 (or maybe 2,4,5)

Item.endSeparator = 'nl'

Item.fieldNames = TYPE,QTY,PRICE

Item.keyFieldValue = 2 (or maybe IT)

If your file has varying values of TYPE instead of 1,2 (or HD or IT), the File Adapter will not be able to handle the structured file. You may have to choose the option 'File without content conversion'.

Hope this helps,

Bhanu