unable to view data in sequential file

raji33 · Post by **raji33** » Fri Mar 18, 2011 8:17 am

Hi All,

Iam trying to view data in sequential file but it is throwing the following error, can any one please help me. Thanks!

I IIS-DSEE-TFSC-00001 10:13:51(011) <main_program> APT configuration file: /opt/IBM/InformationServer/Server/Configurations/default.apt
##W IIS-DSEE-TFIG-00182 10:13:52(000) <Sequential_File_20,0> Bad trailing quote character at field "TIMESTMP"; looking for '34' but found '.', at offset: 261
##W IIS-DSEE-TOIX-00154 10:13:52(001) <Sequential_File_20,0> Import warning at record 0.
##W IIS-DSEE-TOIX-00018 10:13:52(002) <Sequential_File_20,0> Import unsuccessful at record 0.
##W IIS-DSEE-TFIG-00182 10:13:52(003) <Sequential_File_20,0> Bad trailing quote character at field "TIMESTMP"; looking for '34' but found '.', at offset: 249
##W IIS-DSEE-TOIX-00154 10:13:52(004) <Sequential_File_20,0> Import warning at record 1.
##W IIS-DSEE-TOIX-00018 10:13:52(005) <Sequential_File_20,0> Import unsuccessful at record 1.
##W IIS-DSEE-TFIG-00182 10:13:52(006) <Sequential_File_20,0> Bad trailing quote character at field "TIMESTMP"; looking for '34' but found '.', at offset: 212
##W IIS-DSEE-TOIX-00154 10:13:52(007) <Sequential_File_20,0> Import warning at record 2.
##W IIS-DSEE-TOIX-00018 10:13:52(008) <Sequential_File_20,0> Import unsuccessful at record 2.

GJ_Stage · Post by **GJ_Stage** » Fri Mar 18, 2011 8:21 am

Is it fixed length file or delimiter file?

raji33 · Post by **raji33** » Fri Mar 18, 2011 8:23 am

its a comma seperated file

GJ_Stage · Post by **GJ_Stage** » Fri Mar 18, 2011 8:26 am

Please check your sequencial file in unix using below command
awk -F ',' '{print $34}' infile | sort -n | uniq -c
It might be your data contains some wrong value.

raji33 · Post by **raji33** » Fri Mar 18, 2011 8:33 am

command not found . we are using linux operating system(bash)

GJ_Stage · Post by **GJ_Stage** » Fri Mar 18, 2011 8:37 am

Ok. I send command for Unix.. Might be Number of fields are less comparing with your file.

jwiles · Post by **jwiles** » Fri Mar 18, 2011 8:40 am

The error message says a lot:

Bad trailing quote character at field "TIMESTMP"; looking for '34' but found '.', at offset: 261

What is your schema for the file and what do the records actually look like?

Regards,

raji33 · Post by **raji33** » Fri Mar 18, 2011 8:43 am

actually i have took the target table metadata table definitions so i dont think there is a problem of fields being less in file. and schema of file is table structure

jwiles · Post by **jwiles** » Fri Mar 18, 2011 9:00 am

That may be so, but you failed to supply the answer to my questions:

What is the schema being used to read the file? Post the actual schema, don't just tell me where you got it from.

What do the records which failed look like? Post the records themselves--copy and paste from vi, more, less, head, tail, whatever

The point being: The schema being used to read the file does not match the file's data in some way.

ray.wurlod · Post by **ray.wurlod** » Fri Mar 18, 2011 3:41 pm

I expect that this is a non-default timestamp format, which you should be able to resolve by providing the correct timestamp format in the metadata (whether that's in the job or in a schema file). The import operator is looking for the trailing quote character or a timestamp character, but found "." character.