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 for Me (Login required).

Search for additional results

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