FCC error - Record type: HEADER missing in the end of the file

[ravi_nagar]

Hello Experts,

I have created an FCC scenario, where the file is "~" delimited

01 = HEADER, 02 = ITEM, 03 = Statements

01~123~O~abcd~1234-01~20190501~20240429~0000999999~0001009999~011
02~I1~US~PT~~EQ~PT~Passes Test
02~I2~US~PT~~EQ~PT~Passes Test
03~Country of Origin: US
03~REVNO:1

my FCC is as below

HEADER.fieldNames		ID,A,B,C,D,E,F,G,H,I
HEADER.fieldSeparator		~
HEADER.keyFieldValue		01
HEADER.endSeparator		'nl'
HEADER.keyFieldlnStructure	ignore
ITEM.fieldNames			ID,J,K,L,M,N,O,P
ITEM.fieldSeparator		~
ITEM.keyFieldValue		02
ITEM.endSeparator		'nl'
ITEM.keyFieldlnStructure	ignore
Statements.fieldNames		ID,Statement
Statements.fieldSeparator	~
Statements.keyFieldValue	03
Statements.endSeparator		'nl'

Source XSD structure as below

DT_Source
	Record
		HEADER
			ID
			A
			B,,,I
		ITEM
			ID
			J
			K,,,P
		Statements
			ID
			Statement

while executing I am getting the below error.

Record type: HEADER missing in the end of the file. for file testfile.txt

Can you please help me where I am wrong in FCC??

Thanks,

Ravi

[ravi_nagar · Accepted solution]

Hello

The issue is resolved, it was my spelling mystic. HEADER.keyFieldlnStructure is wrong.

Instead of capital "i" I have written the small letter "L" in the fcc parameter.

correct spelling is keyFieldInStructure.

Thanks,

Ravi

[christopherko]

Hello Ravi,

what are the settings for the content conversion parameters?

Greetings

Christopher

[vossk2]

Hello Ravi,

could you please provide some screenshots of the FCC in the channel?

BR David