Parallel Extender - view file error

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
hemant
Participant
Posts: 67
Joined: Mon Dec 15, 2003 6:43 am

Parallel Extender - view file error

Post by hemant »

Hi All

I am working on parallel extender job.
I have load the meta data and can see it via transformation but can't see the data when i view the same .
The above error is encountered .
--------------------------------------------------------------------------------------
##I TFCN 000001 13:19:54(000) <main_program>
DataStage XE Parallel Extender V7.0.1
Copyright (C) 2003, 1997 - 2002 Ascential Software, Inc.
All Rights Reserved


##I TUTL 000031 13:19:54(001) <main_program> The open files limit is 100; raising to 1000.
##I TOSH 000002 13:19:54(002) <main_program> orchgeneral: loaded
##I TOSH 000002 13:19:54(003) <main_program> orchsort: loaded
##I TOSH 000002 13:19:54(004) <main_program> orchstats: loaded
##I TFSC 000001 13:19:54(005) <main_program> APT configuration file: /u22/prdadhoc/datastage/data2/dspx71/Ascential/DataStage/Configurations/default.apt
##W TFPA 000017 13:19:54(006) <main_program> Warning: the value of the PWD environment variable (/u22/prdadhoc/datastage/data2/dspx71/Ascential/DataStage/DSEngine) does not appear to be a synonym for the current working directory (/u22/prdadhoc/datastage/data2/dspx71/Ascential/DataStage/Projects/RIL_POC). 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 13:19:55(000) <main_program> Parameter specified but not used in flow: DSProjectMapName
**VIEWDATA ROW LIMITER HIT**
--------------------------------------------------------------------------------------
Can anybody who have worked on parallel extender let me know where i am lacking.I will really appreciate any early help in this regards.



- Hemant
sanjay
Premium Member
Premium Member
Posts: 203
Joined: Fri Apr 23, 2004 2:22 am

Re: Parallel Extender - view file error

Post by sanjay »

Hi Hemant

set Library path , shell search path and Temporary directory

in enviroment variables Throught administrator for that particular project
u have enviroment option.
Sanjay
hemant wrote:Hi All

I am working on parallel extender job.
I have load the meta data and can see it via transformation but can't see the data when i view the same .
The above error is encountered .
--------------------------------------------------------------------------------------
##I TFCN 000001 13:19:54(000) <main_program>
DataStage XE Parallel Extender V7.0.1
Copyright (C) 2003, 1997 - 2002 Ascential Software, Inc.
All Rights Reserved


##I TUTL 000031 13:19:54(001) <main_program> The open files limit is 100; raising to 1000.
##I TOSH 000002 13:19:54(002) <main_program> orchgeneral: loaded
##I TOSH 000002 13:19:54(003) <main_program> orchsort: loaded
##I TOSH 000002 13:19:54(004) <main_program> orchstats: loaded
##I TFSC 000001 13:19:54(005) <main_program> APT configuration file: /u22/prdadhoc/datastage/data2/dspx71/Ascential/DataStage/Configurations/default.apt
##W TFPA 000017 13:19:54(006) <main_program> Warning: the value of the PWD environment variable (/u22/prdadhoc/datastage/data2/dspx71/Ascential/DataStage/DSEngine) does not appear to be a synonym for the current working directory (/u22/prdadhoc/datastage/data2/dspx71/Ascential/DataStage/Projects/RIL_POC). 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 13:19:55(000) <main_program> Parameter specified but not used in flow: DSProjectMapName
**VIEWDATA ROW LIMITER HIT**
--------------------------------------------------------------------------------------
Can anybody who have worked on parallel extender let me know where i am lacking.I will really appreciate any early help in this regards.



- Hemant
hemant
Participant
Posts: 67
Joined: Mon Dec 15, 2003 6:43 am

Re: Parallel Extender - view file error

Post by hemant »

Hi Sanjay

Thanxs for the reply but
I didn't get you write me explicitly what changes in the environment i have to do,just briefly write down the steps
so i can go ahead for the successful completion .


Regards
Hemant
Post Reply