Page 1 of 1

Parallel job is getting failed

Posted: Sun Jan 23, 2011 6:44 am
by prasad v
Hi

I have installed Datastage 7.5 on Windows 2003 Server and Database is Oracle.

and created sample job that extracts the data from oracle table emp and loads into Sequential file. It was compiled successfullly but it is failing with When i try to view the data in oracle stage, i got the below error.
##I TFCN 000001 12:39:47(000) <main_program>
Ascential DataStage(tm) Enterprise Edition 7.5
Copyright (c) 2004, 1997-2004 Ascential Software Corporation.
All Rights Reserved


##I TOSH 000002 12:39:47(001) <main_program> orchgeneral: loaded
##I TOSH 000002 12:39:47(002) <main_program> orchsort: loaded
##I TOSH 000002 12:39:47(003) <main_program> orchstats: loaded
>##E TOSH 000205 12:39:47(004) <main_program> PATH search failure:
>##E TOSH 000000 12:39:47(005) <main_program> Error loading "orchoracle": Could not load "orchoracle": The specified module could not be found.
>##E TOSH 000000 12:39:47(006) <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 12:39:47(007) <main_program> Creation of step finished with status = FAILED
Can any body advise me

Posted: Sun Jan 23, 2011 7:13 am
by ppgoml