Paralell Extender Configuration
Posted: Wed Mar 03, 2004 4:55 pm
I am trying to code my first Paralell job what I am trying to do is simply read from a flat file and write out to a flat file.
The job is simply 2 Sequential File Stages and one transformer stage.
When I try to view data I get the following warning message from the DataStage Repository Interface
"No rows were returned from the View Data server commnad.
Would you like to view the command's output?"
When I press Yes below is the message that shows up
Any configuration help is welcome - Thanks everybody.
##I TFCN 000000 21:57:49(000) <main_program>
DataStage XE Parallel Extender V6.0.1
Copyright (C) 1997 - 2002 Ascential Software, Inc.
All Rights Reserved
##I TUTL 001002 21:57:49(001) <main_program> The open files limit is 100; raising to 2048.
##I TOSH 000010 21:57:49(002) <main_program> orchgeneral: loaded
##I TOSH 000010 21:57:49(003) <main_program> orchsort: loaded
##I TOSH 000010 21:57:49(004) <main_program> orchstats: loaded
##I TFSC 000000 21:57:49(005) <main_program> APT configuration file: /opt/Ascential/DataStage/Configurations/default.apt
##W TFPA 000002 21:57:49(006) <main_program> Warning: the value of the PWD environment variable (/) does not appear to be a synonym for the current working directory (/export/interface/etldata/CMIS/project). 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 TFIG 000514 21:57:50(000) <Sequential_File_0.DSLink2,0> Input buffer overrun at field "SOURCE_FILE_NAME", at offset: 149
##W TOIX 000059 21:57:50(001) <Sequential_File_0.DSLink2,0> Import warning at record 0:
##W TOIX 000060 21:57:50(002) <Sequential_File_0.DSLink2,0> Import unsuccessful at record 0:
##W TFIG 000514 21:57:50(003) <Sequential_File_0.DSLink2,0> Input buffer overrun at field "SOURCE_FILE_NAME", at offset: 143
##W TOIX 000059 21:57:50(004) <Sequential_File_0.DSLink2,0> Import warning at record 1:
##W TOIX 000060 21:57:50(005) <Sequential_File_0.DSLink2,0> Import unsuccessful at record 1:
##W TFIG 000514 21:57:50(006) <Sequential_File_0.DSLink2,0> Input buffer overrun at field "SOURCE_FILE_NAME", at offset: 143
##W TOIX 000059 21:57:50(007) <Sequential_File_0.DSLink2,0> Import warning at record 2:
##W TOIX 000060 21:57:50(008) <Sequential_File_0.DSLink2,0> Import unsuccessful at record 2:
##I TOIX 000032 21:57:50(009) <Sequential_File_0.DSLink2,0> Import complete. 0 records imported successfully, 3 rejected.
**VIEWDATA ROW LIMITER HIT**
The job is simply 2 Sequential File Stages and one transformer stage.
When I try to view data I get the following warning message from the DataStage Repository Interface
"No rows were returned from the View Data server commnad.
Would you like to view the command's output?"
When I press Yes below is the message that shows up
Any configuration help is welcome - Thanks everybody.
##I TFCN 000000 21:57:49(000) <main_program>
DataStage XE Parallel Extender V6.0.1
Copyright (C) 1997 - 2002 Ascential Software, Inc.
All Rights Reserved
##I TUTL 001002 21:57:49(001) <main_program> The open files limit is 100; raising to 2048.
##I TOSH 000010 21:57:49(002) <main_program> orchgeneral: loaded
##I TOSH 000010 21:57:49(003) <main_program> orchsort: loaded
##I TOSH 000010 21:57:49(004) <main_program> orchstats: loaded
##I TFSC 000000 21:57:49(005) <main_program> APT configuration file: /opt/Ascential/DataStage/Configurations/default.apt
##W TFPA 000002 21:57:49(006) <main_program> Warning: the value of the PWD environment variable (/) does not appear to be a synonym for the current working directory (/export/interface/etldata/CMIS/project). 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 TFIG 000514 21:57:50(000) <Sequential_File_0.DSLink2,0> Input buffer overrun at field "SOURCE_FILE_NAME", at offset: 149
##W TOIX 000059 21:57:50(001) <Sequential_File_0.DSLink2,0> Import warning at record 0:
##W TOIX 000060 21:57:50(002) <Sequential_File_0.DSLink2,0> Import unsuccessful at record 0:
##W TFIG 000514 21:57:50(003) <Sequential_File_0.DSLink2,0> Input buffer overrun at field "SOURCE_FILE_NAME", at offset: 143
##W TOIX 000059 21:57:50(004) <Sequential_File_0.DSLink2,0> Import warning at record 1:
##W TOIX 000060 21:57:50(005) <Sequential_File_0.DSLink2,0> Import unsuccessful at record 1:
##W TFIG 000514 21:57:50(006) <Sequential_File_0.DSLink2,0> Input buffer overrun at field "SOURCE_FILE_NAME", at offset: 143
##W TOIX 000059 21:57:50(007) <Sequential_File_0.DSLink2,0> Import warning at record 2:
##W TOIX 000060 21:57:50(008) <Sequential_File_0.DSLink2,0> Import unsuccessful at record 2:
##I TOIX 000032 21:57:50(009) <Sequential_File_0.DSLink2,0> Import complete. 0 records imported successfully, 3 rejected.
**VIEWDATA ROW LIMITER HIT**