Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

(1 Rating)
facebook Twitter
Email
Print Bookmark Alert me when this article is updated

Feedback

"[ERROR] : (PXOPL_Open: dlopen error: Cannot load module. The module has an invalid magic number." running a PowerCenter session with a PowerExchange for Teradata PT target
Problem Description

The following error occurs when running a PowerCenter session with a PowerExchange for Teradata PT target (writer) connection:

ERROR : WRITER_1_*_1 TPTWR_293 [ERROR]
Type:(Teradata PT API Error),
Error: (PXOPL_Open: dlopen error:
 0509-022 Cannot load module /usr/tbuild/12.00.00.00/lib64/libstreamop.so.
 0509-150   Dependent module /lib/libcliv2.so could not be loaded.
 0509-103   The module has an invalid magic number.
 0509-022 Cannot load module

The following is a similar error that may occur for a PowerExchange for Teradata PT source (reader) connection:

ERROR : READER_1_1_1 TPTRD_293 : [ERROR]
Type:(Teradata PT API Error),
Error: (PXOPL_Open: dlopen error:
  Could not load module /opt/teradata/lib64/libexportop.so.
    Dependent module /usr/lib/libcliv2.so could not be loaded.
    The module has an invalid magic number.
   Could not load module /opt/teradata/lib64/libexportop.so.
Dependent module /opt/teradata/lib64/libexportop.so could not be loaded.)

Cause
This issue occurs when using PowerCenter 64-bit and the libcliv2.so (32-bit) file in the /lib directory is being used instead of the libcliv2.so in the opt/teradata/client/lib64 directory.
Solution

To resolve this please do the following:


The following directories should be the first entries in the Library Path (LD_LIBRARY_PATH, LIBPATH or SHLIB_PATH) variable:

/usr/tbuild/12.00.00.00/lib64
/opt/teradata/client/lib64
/opt/tdicu/lib_64

Example:

On AIX the LIBPATH should like similar to the following after adding these directories:

LIBPATH= /usr/tbuild/12.00.00.00/lib64: /opt/teradata/client/lib64:/opt/tdicu/lib_64:
/home/abc/IS_1106178891_sherlock_8.6.1.EE_64/8.6.1.EE/server/bin: .: /usr/lib:/lib:

After making the change, restart the PowerCenter node and run the session.


Note

The directories mentioned above are defaults but can change in each machine depending on where it the Teradata client components are  installed.
If that is the case then substitute the actual directories where the components are installed.

More Information
Applies To
Product: PowerCenter; PowerExchange
Problem Type: Configuration; Crash/Hang
User Type: Administrator
Project Phase: Optimize
Product Version: PowerCenter 8.6; PowerCenter 8.6.1; PowerExchange for Teradata PT 8.6; PowerExchange for Teradata PT 8.6.1
Database: Teradata
Operating System:
Other Software:

Reference
Attachments
Last Modified Date:10/9/2019 12:40 PMID:108531
People who viewed this also viewed

Feedback

Did this KB document help you?



What can we do to improve this information (2000 or fewer characters)