Unable to View data from sequential file

harithay · Post by **harithay** » Tue Jul 19, 2005 9:37 am

Hi,

i am writing data to sequential file(tab delimited) in Server job. The view data in server 'sequentail file stage' is fine

when i am using same data file in parallel job .when i want to view the data in parallel sequntial file stage it is giving follwing error

##I TUTL 000031 11:27:49(001) <main_program> The open files limit is 100; raising to 4096.
##I TOSH 000002 11:27:49(002) <main_program> orchgeneral: loaded
##I TOSH 000002 11:27:49(003) <main_program> orchsort: loaded
##I TOSH 000002 11:27:49(004) <main_program> orchstats: loaded
##I TFSC 000001 11:27:49(005) <main_program> APT configuration file: /detld2/etl/ascential/Ascential/DataStage/Configurations/default.apt
##W TFPA 000017 11:27:49(006) <main_program> Warning: the value of the PWD environment variable (/detld2/etl/ascential/Ascential/DataStage/DSEngine) does not appear to be a synonym for the current working directory (/detld2/etl/ascential/Ascential/DataStage/Projects/BASEL2). The current working directory will be used, but if your ORCHESTRATE job does not start up correctly, you should set your PWD environment variable to a value that will work on all nodes of your system.
##W TCOS 000049 11:27:51(000) <main_program> Parameter specified but not used in flow: DSProjectMapName
##W TOIX 000000 11:27:54(000) <Sequential_File_8,0> Field "DATE" delimiter not seen, at offset: 99
##W TOIX 000154 11:27:54(001) <Sequential_File_8,0> Import warning at record 0.
##W TOIX 000018 11:27:54(002) <Sequential_File_8,0> Import unsuccessful at record 0.
##W TOIX 000000 11:27:54(003) <Sequential_File_8,0> Field "DATE" delimiter not seen, at offset: 99
##W TOIX 000154 11:27:54(004) <Sequential_File_8,0> Import warning at record 1.
##W TOIX 000018 11:27:54(005) <Sequential_File_8,0> Import unsuccessful at record 1.
##W TOIX 000000 11:27:54(006) <Sequential_File_8,0> Field "DATE" delimiter not seen, at offset: 99
##W TOIX 000154 11:27:54(007) <Sequential_File_8,0> Import warning at record 2.
##W TOIX 000018 11:27:54(008) <Sequential_File_8,0> Import unsuccessful at record 2.
##W TOIX 000000 11:27:54(009) <Sequential_File_8,0> Field "DATE" delimiter not seen, at offset: 79
##W TOIX 000154 11:27:54(010) <Sequential_File_8,0> Import warning at record 3.
##W TOIX 000018 11:27:54(011) <Sequential_File_8,0> Import unsuccessful at record 3.
##W TOIX 000000 11:27:54(012) <Sequential_File_8,0> Field "DATE" delimiter not seen, at offset: 79
##W TOIX 000154 11:27:54(013) <Sequential_File_8,0> Import warning at record 4.
##W TOIX 000018 11:27:54(014) <Sequential_File_8,0> Import unsuccessful at record 4.
##I TOIX 000193 11:27:54(015) <Sequential_File_8,0> No further reports will be generated from this partition until a successful import.
##I TOIX 000156 11:27:54(016) <Sequential_File_8,0> Progress: 10 percent.
##I TOIX 000156 11:27:54(017) <Sequential_File_8,0> Progress: 20 percent.
##I TOIX 000156 11:27:54(018) <Sequential_File_8,0> Progress: 30 percent.
##I TOIX 000156 11:27:54(019) <Sequential_File_8,0> Progress: 40 percent.
##I TOIX 000156 11:27:54(020) <Sequential_File_8,0> Progress: 50 percent.
##I TOIX 000156 11:27:54(021) <Sequential_File_8,0> Progress: 60 percent.
##I TOIX 000156 11:27:54(022) <Sequential_File_8,0> Progress: 70 percent.
##I TOIX 000156 11:27:54(023) <Sequential_File_8,0> Progress: 80 percent.
##I TOIX 000156 11:27:54(024) <Sequential_File_8,0> Progress: 90 percent.
##I TOIX 000163 11:27:54(025) <Sequential_File_8,0> Import complete; 0 records imported successfully, 2511 rejected.
**VIEWDATA ROW LIMITER HIT**

Thanks in advance

elavenil · Post by **elavenil** » Tue Jul 19, 2005 9:58 am

Does this DATE field contain any value? If the field is having NULL value, can you assign a default value while reading sequential file and transform it back in the transformer stage after completing the read operation.

HTWH.

Regards
Saravanan

harithay · Post by **harithay** » Tue Jul 19, 2005 10:30 am

Hi ,

Thanks for ur reply

I got It, By changing Sql type to "Varchar" and deleting the numbers in ' length'.

Thanks

elavenil wrote:Does this DATE field contain any value? If the field is having NULL value, can you assign a default value while reading sequential file and transform it back in the transformer stage after completing the read operation.

HTWH.

Regards
Saravanan

ranga1970 · Post by **ranga1970** » Tue Jul 19, 2005 10:52 pm

This should have been post in Parrallel forum

thanks

harithay · Post by **harithay** » Wed Jul 20, 2005 1:05 pm

Hi ,

sorry for posting in server jobs.

ranga1970 wrote:This should have been post in Parrallel forum

thanks