ODBC Enterprise - PATH search failure odbcread

[sjordery]

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:

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.

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:

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:.

Looking at the rest of the variables, there are a few differences - from Environment variable settings:

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

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

[sjordery]

I've managed to fix this:

/opt/IBM/InformationServer/Server/PXEngine/etc/operator.apt

The following were missing on the new server:

odbcread orchodbc 1
odbcupsert orchodbc 1
odbcwrite orchodbc 1


Hope that might help someone in future.

Stu

[chulett]

I'm sure it will, thanks for posting your resolution.

[brendomac]

I'd just like to say thankyou to sjordery!

This was extremely helpful!

I've just joined the forum too, so I'm happy to be a new member.