error in seq file
Moderators: chulett, rschirm, roy
error in seq file
Hi all,
My job source is sequential file and target is Dataset. Seq.file->Dataset..i want get all data from seq.file to Dataset.. then following warning i am getting.
Field"SEQUENCE"has import error and no default value;data;{'EXTR_OUT_NEEDS',22/11/2007},at offset 110 here (SEQUENCE is column name) and also i am getting Import warning at record 1, Import unsuccessful at record1.
Thanks
My job source is sequential file and target is Dataset. Seq.file->Dataset..i want get all data from seq.file to Dataset.. then following warning i am getting.
Field"SEQUENCE"has import error and no default value;data;{'EXTR_OUT_NEEDS',22/11/2007},at offset 110 here (SEQUENCE is column name) and also i am getting Import warning at record 1, Import unsuccessful at record1.
Thanks
DSDV
-
- Participant
- Posts: 20
- Joined: Mon Dec 11, 2006 10:57 am
- Location: Pune
Re: error in seq file
Check metadata and Final delimiter property of your sequence file stage.
Also try to do view data on Sequential file stage before running job.
Also try to do view data on Sequential file stage before running job.
Mayur Dongaonkar.
Re: error in seq file
Hi Mayur,
yes,in Seq.feile also i am unable to see meta data...then the following error displaying...
Imported only 4 out of 18 external characters into a ustring of fixed length4. Ignorning last 14 characters of externalustring up to delimiter
yes,in Seq.feile also i am unable to see meta data...then the following error displaying...
Imported only 4 out of 18 external characters into a ustring of fixed length4. Ignorning last 14 characters of externalustring up to delimiter
ThanksMayur Dongaonkar wrote:Check metadata and Final delimiter property of your sequence file stage.
Also try to do view data on Sequential file stage before running job.
DSDV
Re: error in seq file
Hi Mayur,
yes,in Seq.feile also i am unable to see meta data...then the following error displaying...
Imported only 4 out of 18 external characters into a ustring of fixed length4. Ignorning last 14 characters of externalustring up to delimiter
yes,in Seq.feile also i am unable to see meta data...then the following error displaying...
Imported only 4 out of 18 external characters into a ustring of fixed length4. Ignorning last 14 characters of externalustring up to delimiter
ThanksMayur Dongaonkar wrote:Check metadata and Final delimiter property of your sequence file stage.
Also try to do view data on Sequential file stage before running job.
DSDV
-
- Premium Member
- Posts: 55
- Joined: Tue Apr 24, 2007 1:26 am
Re: error in seq file
Hi,
First in which format the data is in? Like , if the data file is in unix , open and see it. Then set the format properties of the sequential file in data stage. And try to view the data.
As per your post, EXTR_OUT_NEEDS is the column name. Lenght must match the data lenght.
First in which format the data is in? Like , if the data file is in unix , open and see it. Then set the format properties of the sequential file in data stage. And try to view the data.
As per your post, EXTR_OUT_NEEDS is the column name. Lenght must match the data lenght.
Re: error in seq file
Hi,
My self create the source file thats why those warnings coming...Now i solved...Thank you
My self create the source file thats why those warnings coming...Now i solved...Thank you
venbrk wrote:Hi,
First in which format the data is in? Like , if the data file is in unix , open and see it. Then set the format properties of the sequential file in data stage. And try to view the data.
As per your post, EXTR_OUT_NEEDS is the column name. Lenght must match the data lenght.
DSDV