ODBC Enterprise - PATH search failure odbcread
Posted: Fri Feb 05, 2016 3:25 am
Hello all,
It's been a long time since I last posted - we've had a mature, stable installation for some time.
We are in the midst of a datacenter move and as part of this have set up a new Linux SUSE v10 server to replicate our current DataStage environment.
All has been fine up until yesterday, but when testing some of the migrated jobs I'm getting some strange errors. In short, ODBC Connector stages are working fine, but ODBC Enterprise stages fail with the following:
I have copied the .odbc.ini, dsenv and uvodbc.config files over from the old server (where the ODBC Enterprise stage works fine).
From the Director logs on old and new server, I can see the PATH variable is set the same:
Looking at the rest of the variables, there are a few differences - from Environment variable settings:
I've spent hours searching both this forum and the www in general, but to no avail. If anyone is able to give me some pointers of where to start, that would be very much appreciated.
Best,
Stu
It's been a long time since I last posted - we've had a mature, stable installation for some time.
We are in the midst of a datacenter move and as part of this have set up a new Linux SUSE v10 server to replicate our current DataStage environment.
All has been fine up until yesterday, but when testing some of the migrated jobs I'm getting some strange errors. In short, ODBC Connector stages are working fine, but ODBC Enterprise stages fail with the following:
Code: Select all
>##E IIS-DSEE-TOSH-00205 00:31:44(006) <main_program> PATH search failure:
>##E IIS-DSEE-TOSH-00384 00:31:44(007) <main_program> Could not locate operator definition, wrapper, or Unix command for "odbcread"; please check that all needed libraries are preloaded, and check the PATH for the wrappers
##W IIS-DSEE-TFOG-00004 00:31:44(008) <main_program> Operator odbcread does not exist in the registry.
>##E IIS-DSEE-TCOS-00029 00:31:44(009) <main_program> Creation of a step finished with status = FAILED.
From the Director logs on old and new server, I can see the PATH variable is set the same:
Code: Select all
Old:
PATH=/data/IBM/Datastage/Projects/DATAScopeINGEST/wrapped:
/data/IBM/Datastage/Projects/DATAScopeINGEST/buildop:
/data/IBM/Datastage/Projects/DATAScopeINGEST/RT_BP626.O:
/opt/IBM/InformationServer/Server/DSComponents/lib:
/opt/IBM/InformationServer/Server/DSComponents/bin:
/opt/IBM/InformationServer/Server/DSParallel:
/opt/IBM/InformationServer/Server/PXEngine/user_osh_wrappers:
/opt/IBM/InformationServer/Server/PXEngine/osh_wrappers:
/opt/IBM/InformationServer/Server/PXEngine/bin:
/usr/kerberos/bin:
/usr/local/bin:
/bin:
/usr/bin:
/usr/X11R6/bin:.
New:
PATH=/data/IBM/Datastage/Projects/DATAScopeINGEST/wrapped:
/data/IBM/Datastage/Projects/DATAScopeINGEST/buildop:
/data/IBM/Datastage/Projects/DATAScopeINGEST/RT_BP756.O:
/opt/IBM/InformationServer/Server/DSComponents/lib:
/opt/IBM/InformationServer/Server/DSComponents/bin:
/opt/IBM/InformationServer/Server/DSParallel:
/opt/IBM/InformationServer/Server/PXEngine/user_osh_wrappers:
/opt/IBM/InformationServer/Server/PXEngine/osh_wrappers:
/opt/IBM/InformationServer/Server/PXEngine/bin:
/usr/kerberos/bin:
/usr/local/bin:
/bin:
/usr/bin:
/usr/X11R6/bin:.
Code: Select all
First line --->
Old - _=/opt/IBM/InformationServer/Server/DSEngine/bin/uvsh
New - _=/usr/bin/nohup
Fairly sure these are not relevant --->
Old - OLDPWD=/home/dsadm
New - OLDPWD=/
Old - PWD=/data/IBM/Datastage/Projects/DATAScopeINGEST
New - PWD=/opt/IBM/InformationServer/Server/DSEngine
This concerned me --->
Old - SHELL=/bin/sh
New - SHELL=/bin/bash
Best,
Stu