SAP Knowledge Base Article - Preview

3061891 - SDI Realtime-Replication PostgreSQL fails using SSL connection.

Symptom

  • Replication from PostgreSQL fails using SSL  connection.
  • SQL Console error: Failed to instantiate [com.sap.hana.dp.postgresqllogreaderadapter.spring.AutowiredOperationProcessor]: Constructor threw exception; nested exception is java.lang.RuntimeException: com.sap.hana.dp.postgresqllogreaderadapter.common.la.init.InitializeException: org.postgresql.util.PSQLException: No value specified for parameter 1.
  • Framework.trc error:
    2021-05-28 09:07:49,523 [ERROR] DPFramework | WorkerThread.processRequest  - com.sap.hana.dp.adapter.sdk.AdapterException: Adapter validation failed. [xxxxxxx xxxxxxxx]Failed to establish JDBC connection. Error: Cannot create PoolableConnectionFactory (Invalid sslmode value: required)


Read more...

Environment

  • SAP HANA Smart Data Integration
  • PostgreSQLLogReaderAdapter

Product

SAP HANA smart data integration 2.0

Keywords

SSL PostgreSQLLogReaderAdapter sslmode , 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.