DSXchange

Hi all,

This issue is related to running parallel jobs in datastage.

On clicking on "View data" tab in Oracle enterprise database stage, I get the pop up error window which saying
"Error executing View data command; ##E TOSH 000205 02:10:36(001) <main program> PATH search failure: "

On hitting Ok , I get an error browser window which gives me the following error details:

------------------------------------------------------------------------------------
##I TFCN 000001 02:10:33(000) <main_program>

Ascential DataStage(tm) Enterprise Edition 7.5

Copyright (c) 2004, 1997-2004 Ascential Software Corporation.

All Rights Reserved



##I TOSH 000002 02:10:34(000) <main_program> orchgeneral: loaded

##I TOSH 000002 02:10:34(001) <main_program> orchsort: loaded

##I TOSH 000002 02:10:34(002) <main_program> orchstats: loaded

##I TFSC 000001 02:10:34(003) <main_program> APT configuration file: /opt/ascential/dsadm/Ascential/DataStage/Configurations/default.apt

##W TCOS 000049 02:10:36(000) <main_program> Parameter specified but not used in flow: DSProjectMapName

>##E TOSH 000205 02:10:36(001) <main_program> PATH search failure:

>##E TOSH 000000 02:10:36(002) <main_program> Error loading "orchoracle": Could not load "orchoracle": No such file or directory

>##E TOSH 000000 02:10:36(003) <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 02:10:36(004) <main_program> Creation of step finished with status = FAILED

Could you pl guide me on this.

Regards
Koti

welcome aboard. :D

If you Search you will find that the answer to this has already been posted. More than once.

Koti,

Search using "orchoracle". If my meory serves rite this was posted a couple days back and I guess the topic is marked resolved.

You mite want to see all the topics with Oracle stage marked "resolved"

BTW check where is your lib in LD_LIBRARY_PATH?

HTH

Cheers