SAP Knowledge Base Article - Preview

2859566 - Timeout error when attempting to connect to PostgreSQL - Data Services

Symptom

  • Unable to connect to source db via designer.
  • Cannot connect to PostgreSQL cloud database.
  • Error received in Data Services Designer is:
    "Warning cannot establish database connection. ODBC call <SQLDriverConnect> to connect database <db_name> failed with error: ODBC call <SQLDriverConnect> for datasource <datasource_name> failed: <[SAP BusinessObjects][ODBC PostgreSQL wire protocol driver] timeout expired.> Notify customer support"
  • Job errors with timeout.
  • Errors in PostgreSQL log: Connection is lost, Could not send data to client.


Read more...

Environment

  • SAP Data Services
  • PostgreSQL 9.5

Product

SAP Data Services all versions

Keywords

KBA , EIM-DS-EXE , Job Execution , Problem

About this page

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

Search for additional results

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