SAP Knowledge Base Article - Preview

3772625 - Job fails with "root certificate file does not exist" when connecting to Postgresql with ssl - SAP Data Services 4.x

Symptom

  • Running a sample job fails with an ODBC error:
    • Error: ODBC call for data source failed: [unixODBC] root certificate file "/pathl/root.crt" does not exist.
  • Issue occurs when attempting to connect to a PostgreSQL database using SSL (sslmode=verify-ca)


Read more...

Environment

  • SAP Data Services 4.3 and higher

Product

SAP Data Services 2025 ; SAP Data Services 4.3

Keywords

odbc, sqlconnect, unixodbc, postgresql, ssl, root.crt, root certificate file does not exist, verify-ca, verify-full, client certificate, isql, odbc.ini, pgsslcert, pgsslrootcert, job server restart , 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.