Originally posted by: bchin74

Hi all,

I need some help..
I am getting the following error when I run the map.
In my input record setting, I set the terminator =Literal and value =<LF>. When I view my input file in notepad++, I saw that it has the "LF" value.
so I am not sure why I am getting this error.
(Level 1: Offset 166, len 0, comp 1 of 1, #1, DI 0000001C:)
Data at offset 166 (',200.00<LF>WEST,R06...') does not match TERMINATOR '<LF>'
of TYPE X'0004' (01_RECORD RECORD_TYPES Root).
#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender

Originally posted by: Dhiren.Ghelani

at position 166 it sees a ,200.00 but it expects a end of record... in short add another field.
#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender

Originally posted by: repanzer1

Just to add to what Dhiren.Ghelani mentioned....
Where it says ",200.00<LF>WEST,R06...", that is the exact place where it expects to see the <LF>;

Level 1: Offset 166, len 0, comp 1 of 1, #1, DI 0000001C:)
Data at offset 166 (',200.00<LF>WEST,R06...') does not match TERMINATOR '<LF>'
of TYPE X'0004' (01_RECORD RECORD_TYPES Root).

For any field in the trace file, it shows exactly the data it is trying to validate (,200.00<LF>WEST,R06...) and it says what it expects to be in that place, in this case, the terminator of 01_RECORD RECORD_TYPES Root, which is the <LF>.

Now you need to figure out why the map is looking for the record terminator where the data ",200.00<LF>WEST,R06.." is.

---

There are 10 types of people in this world. Those who understand binary and those who don't.
#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender

Originally posted by: jvanboga

OK, me just being me, in addition to above, to be specific <LF> as a terminator = ascii hex value <<0A>>.

If your trace file as displayed is exactly as the tool wrote it and not modified the value <LF> in string '....00<LF>WES...' is hex <<3c>><<4c>><<46>><<3e>>. I don't think the tool converts non-printable character to readable format for the trace file.
#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender