[MicroStrategy][Oracle][ODBC driver for Oracle][Oracle] Error while trying to retrieve text for error ORA-01019" error message occurs

 Issue:

Users encounter the "[ODBC driver for Oracle][Oracle] Error while trying to retrieve text for error ORA-01019" message when opening the Warehouse Catalog in MicroStrategy Developer 9.4.1 on a new machine. The error indicates a database connection failure.

Root Cause: The error arises from the presence of multiple 32-bit client libraries (SQAORA32.dll) on the same machine. The application is unable to determine which library to use when communicating with the driver, leading to the ORA-01019 error.

Fix: Remove the additional 32-bit client library from the client machine. In the case of a 3-tier connection, ensure the extra library is also removed from the Intelligence Server machine. This resolves the conflict and allows for proper communication between MicroStrategy and the Oracle driver.

Note: The issue is independent of MicroStrategy and relates to the configuration of third-party client libraries.

Published: Mar 31, 2017 Last Updated: Apr 12, 2019 Related Versions: 9.5.1, 9.4.1

LINK: https://community.microstrategy.com/s/article/KB249428-quot-ODBC-driver-for-Oracle-Oracle-Error-while-trying?language=en_US