IBM Support

Redshift Connector, Amazon S3 Connector, and Snowflake Connector fail with certificate validation errors

Troubleshooting


Problem

When using Redshift Connector, Amazon S3 Connector, or Snowflake Connector, the connection fails with certificate validation errors indicating that the Amazon Root Certificate is missing from the JDK certificate store.

 

Symptom

 

For Redshift Connector:

The connector fails with the following error message:

CDICO2056E: Connection failed: shadow.wdp.connect.library.file.amazons3.software.amazon.awssdk.core.exception.SdkClientException: Unable to execute HTTP request: com.ibm.jsse2.util.j: PKIX path building failed: com.ibm.security.cert.IBMCertPathBuilderException: unable to find valid certification path to requested target (SDK Attempt Count: 4) com.ibm.connect.api.SCAPIException:

 

For Amazon S3 Connector:

The connector fails with the following error message:

Exception occurred: software.amazon.awssdk.core.exception.SdkClientException: Unable to execute HTTP request: com.ibm.jsse2.util.j: PKIX path building failed: com.ibm.security.cert.IBMCertPathBuilderException: unable to find valid certification path to requested target

 

For Snowflake Connector:

The connector fails with the following error message:

Snowflake_Connector_5,0: Fatal Error: The PUT command failed to load data into the staging area with error - Error during file transfer: listObjects.

 

Document Location

Worldwide

[{"Type":"MASTER","Line of Business":{"code":"LOB76","label":"Data Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSZJPZ","label":"IBM InfoSphere Information Server"},"ARM Category":[{"code":"a8m50000000L12jAAC","label":"DataStage-\u003EJob Stages-\u003EAmazon S3 Connector"},{"code":"a8m3p000000hAytAAE","label":"DataStage-\u003EJob Stages-\u003ERedshift Connector"},{"code":"a8m0z000000ble2AAA","label":"DataStage-\u003EJob Stages-\u003ESnowflake Connector"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.7.1"}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
25 February 2026

UID

ibm17261538

Page Feedback