ERROR consistency check in recordset structure validation

[bekirakturk]

Hi Experts,

I have SFTP to file scenario, txt  file to xml file. following is my source XML structure.

:20:field20

:25:field25

:28C:field28c

:60F:field60f

:61:field61

:86:field86

:61:field61

:86:field86

:61:field61

:86:field86

:62F:field62f

I will use the lines  :25:, :60f: and :62f:  in mapping for target file rest of them will be ignored. I Create a structure as below in MT

<MT>

    <25>

         key

         field1

    <60f>

         key

         field1

    <62f>

         key

         field1

It is giving error in RWB like "Cannot send message to module processor: com.sap.aii.af.lib.mp.module.ModuleException: Transform: failed to execute the transformation: com.sap.aii.af.sdk.xi.adapter.trans.TransformException: Error converting Message: 'java.lang.Exception: ERROR consistency check in recordset structure validation (line no. 11: missing structure(s) in last recordset'; nested exception caused by: java.lang.Exception: ERROR consistency check in recordset structure validation (line no. 11: missing structure(s) in last recordset"

I went through http://help.sap.com/saphelp_nw04/helpdata/en/24/4cad3baabd4737bab64d0201bc0c6c/content.htm 

,What should be structure for this scenario?

Thank you for your helps.

Bekir

[Bhargavakrishna]

Hi Bekir,

The issue is with the structure or mapping. please re-check it.

The errors says expecting the specified number for record-set and  since it is missing gives error.

if you are not sure about number of records,i suggest change the last carnality to *.

for  Header Please specify wild-char character. Dont give max numbers. 

Refer this link

http://scn.sap.com/thread/1959491  [ This will help you]

http://help.sap.com/saphelp_nw04/helpdata/en/24/4cad3baabd4737bab64d0201bc0c6c/content.htm

http://scn.sap.com/message/13883828

http://scn.sap.com/message/13881422

http://help.sap.com/saphelp_nw73/helpdata/en/44/6713ec3f914ddee10000000a1553f7/content.htm?frameset=...

Hope it will helpful..

Regards

Bhargava krishna

[ambrish_mishra]

Hi Bekir,

Seems like it is an EBS file you are trying to read.

I suggest to try and read all the type of records. Would be a one time activity and map only those structure/fields which are requried.

Are you trying to read the file as fixed length ? Logically you should do it that way.

HeaderLineItem_20.fieldFixedLengths	4,100
HeaderLineItem_20.endSeparator	'nl'
HeaderLineItem_20.fieldNames	key,Details
HeaderLineItem_20.keyFieldValue	:20:

100 is to be on safer side... You can put it as 50 if you are sure field1 in your structure will not be more than 50.This is for structures which dont repeat.

Recordset sequence should be variable for structures like :61; and :96:

Recordset/message should be 1

KeyFieldName should be key

ignoreRecordsetName

true

I am sure this will work. Try it else let me know where it fails.

Hope it helps!

Ambrish

[ambrish_mishra]

Hi Bekir,

Please close the thread if you were able to find a solution to your query.

Thanks

Ambrish

[Former Member]

hi,

How did you create it ? Please ensure that you have created a Data type with the correct structure.

I can see that your XML does not have proper 'start' and 'end' tags

Rgds

Krishna