Error while Reading || Sequential File

[vamsi2508]

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.

[samyamkrishna]

can you please post the sample data.

[zulfi123786]

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

[tbharathkumar]

Can you Check max length of that column/ Check any record contains extra delimiters.. like comma in full address column.. etc

[vamsi2508]

sure sir..i will check with your notes and get back to you..

[soumya.buna]

can you please tell the type of file? means fixed width or delimited?

[vamsi2508]

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.

[Sampath]

Use VARCHAR 19