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






Popular posts from this blog

Shrink you container size up to 95%.

-
BLAFS is a bloat-aware filesystem for container debloating. The design principles of BLAFS are effective, efficient, and easy to use. It detects the files used by the container, and then debloats the container by removing the unused files. The debloated containers are still functional and can run the same workload as the original containers, but with a much smaller size and faster deployment. https://github.com/negativa-ai/BLAFS?tab=readme-ov-file
Read more

alma linux: dnf Module yaml error: Unexpected key in data

-
While applying recent updates to a server running Rocky Linux 8, an error presented itself. Module yaml error: Unexpected key in data: static_context [line 9 col 3] Module yaml error: Unexpected key in data: static_context [line 9 col 3] The solution turned out to be a simple one. Update the libmodulemd first to correct the problem then perform the dnf updates as usual. dnf update libmodulemd For a detailed explanation as to the cause of this problem.
Read more