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.