ERROR consistency check in recordset structure validation

[Former Member]

Hi,

I have a file that has the format below. The file is managed with the below content conversion parameters. However, it's not working and the error message that i get is "Conversion of file content to XML failed at position 0: java.lang.Exception: ERROR consistency check in recordset structure validation (line no. 7: missing structure(s) in last recordset". Any idea, what when wrong? Thanks.

Message Type defined:

FileHeader (occurrence = 1)

ARPostingRecord (occurrence = 1 to unbounded)

RecordHeader (occurrence = 1 to unbounded)

RecordDetail (occurrence = 1 to unbounded)

Source file looks like this:

01 Field1 Field2...Field-n

H Field1 Field2...Field-n

L Field1 Field2...Field-n

L Field1 Field2...Field-n

H Field1 Field2...Field-n

L Field1 Field2...Field-n

L Field1 Field2...Field-n

where:

01 is the keyfieldvalue for FileHeader

H is the keyfieldvalue for RecordHeader

L is the keyfieldvalue for RecordDetail

Specified parameters:

FileHeader.fieldSeparator

FileHeader.endSeparator

FileHeader.fieldNames

FileHeader.keyFieldValue

RecordHeader.fieldSeparator

RecordHeader.endSeparator

RecordHeader.fieldNames

RecordHeader.keyFieldValue

RecordHeader.missingLastFields

RecordHeader.keepIncompleteFields

RecordDetail.fieldSeparator

RecordDetail.endSeparator

RecordDetail.fieldNames

RecordDetail.keyFieldValue

RecordDetail.missingLastFields

RecordDetail.keepIncompleteFields

ignoreRecordsetName

Recordset Name:

ARPostingRecord

Recordset Structure:

FileHeader,1,RecordHeader,1000000,RecordDetail,1000000

[baskar_gopalakrishnan2 · Accepted solution]

>ERROR consistency check in recordset structure validation (line no. 7: missing structure(s) in last recordset". Any idea, what when wrong?

When you are not sure about number of records for RecordHeader and RecordDetail, Please specify wildchar character. Dont give max numbers. The errors says expecting the specified number for recordset and since it is missing gives errror.

[former_member207622]

Recordset Structure:

FileHeader,1,RecordHeader,1000000,RecordDetail,1000000

can you put the record header and record detail as * in place of 1000000?

thanks

Ninad

[Former Member]

Hi,

Please define the Recordset structure as

FileHeader,1,RecordHeader,\*,RecordDetail,\*

Regards

Edited by: Shiladitya Sarkar on May 23, 2011 11:19 AM