topic Re: Unable to execute HTTP request for AWS S3 Deletion in Talend Studio

Unable to execute HTTP request for AWS S3 Deletion

GarethPenrose — Tue, 14 Nov 2017 18:32:20 GMT

Our company has recently rolled out new machines for all developers. I was previously using a Linux-based machine (openSUSE), and now I am on Windows 10.

Since I moved over I am getting an error when I run a job in Talend this seems to be the main part of it:

"Unable to execute HTTP request: sun.security.validator.ValidatorException: PKIX path building failed"

It is trying to connect to an AWS S3 drive and delete a file on there.

Re: Unable to execute HTTP request for AWS S3 Deletion

Anonymous — Thu, 16 Nov 2017 08:41:37 GMT

Hi
Does the job work on your Linux machine? For debugging, can you please check the 'die on error' option on tS3Delete and upload the full error messages?

Regards
Shong

Re: Unable to execute HTTP request for AWS S3 Deletion

GarethPenrose — Thu, 16 Nov 2017 10:16:22 GMT

Yes, I can also upload the job to TAC and run it from there, it seems to be only on this specific machine.

I guess that would make it an issue our system administrators can fix, I have opened a ticket with them but I thought I would ask here in case anyone had any experience or advice with this issue.

Thanks.

Re: Unable to execute HTTP request for AWS S3 Deletion

Anonymous — Tue, 21 Nov 2017 07:01:17 GMT

This looks like an SSL authentication issue. I think your java keystore doesn't have the certificate required for calling the AWS apis. Maybe try upgrading your java version and try again.

Re: Unable to execute HTTP request for AWS S3 Deletion

GarethPenrose — Wed, 22 Nov 2017 13:23:44 GMT

I believe I have already installed the latest JDK:

I've also found that I can (with no issues) run another job that reads and writes on the redshift database we have on the same account as the S3 drive. It seems to just have difficulty with performing S3-based actions specifically.

Re: Unable to execute HTTP request for AWS S3 Deletion

Anonymous — Wed, 22 Nov 2017 13:57:36 GMT

Well, The S3 component interacts with the AWS S3 Rest API to list, get or upload files. This requires SSL authentication which could be why you are seeing this issue with respect to S3 alone and not with Redshift.

We had a similar issue with Google cloud storage components in Talend and for us the problem was because the java keystore did not have the correct certificate required to make these REST calls to the cloud api.

I guess your issue is similar especially considering it worked in another system.

For what it's worth, you could do a fresh java installation and try again.