KB320443: "Specified Driver could not be loaded" error while using the MicroStrategy Hive ODBC driver or the MicroStrategy Impala ODBC driver on Linux Red Hat 7

• Strategy

"Specified Driver could not be loaded" error found while using the MicroStrategy Hive ODBC driver or the MicroStrategy Impala ODBC driver on Linux Red Hat.

SYMPTOM
In Strategy Secure Enterprise 10.2 - 10.6, when attempting to use the Strategy Hive ODBC driver or the Strategy Impala ODBC driver on Linux Red Hat 7.x, the following error is received:


Connect failed.
Error type: Odbc error. Odbc operation attempted: SQL DriverConnect. [IM003: on HDBC]
[DataDirect][ODBC lib]Specified Driver could not be loaded

CAUSE
The MSTR Hive ODBC driver and the MSTR Impala ODBC driver are missing a dependency - the libsasl2.so.2 library file, which is missing on Linux Red Hat 7.x operating systems.


[root@env-42099laiouse1 lib]# ldd libhiveodbc_sb64.so 
linux-vdso.so.1 => (0x00007ffe979a6000)
libdl.so.2 => /lib64/libdl.so.2 (0x00007fb4356a1000)
libpthread.so.0 => /lib64/libpthread.so.0 (0x00007fb435485000)
libsasl2.so.2 => not found
librt.so.1 => /lib64/librt.so.1 (0x00007fb43527c000)
libstdc++.so.6 => /lib64/libstdc++.so.6 (0x00007fb434f73000)
libm.so.6 => /lib64/libm.so.6 (0x00007fb434c70000)
libgcc_s.so.1 => /lib64/libgcc_s.so.1 (0x00007fb434a5a000)
libc.so.6 => /lib64/libc.so.6 (0x00007fb434699000)
/lib64/ld-linux-x86-64.so.2 (0x00007fb43852c000)

WORKAROUND
Create a symbolic link for the missing libsasl2.so.2 library file using the /lib64/libsasl2.so.3.0.0 to workaround the issue. Navigate to lib64 and run the following command.


ln -s libsasl2.so.3.0.0 libsasl2.so.2

Now the dependencies are all found for the Strategy Hive ODBC driver or the Strategy Impala ODBC driver


[root@env-42099laiouse1 lib]# ldd libhiveodbc_sb64.so 
linux-vdso.so.1 => (0x00007fffdbe83000)
libdl.so.2 => /lib64/libdl.so.2 (0x00007f1f73a30000)
libpthread.so.0 => /lib64/libpthread.so.0 (0x00007f1f73814000)
libsasl2.so.2 => /lib64/libsasl2.so.2.so.3.0.0 (0x00007f1f735f6000)
librt.so.1 => /lib64/librt.so.1 (0x00007f1f733ee000)
libstdc++.so.6 => /lib64/libstdc++.so.6 (0x00007f1f730e5000)
libm.so.6 => /lib64/libm.so.6 (0x00007f1f72de2000)
libgcc_s.so.1 => /lib64/libgcc_s.so.1 (0x00007f1f72bcc000)
libc.so.6 => /lib64/libc.so.6 (0x00007f1f7280b000)
/lib64/ld-linux-x86-64.so.2 (0x00007f1f768bb000)
libresolv.so.2 => /lib64/libresolv.so.2 (0x00007f1f725f0000)
libcrypt.so.1 => /lib64/libcrypt.so.1 (0x00007f1f723b9000)
libfreebl3.so => /lib64/libfreebl3.so (0x00007f1f721b6000)

It can also be verified that the driver is loaded successfully and the database can be connected to.

ACTION
This issue has been fixed in Strategy 10.7.

Comment

0 comments

Details

Knowledge Article

Published:

April 17, 2017

Last Updated:

May 29, 2017

[root@env-42099laiouse1 lib]# ldd libhiveodbc_sb64.so linux-vdso.so.1 => (0x00007ffe979a6000) libdl.so.2 => /lib64/libdl.so.2 (0x00007fb4356a1000) libpthread.so.0 => /lib64/libpthread.so.0 (0x00007fb435485000) libsasl2.so.2 => not found librt.so.1 => /lib64/librt.so.1 (0x00007fb43527c000) libstdc++.so.6 => /lib64/libstdc++.so.6 (0x00007fb434f73000) libm.so.6 => /lib64/libm.so.6 (0x00007fb434c70000) libgcc_s.so.1 => /lib64/libgcc_s.so.1 (0x00007fb434a5a000) libc.so.6 => /lib64/libc.so.6 (0x00007fb434699000) /lib64/ld-linux-x86-64.so.2 (0x00007fb43852c000)

[root@env-42099laiouse1 lib]# ldd libhiveodbc_sb64.so linux-vdso.so.1 => (0x00007fffdbe83000) libdl.so.2 => /lib64/libdl.so.2 (0x00007f1f73a30000) libpthread.so.0 => /lib64/libpthread.so.0 (0x00007f1f73814000) libsasl2.so.2 => /lib64/libsasl2.so.2.so.3.0.0 (0x00007f1f735f6000) librt.so.1 => /lib64/librt.so.1 (0x00007f1f733ee000) libstdc++.so.6 => /lib64/libstdc++.so.6 (0x00007f1f730e5000) libm.so.6 => /lib64/libm.so.6 (0x00007f1f72de2000) libgcc_s.so.1 => /lib64/libgcc_s.so.1 (0x00007f1f72bcc000) libc.so.6 => /lib64/libc.so.6 (0x00007f1f7280b000) /lib64/ld-linux-x86-64.so.2 (0x00007f1f768bb000) libresolv.so.2 => /lib64/libresolv.so.2 (0x00007f1f725f0000) libcrypt.so.1 => /lib64/libcrypt.so.1 (0x00007f1f723b9000) libfreebl3.so => /lib64/libfreebl3.so (0x00007f1f721b6000)