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?
mmap()failed. Invalid argument
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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".
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.