Error reading sequential file

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
Rea_Antony
Participant
Posts: 73
Joined: Thu Mar 08, 2007 9:50 pm
Location: Bangalore

Error reading sequential file

Post by Rea_Antony »

Hi,
I have the following error while trying to read a text file using a sequential file stage:
##W TOIX 000000 09:10:34(000) <Simple_Mapping_In,0> Input buffer overrun at field "Reserved4b", at offset: 880
##W TOIX 000154 09:10:34(001) <Simple_Mapping_In,0> Import warning at record 0.
##W TOIX 000018 09:10:34(002) <Simple_Mapping_In,0> Import unsuccessful at record 0.
##W TOIX 000000 09:10:34(003) <Simple_Mapping_In,0> Input buffer overrun at field "Filler5", at offset: 1852
##W TOIX 000154 09:10:34(004) <Simple_Mapping_In,0> Import warning at record 1.
##W TOIX 000018 09:10:34(005) <Simple_Mapping_In,0> Import unsuccessful at record 1.
##W TOIX 000000 09:10:34(006) <Simple_Mapping_In,0> Input buffer overrun at field "Filler5", at offset: 1852
##W TOIX 000154 09:10:34(007) <Simple_Mapping_In,0> Import warning at record 2.
##W TOIX 000018 09:10:34(008) <Simple_Mapping_In,0> Import unsuccessful at record 2.
##W TOIX 000000 09:10:34(009) <Simple_Mapping_In,0> Input buffer overrun at field "Filler5", at offset: 1852
##W TOIX 000154 09:10:34(010) <Simple_Mapping_In,0> Import warning at record 3.
##W TOIX 000018 09:10:34(011) <Simple_Mapping_In,0> Import unsuccessful at record 3.
##W TOIX 000000 09:10:34(012) <Simple_Mapping_In,0> Input buffer overrun at field "Filler5", at offset: 1852
##W TOIX 000154 09:10:34(013) <Simple_Mapping_In,0> Import warning at record 4.
##W TOIX 000018 09:10:34(014) <Simple_Mapping_In,0> Import unsuccessful at record 4.


My colleague said it might be because the notepad i use to view the file displays only 1024 bytes in a line?

My file is a fixed width file. It as 2000 bytes. I'm not using any delimiter.

Please help me.. I'm new to parallel extender.. been working on server till now.
mk_ds09
Participant
Posts: 72
Joined: Sun Jan 25, 2009 4:50 pm
Location: Pune

Post by mk_ds09 »

Sequential file from Server to parellel is quite different one..

First thing that you need to check is all the properties of the stage.

Most importantly check delimiter, final delimiter and quote.. Most of the things get messy with the usage of these properties.

If record legnth is fixed, use that property also..

Hope this helps..

-------------

MK

--------
Rea_Antony
Participant
Posts: 73
Joined: Thu Mar 08, 2007 9:50 pm
Location: Bangalore

Post by Rea_Antony »

Hi,
Thank you very much for your response.
the issue was that the i had defined teh file to 2K as that was teh expected input. Sadly, the file provided to me had only 1912 bytes and hence the error.
It is working fine now.
Post Reply