cancel
Showing results for 
Search instead for 
Did you mean: 

File Missing in SXMB_MONI

Former Member
0 Kudos

Hi,

I am reading a fixed width file using File sender adapter.

The data in the fixed width file is

Header1

Item1

Item2

Item3

Header2

Item1

Item2

Header3

Item1

In the recordset structure it is defined Header,,Item,

Header.fieldFixedLengths = 1,22

Header.endSeparator = 'nl'

Header.fieldNames = TYPE,CODE

Header.keyFieldName = 'H'

Header.lastFieldsOptional = YES

Header.ignoreRecordsetName = true

Item.fieldFixedLengths = 1,10

Item.endSeparator = 'nl'

Item.fieldNames = TYPE,QTY

Item.keyFieldName = 'I'

Item.lastFieldsOptional = YES

Item.ignoreRecordsetName = true

In the data type the definition of file is

<Message Type>

<Recordset>

<Header> Ocurrance 1 to unbounded

<TYPE>

<CODE>

<Item> Occurance 1 to unbounded

<Type>

<QTY>

The file is read but not shown in Message monitoring and SXMB_MONI.

but if i change the cardinality of recordset structure from Header,1,Item,1

I get the file in sxmb_moni but the structure is wrong.

Can any one tell what is wrong ?

Regards,

Monzy

Accepted Solutions (1)

Accepted Solutions (1)

stefan_grube
Active Contributor
0 Kudos

Check if you have changed <i>Recordset Sequence</i> to <i>Variable</i>

Regards

Stefan

Former Member
0 Kudos

Monzy

I dont think there is a Name value pair key called..

<field>.keyFieldName

Check this one..it should be

Key Field Name = TYPE in the content conversion params and these entries in the namevalue pairs

Header.keyFieldValue=H

Item.keyFieldValue=I

Remember to remove the quotes - ' from the Value..The records pciked have to be chked for H not 'H'

Hope this solves ur issue

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Monzy,

I don't think there is

>> Header.ignoreRecordsetName = true/false

or

>> Item.ignoreRecordsetName = true/false

There is only ignoreRecordsetName = true/false.

Hence, due to the above conf, ignoreRecordsetName is always false for you!

Just give

<b>ignoreRecordsetName = true</b>

Best regards,

Felix