SAP Knowledge Base Article - Preview

3027572 - Error: "Cannot get adapter capabilities: Failed to install and start Microsoft SQLServer JDBC (loading but the GET_CAPABILITIES is not working.)" while registering MssqlLogReaderAdapter

Symptom

  • Attempting to register the MssqlLogReaderAdapter via dpagent config tool results in this error:
    • SAP DBTech JDBC: [403]: internal error:Cannot get adapter capabilities: Failed to install and start Microsoft SQLServer JDBC driver bundle.
  • Framework.trc with full Debug on shows:
    • 2021-02-22 10:16:20,831 [DEBUG] DPFramework | SocketConnector.read  - <<103:99:GET_CAPABILITIES:SDA:35260:dpagent_XXXXXXX:MssqlLogReaderAdapter:::0:0:GET_CAPABILITIES:RoutingHeaders :{RequestReceived<<=*:51504(51504)}...
    • 2021-02-22 10:16:20,831 [DEBUG] BndUtils | BndUtils.createBundle  - Creating bundle for [wrap:file:lib/mssql-jdbc-8.4.1.jre8.jar]
    • 2021-02-22 10:16:20,831 [DEBUG] BndUtils | BndUtils.createBundle  - Overwrite mode: KEEP
    • 2021-02-22 10:16:20,831 [TRACE] BndUtils | BndUtils.createBundle  - Using instructions {}
    • 2021-02-22 10:16:21,174 [ERROR] MssqlLogReaderAdapterFactory | MssqlLogReaderAdapterFactory.assertMssqlDriver  - Failed to install and start Microsoft SQLServer JDBC driver bundle.
      org.osgi.framework.BundleException: Could not resolve module: com.microsoft.sqlserver.mssql-jdbc [136]


Read more...

Environment

  • SAP HANA Smart Data Integration
    • DP Agent version 2.4.2.0
    • mssql-jdbc-8.4.1.jre8.jar

Product

SAP HANA smart data integration 2.0 ; SAP HANA, platform edition 2.0

Keywords

Microsoft SQLServer, JDBC, DPAgent , KBA , HAN-DP-SDI , SAP HANA smart data integration (SDI) , 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.