Trading Manager users who use Oracle ODBC drivers with Oracle 11.2 and higher to connect to Partner Manager

Technote (troubleshooting)


Problem(Abstract)

Beginning in Oracle 11.1.0.7, the Oracle OCI.dll uses the Windows API call SetDllDirectory to ensure that the Oracle client dependencies all come from a single home, which removes the Current Directory from the search path.

Cause

Beginning in Oracle 11.1.0.7, the Oracle OCI.dll uses the Windows API call SetDllDirectory to ensure that the Oracle client dependencies all come from a single home, which removes the Current Directory from the search path.

WebSphere® Transformation Extender (WTX) libraries rely on the Current Directory of the application in order to load all of the library dependencies.

The current directory is removed when using the Oracle driver. In order to preserve the current directory for the WTX libraries to be able to load, the PATH environment variable must be modified to add an extra semicolon in the PATH. This should be added either at the front of the entire PATH statement, or directly after the Oracle home location, which is generally located at the front of the user's PATH setting.

For further reference see Oracle doc id: 1327090.1.

The Oracle service request opened for the WTX specific reported issue is: SR 3-6282115151

Resolving the problem

Oracle has stated that they will not remove the call to setDLLDirectory in their code, so the

permanent solution for users of the Oracle ODBC drivers who have this issue is to modify their PATH environment variable.

Specific instructions for modifying the PATH environment variable:

Windows 7
Select Computer from the Start menu
Choose System Properties from the context menu
Click Advanced system settings > Advanced tab
Click on Environment Variables, under System Variables, find PATH, and click on it.
In the Edit windows, modify PATH by adding a semicolon at the beginning, or directly after the Oracle listing.
For example:
Path=C:\oraclexe\app\oracle\client_11203;C:\WINDOWS\system32;
changes to either:
Path=;C:\oraclexe\app\oracle\client_11203;C:\WINDOWS\system32; (semi-colon at the beginning
Path=C:\oraclexe\app\oracle\client_11203;;C:\WINDOWS\system32; (extra semi-colon after the Oracle listing)
Click OK after the edit to exit out of the dialogs.

Windows XP
Start -> Control Panel -> System -> Advanced
Click on Environment Variables, under System Variables, find PATH, and click on it.
In the Edit windows, modify PATH by adding the location of the class to the value for PATH. If you do not have the item PATH,
you may select to add a new variable and add PATH as the name and the location of the class as the value.
In the Edit windows, modify PATH by adding a semicolon at the beginning, or directly after the Oracle listing.
For example:
Path=C:\oraclexe\app\oracle\client_11203;C:\WINDOWS\system32;
changes to either:
Path=;C:\oraclexe\app\oracle\client_11203;C:\WINDOWS\system32; (semi-colon at the beginning
Path=C:\oraclexe\app\oracle\client_11203;;C:\WINDOWS\system32; (extra semi-colon after the Oracle listing)
Click OK after the edit to exit out of the dialogs.

Product Alias/Synonym

Ascential Datastage TX

Rate this page:

(0 users)Average rating

Document information


More support for:

WebSphere Transformation Extender
Trading Manager

Software version:

8.2, 8.3, 8.4

Operating system(s):

Windows

Software edition:

US

Reference #:

1616950

Modified date:

2012-11-15

Translate my page

Machine Translation

Content navigation