unable to view data in sequential file
Moderators: chulett, rschirm, roy
unable to view data in sequential file
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.
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.
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.
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.
- james wiles
All generalizations are false, including this one - Mark Twain.
All generalizations are false, including this one - Mark Twain.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.