SAP Knowledge Base Article - Preview

2141242 - Error "Can't open lib '/opt/microsoft/msodbcsql/lib64/libmsodbcsql-*' : file not found" when using Smart Data Access

Symptom

  • The following error appears when trying to access the Microsoft SQL Server remote data source:
SAP DBTech JDBC: [403]: internal error: Cannot get remote source objects: 
[unixODBC][Driver Manager]Can't open lib '/opt/microsoft/msodbcsql/lib64/libmsodbcsql-11.0.so.2260.0' : file not found
OR
[unixODBC][Driver Manager]Can't open lib '/opt/microsoft/msodbcsql/lib64/libmsodbcsql-13.0.so.1.0' : file not found
  • indexserver trace file:
[302687]{800131}[36/6344248368] 2023-01-06 09:04:23.079830 e FedTrace odbccustom.cpp(00709) : Configuration file:/usr/sap/ABC/HDB00/exe//config/property_mss.ini could not be opened. 
[302687]{800131}[66/-1] 2023-01-06 09:04:23.081239 e FedTrace odbcaccess.cpp(03944) : {R -1}ODBC error: connected: 0 state: 01000 code: 0 [unixODBC][Driver Manager]Can't open lib '/opt/microsoft/msodbcsql/lib64/libmsodbcsql-13.0.so.1.0' : file not found
[302687]{800131}[66/-1] 2023-01-06 09:04:23.081435 e FedTrace odbcaccess.cpp(03944) : {R -1}ODBC error: connected: 0 state: 01000 code: 0 [unixODBC][Driver Manager]Can't open lib '/opt/microsoft/msodbcsql/lib64/libmsodbcsql-13.0.so.1.0' : file not found
[302687]{800131}[36/6344248368] 2023-01-06 09:04:23.081830 e ceExecute cePopQo.cpp(00313) : Caught ptime::PtimeException: internal error: Remote Source [MSSQLSERVER] is not accessible to perform the operation: [unixODBC][Driver Manager]Can't open lib '/opt/microsoft/msodbcsql/lib64/libmsodbcsql-13.0.so.1.0' : file not found
; schema='SAPABAP1'; user='SAPABAP1'
Exception details: exception 1: no.71000403 (federation/api/impl/RemoteSourceFacadeImpl.hpp:90) TID: 302687
Remote Source [MSSQLSERVER] is not accessible to perform the operation: [unixODBC][Driver Manager]Can't open lib '/opt/microsoft/msodbcsql/lib64/libmsodbcsql-13.0.so.1.0' : file not found


Read more...

Environment

  • SAP HANA Platform Edition 1.0
  • SAP HANA Platform Edition 2.0
  • unixODBC Driver
  • Microsoft SQL Server

Product

SAP HANA 1.0, platform edition ; SAP HANA, platform edition 2.0

Keywords

Smart Data Access, SDA, MS SQL Server 2012, libodbcinst.so, libodbcnst.so.1 , KBA , HAN-DB-SDA , SAP HANA Smart Data Access , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.