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.