SAP Knowledge Base Article - Preview

2832986 - Jobs failing with "Connection refused. Verify Host Name and Port Number" error- SAP Data Services

Symptom

  • All the jobs are failing with the following error for PostgreSQL database only.

CON-120307: |Session ODBC call <SQLConnect> to connect database <> failed with error: <ODBC call <SQLConnect> for data source <> failed: <[SAP BusinessObjects][ODBC PostgreSQL Wire Protocol driver]Connection refused. Verify Host Name and Port Number. [SAP BusinessObjects][ODBC PostgreSQL Wire Protocol driver]Can't connect to server on 'IP Address'>. Notify Customer Support.>. Use the ODBCDriverSelector (Windows) or DSConnectionManager.sh (UNIX) utility in LINK_DIR/bin to configure the correct version of the driver. If the problem still exists after selecting the correct version of the driver, notify Customer Support.  

  • Datastore is connecting successfully to the database and also ports are open bidirectionally. 
  • Telnet and ping works both ways.
  • Netstat port works and port is listening.
  • Hostname in odbc.ini file is correct.


Read more...

Environment

  • SAP Data Services
  • Linux

Product

SAP Data Services 4.2

Keywords

IPS, BI, DS, BODS, BODI, XI, OS, windows, odbc, DSN, ds_odbc.ini, hostname, connectivity, communication, bad connection, ports closed. , KBA , EIM-DS-SVR , Administration/Server , EIM-DS-CON , Connectivity , 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.