Regarding oracle enterprise stage
Posted: Mon Sep 05, 2005 2:24 am
hi,
i'm not able to view the data from oracle enterprise stage in parallel canvas. But when i use oracle stage in server canvas with same specifications, i can view the data. I'm using the same table to view data in both canvases.
In parallel canvas it is throwing the following message:
"##E TOSH 000205 03:17:02(001) <main_program> PATH search failure"
& after cloicking on data browser it is showing following error:
##I TFCN 000001 03:21:40(000) <main_program>
Ascential DataStage(tm) Enterprise Edition 7.5.1
Copyright (c) 2004, 1997-2004 Ascential Software Corporation.
All Rights Reserved
##I TUTL 000031 03:21:40(001) <main_program> The open files limit is 1024; raising to 10000.
##I TOSH 000002 03:21:41(000) <main_program> orchgeneral: loaded
##I TOSH 000002 03:21:41(001) <main_program> orchsort: loaded
##I TOSH 000002 03:21:41(002) <main_program> orchstats: loaded
##I TFSC 000001 03:21:41(003) <main_program> APT configuration file: /data/dw/cl/dev/clw/admin/cldw_1Node.apt
##W TFPA 000017 03:21:41(004) <main_program> Warning: the value of the PWD environment variable (/opt/tools/datastage7/Ascential/DataStage/DSEngine) does not appear to be a synonym for the current working directory (/data/dw/cl/projectlib/cl_dev). 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 03:21:43(000) <main_program> Parameter specified but not used in flow: DSProjectMapName
>##E TOSH 000205 03:21:44(000) <main_program> PATH search failure:
>##E TOSH 000000 03:21:44(001) <main_program> Error loading "orchoracle": Could not find "orchoracle" on the library search path defined by the environment variable LD_LIBRARY_PATH; path: /data/dw/cl/projectlib/cl_dev/buildop:/opt/tools/datastage7/Ascential/DataStage/DSCAPIOp:/opt/tools/datastage7/Ascential/DataStage/RTIOperators:/opt/tools/datastage7/Ascential/DataStage/DSParallel:/opt/tools/datastage7/Ascential/DataStage/PXEngine/user_lib:/opt/tools/datastage7/Ascential/DataStage/PXEngine/lib:/opt/tools/sybase/OCS-12_5/lib3p:/opt/tools/sybase/OCS-12_5/lib:/opt/tools/datastage7/Ascential/DataStage/DSEngine/java/jre/lib/sparc/client:/opt/tools/datastage7/Ascential/DataStage/DSEngine/java/jre/lib/sparc:/opt/tools/datastage7/Ascential/DataStage/branded_odbc/lib:/opt/tools/datastage7/Ascential/DataStage/DSEngine/lib:/opt/tools/datastage7/Ascential/DataStage/DSEngine/uvdlls:/opt/tools/oracle/product/9.2.0/lib:/opt/tools/datastage7/Ascential/DataStage/DSEngine/java/jre/lib/sparc/client:/opt/tools/datastage7/Ascential/DataStage/DSEngine/java/jre/lib/sparc:/opt/tools/datastage7/Ascential/DataStage/branded_odbc/lib:/opt/tools/datastage7/Ascential/DataStage/DSEngine/lib:/opt/tools/datastage7/Ascential/DataStage/DSEngine/uvdlls::/export/home/db2inst3/sqllib/lib:/opt/IBM/db2/V8.1/bin:/opt/IBM/db2/V8.1/lib:/usr/lib:/lib.
>##E TOSH 000000 03:21:44(002) <main_program> Could not locate operator definition, wrapper, or Unix command for "oraread"; please check that all needed libraries are preloaded, and check the PATH for the wrappers
>##E TCOS 000029 03:21:44(003) <main_program> Creation of a step finished with status = FAILED.
i'm not able to view the data from oracle enterprise stage in parallel canvas. But when i use oracle stage in server canvas with same specifications, i can view the data. I'm using the same table to view data in both canvases.
In parallel canvas it is throwing the following message:
"##E TOSH 000205 03:17:02(001) <main_program> PATH search failure"
& after cloicking on data browser it is showing following error:
##I TFCN 000001 03:21:40(000) <main_program>
Ascential DataStage(tm) Enterprise Edition 7.5.1
Copyright (c) 2004, 1997-2004 Ascential Software Corporation.
All Rights Reserved
##I TUTL 000031 03:21:40(001) <main_program> The open files limit is 1024; raising to 10000.
##I TOSH 000002 03:21:41(000) <main_program> orchgeneral: loaded
##I TOSH 000002 03:21:41(001) <main_program> orchsort: loaded
##I TOSH 000002 03:21:41(002) <main_program> orchstats: loaded
##I TFSC 000001 03:21:41(003) <main_program> APT configuration file: /data/dw/cl/dev/clw/admin/cldw_1Node.apt
##W TFPA 000017 03:21:41(004) <main_program> Warning: the value of the PWD environment variable (/opt/tools/datastage7/Ascential/DataStage/DSEngine) does not appear to be a synonym for the current working directory (/data/dw/cl/projectlib/cl_dev). 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 03:21:43(000) <main_program> Parameter specified but not used in flow: DSProjectMapName
>##E TOSH 000205 03:21:44(000) <main_program> PATH search failure:
>##E TOSH 000000 03:21:44(001) <main_program> Error loading "orchoracle": Could not find "orchoracle" on the library search path defined by the environment variable LD_LIBRARY_PATH; path: /data/dw/cl/projectlib/cl_dev/buildop:/opt/tools/datastage7/Ascential/DataStage/DSCAPIOp:/opt/tools/datastage7/Ascential/DataStage/RTIOperators:/opt/tools/datastage7/Ascential/DataStage/DSParallel:/opt/tools/datastage7/Ascential/DataStage/PXEngine/user_lib:/opt/tools/datastage7/Ascential/DataStage/PXEngine/lib:/opt/tools/sybase/OCS-12_5/lib3p:/opt/tools/sybase/OCS-12_5/lib:/opt/tools/datastage7/Ascential/DataStage/DSEngine/java/jre/lib/sparc/client:/opt/tools/datastage7/Ascential/DataStage/DSEngine/java/jre/lib/sparc:/opt/tools/datastage7/Ascential/DataStage/branded_odbc/lib:/opt/tools/datastage7/Ascential/DataStage/DSEngine/lib:/opt/tools/datastage7/Ascential/DataStage/DSEngine/uvdlls:/opt/tools/oracle/product/9.2.0/lib:/opt/tools/datastage7/Ascential/DataStage/DSEngine/java/jre/lib/sparc/client:/opt/tools/datastage7/Ascential/DataStage/DSEngine/java/jre/lib/sparc:/opt/tools/datastage7/Ascential/DataStage/branded_odbc/lib:/opt/tools/datastage7/Ascential/DataStage/DSEngine/lib:/opt/tools/datastage7/Ascential/DataStage/DSEngine/uvdlls::/export/home/db2inst3/sqllib/lib:/opt/IBM/db2/V8.1/bin:/opt/IBM/db2/V8.1/lib:/usr/lib:/lib.
>##E TOSH 000000 03:21:44(002) <main_program> Could not locate operator definition, wrapper, or Unix command for "oraread"; please check that all needed libraries are preloaded, and check the PATH for the wrappers
>##E TCOS 000029 03:21:44(003) <main_program> Creation of a step finished with status = FAILED.