IIS 8.0.1 Oracle-Error executing View Data command:

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
cundyp
Premium Member
Premium Member
Posts: 53
Joined: Tue Feb 06, 2007 10:57 am

IIS 8.0.1 Oracle-Error executing View Data command:

Post by cundyp »

We have just installed IIS 8.0.1 (update):

We are getting the following error using the Oracle Enterprise Stage:

IIS 8.0.1 Error executing View Data command:
##e iis-dsee-tosh-00205 08:10:00(008) <MAIN_PROGRAM> path SEARCH FAILURE:

PATH search failure:
>##E IIS-DSEE-TFOG-00006 08:07:53(014) <main_program> Error loading "orchoracle":
Could not load "orchoracle":
0509-022 Cannot load module .
> 0509-026 System error: A file or directory in the path name does not exist..
>##E IIS-DSEE-TOSH-00384 08:07:53(015) <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 IIS-DSEE-TCOS-00029 08:07:53(016) <main_program> Creation of a step finished
with status = FAILED.

Where should we start looking?
Pete Cundy
Leawood, Kansas
cundyp
Premium Member
Premium Member
Posts: 53
Joined: Tue Feb 06, 2007 10:57 am

Post by cundyp »

The release notes doc has the following excerpt. The release notes are in */is-ia-suite/InfoServerReleaseNotes.html

During installation the Oracle operator library is incorrectly referenced with a symbolic link containing a .so instead of a .o extension. This issue can be resolved by running the install.liborchoracle command in the <IIS_INSTALL_DIR>/Server/DSComponents/install directory.
Source the dsenv script in $DSHOME and then run the following commands:
cd <IIS_INSTALL_DIR>/Server/DSComponents/install
chmod 755 install.liborchoracle
./install.liborchoracle

ISSUE RESOLVED!!
Pete Cundy
Leawood, Kansas
Post Reply