Registration of package EMLLIB failed at “create afl package”


Unlocking SAP HANA EML Success: Resolving and Compatibility on RHEL 8.6

Dive into the Challenge

In the realm of SAP HANA, every upgrade is a step towards optimization. However, our recent journey from version 59.05 to 59.10 uncovered a peculiar challenge. The Extended Machine Learning (EML) functionality hit a roadblock, throwing an unsettling error in the SAP HANA DB and casting a crimson hue on the DBACOCKPIT due to EML Library registration failed.

HANA Studio –> SQL window –> select * from m_plugin_status;

Load Library failed.
Load Library failed.

Registration of package EMLLIB failed at “create afl package _SYS_AFL.EMLLIB file ‘/plugins/eml/libaflemllib’ in _SYS_AFL.EML” with error 444: “package manager error – load library failed”

As per index server log below is the error –

Error dlopen: /usr/sap/ABC/HDB00/exe/plugins/eml/libaflemllib msg: /usr/sap/ABC/HDB00/exe/plugins/eml/libaflemllib: cannot open shared object file: No such file or directory
AFLPM_SQL AFLPM_SQLDriverObj.cpp(00042) : Registration of package EMLLIB failed at “create afl package _SYS_AFL.EMLLIB file ‘/plugins/eml/libaflemllib’ in _SYS_AFL.EML” with error 444: “package manager error – load library failed”.
AFLPM AFLComponent.cpp(00031) : error while AFL Package Manager initialization: registration of AFLs failed

Tracing the Culprit

The investigation revealed a specific quest for and post HANA DB and plugins upgrade. Yet, the elusive files were nowhere to be found in the directory /usr/lib64 of RHEL 8.6.

SAP Standards Echo the Challenge

SAP’s guidelines for EML registration assert the necessity of and Intriguingly, a SAP standard note for SUSE SP15 (2936298 – SAP HANA External Machine Learning Library 2.0 requires libssl 1.0.x) mirrored our encounter, highlighting the identical issue.

Surprisingly, in HANA 2.0 SPS05, EML registration succeeded without the explicit presence of and However, the dynamics shifted post-upgrade to SPS10, leading to a puzzling failure in the registration process.

Given that OpenSSL is the purveyor of these vital libraries, the plot thickens as both libraries remain conspicuously absent in the RHEL 8.6 repository.

Navigating the Solution –

Confirmed: EML success demands and Now, the pivotal question arises – where to procure these elusive libraries?

There are 2 methods to get this library and install in /usr/lib64 without removing the existing one.

Method 1

tar -xzvf openssl-1.0.2k.tar.gz
cd openssl-1.0.2k
./config -fPIC –prefix=/usr/local/openssl/ enable-shared
make install
cd /usr/local/openssl
cp /usr/local/openssl/lib/ /lib64
cp /usr/local/openssl/lib/ /lib64
cp /usr/local/openssl/lib/ /lib64
cp /usr/local/openssl/lib/ /lib64

Method 2

These libraries are still available in RHEL7, if you have any system which is running with RHEL7, you can get both libraries in/usr/lib64 and copy it from there to RHEL8 –

cp -R /usr/lib64
cp -R /usr/li64

Navigate to /usr/lib64 and run below command via root
chmod 755
chmod 755

ln -sf
ln -sf

Post Applying any above method, restart the HANA DB and now it should register EML plugin successfully.

Please click here for full post.

Related Posts

Leave a Reply

Your email address will not be published. Required fields are marked *

Time limit is exhausted. Please reload CAPTCHA.