cancel
Showing results for 
Search instead for 
Did you mean: 

Record type... missing in the end of the file

joel_langoyan
Participant
0 Kudos

Hi Experts,

We trying to pick up files from SFTP server but we always have the error encountered as titled here. Our source file is like below:

"BEG","1.0","D","test.tst","10022019"

"testing","1234","test only","asdf","fdsa","10","20","30","5","10","30","4321","987","ref1","ref2","ref3","ref4","ref5","test.tst"

"EOF","1","95"

Can anyone advice on this?

We have below configured for the FCC.

Error encountered:

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member190293
Active Contributor
0 Kudos

Hi Joel!

I may be wrong, but:

"If you have entered a variable number of substructures under Recordset Structure, that is, you have entered the value * for at least one structure, specify a Key Field Name.

The parser identifies the substructures by their content. This happens using the key field with different constants for the substructures. In this case, you must specify a key field, and the field name must occur in all substructures."

I guess that you should include the key field in each of your described structures and assign key field value for those structures.

Regards, Evgeniy.

joel_langoyan
Participant
0 Kudos

Thanks for your response. I tried using MessageTransformBean cause been reading that SFTP FCC is bugged. But then keyFieldName is required regardless for multiple structure. I just went to take all the rows as single Recordset and just manipulate in mapping to format on the intended structure.