SAP Knowledge Base Article - Preview

3027572 - SDI 2.4.2; Cannot get adapter capabilities: Failed to install and start Microsoft SQLServer JDBC (loading but the GET_CAPABILITIES is not working.)

Symptom

  • Customer is attempting to Register the MssqlLogReaderAdapter, using the config tool.
    Seeing 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<<=dchana05.dcrown.nnithosting.com:51504(51504)}
    2021-02-22 10:16:20,831 [TRACE] DPFramework | AdapterManager.isCppAdapter  -  Check for CPP Adapter: MssqlLogReaderAdapter
    2021-02-22 10:16:20,831 [TRACE] DPFramework | AdapterManager.isCppAdapter  -    ASEAdapter
    2021-02-22 10:16:20,831 [TRACE] DPFramework | AdapterManager.isCppAdapter  -  Found = false
    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

  • DP Agent version 2.4.2.0
  • HANA version 2.00.048.00.1591276203 
  • mssql-jdbc-8.4.1.jre8.jar
  • MS SQL 19
  • Windows

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.