Hi ..
Warning messages in the director :
1. node_test01_node1: The open files limit is 2000; raising to 2147483647.
2. EQL_File,0: Field "STRT_TS" delimiter not seen, at offset: 53
I am trying to read a txt file using a sequential file stage. But the records are not getting loaded.
There is one field names STRT_TS -varchar 26/6 time stamp. All the fields are delimited by comma. but it saying no delimiter was found.
Error while Reading || Sequential File
Moderators: chulett, rschirm, roy
Error while Reading || Sequential File
Vamsi Karthik
Consultant/DWBI
Consultant/DWBI
-
- Premium Member
- Posts: 258
- Joined: Tue Jul 04, 2006 10:35 pm
- Location: Toronto
Re: Error while Reading || Sequential File
can you please post the sample data.
-
- Premium Member
- Posts: 730
- Joined: Tue Nov 04, 2008 10:14 am
- Location: Bangalore
The fixed length fields should occupy the specified length, else you will end up with the warning saying "delimiter not seen at offset XX"
in the seq file change the datatype of all columns to varchar with no length specified and then do a "view data" you should be able to read the file.
Now carefully look at the fixed length fields ( those defined as char, date, timestamp, decimal etc) to make sure the occupy the length specified,
Usually this happens when any column of fixed length happens to be a null and blanks are used to represent NULLs, check if this is the issue with you, in such case use appropriate NULL field values
in the seq file change the datatype of all columns to varchar with no length specified and then do a "view data" you should be able to read the file.
Now carefully look at the fixed length fields ( those defined as char, date, timestamp, decimal etc) to make sure the occupy the length specified,
Usually this happens when any column of fixed length happens to be a null and blanks are used to represent NULLs, check if this is the issue with you, in such case use appropriate NULL field values
-
- Participant
- Posts: 26
- Joined: Mon Aug 27, 2007 6:27 am
- Location: Des Moines
Re: Error while Reading || Sequential File
Can you Check max length of that column/ Check any record contains extra delimiters.. like comma in full address column.. etc
Regards,
Bharath Tipirisetty
Bharath Tipirisetty
-
- Participant
- Posts: 3
- Joined: Tue Apr 01, 2008 7:15 am
- Location: Hyderabad
Re: Error while Reading || Sequential File
can you please tell the type of file? means fixed width or delimited?
Soumyaranjan Mohaptra
Re: Error while Reading || Sequential File
The file is a comma delimited file. the sample data looks like
"1","GSTBRWS01_SF_LZ_INSRT","ETL","2011-04-15 04:57:32","2011-04-15 04:58:04","2",1072,3768,0,0,"BROWSE_SESSION_ACTIVITY_E","ADWGSTBRWS"
************ Thank you.
"1","GSTBRWS01_SF_LZ_INSRT","ETL","2011-04-15 04:57:32","2011-04-15 04:58:04","2",1072,3768,0,0,"BROWSE_SESSION_ACTIVITY_E","ADWGSTBRWS"
************ Thank you.
Vamsi Karthik
Consultant/DWBI
Consultant/DWBI