Infosphere Metadata Server Asset Manager Data Connection Test - "Failed to Load Native Library"

Problem(Abstract)

When creating a new Data Connection in a new import area the data connection list is empty. Also, after manually entering server name, and selecting "Test Connection", action fails with error "Failed to load native library: fcl".

Symptom

Data connection server list empty when creating new data connection, and following error returned when type server name and test connection:
IMAM_GUI> [CDIMR3741E] Failed to perform connection test.
com.ibm.mif.ChannelException: [CDIMR0047E] There was an error testing the data connection by using the CAS/OracleConnector__10 connector. Failed to load native library: fcl (A file or directory in the path name does not exist.)
at com.ibm.mif.dataconnection.DataConnectionManager.handleConnectorServiceException(DataConnectionManager.java:1699)
<lines omitted>
Caused by: com.ascential.asb.cas.shared.ConnectorServiceException: Failed to load native library: fcl (A file or directory in the path name does not exist.)
at com.ascential.asb.cas.handler.Worker.createNewConnectionObject(Worker.java:1122)

Cause

ASBNODE agent not restarted correctly after making changes to PATH environment variable.

Environment

UNIX

Diagnosing the problem

1. Confirm client access is successful from the DataStage engine server
   • Import a table definition using the Connector
2. Start a new command window on the DataStage Engine tier
3. Make this user "root" (ie, "sudo su -").
4. Change to directory where dsenv is located cd /opt/IBM/InformationServer/Server/DSEngine
5. Source dsenv
   /opt/IBM/InformationServer/Server/DSEngine . ./dsenv
6. Change to the directory where Connector (DB2, ORACLE, etc) is installed
   opt/IBM/InformationServer/Server/DSComponents/bin
7. Run ldd command on the version of connector (DB2, ORACLE,etc) library that corresponds to the client installed to check for missing libraries;
   • example DB2 library

ldd opt/IBM/InformationServer/Server/DSComponents/bin/libccdb2.so
• example ORACLE library

ldd opt/IBM/InformationServer/Server/DSComponents/bin/libccora11g.so
• There should be no missing libraries.

Retry the data connection test, and check for errors.

Resolving the problem

If missing libraries referenced in the ldd output, from step 7 in Diagnosing the problem, reinstall data source client software.

Otherwise,

1. Start a clean command window (putty or telnet)
2. Sudo to root user
3. Source the dsenv
4. Stop the ASBNODE Agent
5. Start the ASBNODE Agent