cancel
Showing results for 
Search instead for 
Did you mean: 

File Content Conversion Error

Former Member
0 Kudos

Hi Experts,

I have a requirement to process the fixed length file. But records are not in sequence. When I try to process the file am getting below error in Communication channel.

I have attached sample file and the channel error screen shot. In this NY000010 is the Key for Header and NY000089 is the Key for Footer.

Same way NY090020, NY091030, NY091031and NY090088 are items. These items are repeating based on below sequence.

I have configured the channel like below.

Please guide me to solve. And let me know for further details.

Regards

Satya

Accepted Solutions (0)

Answers (4)

Answers (4)

former_member182412
Active Contributor
0 Kudos

Hi Satya,

If you need header and footer structures in the mapping you can use below.

RecordsetName = record

RecordsetStructure = rectype10,*,rectype20,*,rectype30,*,rectype31,*,rectype88,*,rectype89,*

RecordsetSequence = variable

Recordsets per Message = *

Regards,

Praveen.

RaghuVamseedhar
Active Contributor
0 Kudos

Satya,

Please try

RecordsetStructure = NY000010,*,NY090020,*,NY090030,*,NY090031,*,NY090088,*,NY000089,*


In message mapping you can remove/ignore Record context.

former_member182412
Active Contributor
0 Kudos

Hi Satya,

If you dont require header and footer structures in the mapping you can do like below.

RecordsetName = record

RecordsetStructure = rectype20,1,rectype30,*,rectype31,*,rectype88,*

RecordsetSequence = variable

Recordsets per Message = *

Regards,

Praveen

Former Member
0 Kudos

Hi Satya

I think your file needs to be sorted in order for FCC to work.

The file should be in this format

NY000010 ...........

NY090020....

NY090020.....

NY090030

NY090030

NY090031

NY090031

NY090088

NY090088

NY000089


Or else the file should be in this format


NY000010 ...........

NY090020....

NY090030

NY090031

NY090088

NY000089

NY000010 ...........

NY090020....

NY090030

NY090031

NY090088

NY000089


Thanks,

Indrajit