IBM Support

DataStage Server job using ODBC Common Connector with Oracle read Fails

Troubleshooting


Problem

DataStage Server job that uses the ODBC common connector to read from an Oracle database fails. The view data on the ODBC common connector read stage works correctly and the ODBC common connector works correctly for a Parallel job when accessing the exact same Oracle database.

Symptom

When running a DataStage Server job using an ODBC common connector stage. The following example Fatal error is reported in the DataStage job log:

Type: Fatal
User Name: dsadm
Message Id: IIS-DSTAGE-GCI-E-0110
Message: ds_loadlibrary: error in dlopen of ccpassive.so - /opt/IBM/InformationServer/Server/DSEngine/lib/ccpassive.so: undefined symbol: _ZN6DSLink21beginLocalTransactionEv

Resolving The Problem

Review the entries in the DataStage job log for the environment variables LIBPATH or LD_LIBRARY_PATH depending on the Operating System that the DataStage Engine is running. Verify that the branded_odbc/lib is set before any oracle or /usr/lib or /lib folders.

If these have already been set correctly. Then you may be running into a different problem and need to raise a Support Ticket for further assistance.

[{"Product":{"code":"SSVSEF","label":"IBM InfoSphere DataStage"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Not Applicable","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"}],"Version":"9.1;8.7;8.5;8.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Product":{"code":"SSZJPZ","label":"IBM InfoSphere Information Server"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 June 2018

UID

swg21690775

Page Feedback