DSXchange

I am getting this error on a 101 line file. This only happens on line 101. If I take the first 100 lines and try to load, it loads fine. Things I have tried:

1)Went through all posts in the forum to find the resolution.

2)Checked that line thoroughly and checked with other lines. No difference at all.

3)Did: od -c. Found nothing different.

4)Tried to use fixtool. Got the message:
This is not a UniVerse file.

5)Did a view data of the file in the source sequential file. Looks fine.

My job is:
seq file -> transformer -> lookup -> oracle enterprise1
^
|
oracle enterprise2

The oracle enterprise2 stage is really with the lookup stage. dsxchange shifts the positions after posting.

More info:
1)My config file has only one node.
2)Another error I get later is:
sendWriteSignal() failed on node xxxx

Any ideas?

Is there a line terminator at the end of line number 101?

No but I have set:
Final delimiter=none

Hi
What is the exact error you getting.
It can be of various reasons like -duplicate value for key,Look up Fail


Regards,
Rakesh

Final Delimiter is not the same as Record Delimiter. How have you set Record Delimiter?

If you open the file using vi and position to the end of the file (0G) is the cursor at the end of the last line or on a new empty line? This will tell you whether or not there's a line terminator on the final line.

It is at the end of the last line. When I did:
od -c
the record delimiter shows as \r \n

This job has been running for over two year successfully with large files.

You're on UNIX yet you have DOS-style line terminators. All values in the final column are likely to have an unwanted \r at their end. Change the format to set Record Delimiter String to "DOS style".