Pentaho

 View Only
  • 1.  Upload a CSV file to AWS S3 using Pentaho

    Posted 04-12-2022 14:01

    Hi,

    I am trying to upload a CSV file to AWS S3 using Pentaho. But I am not able to do that. I am facing the below error.

    Caused by: com.amazonaws.SdkClientException: Unable to execute HTTP request: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target.

    I tried installing the certificates too in the keystore but nothing worked.

    Any help will be appreciated.



    ------------------------------
    Saket Kumar
    Data Service Manager
    Tibersoft
    ------------------------------



  • 2.  RE: Upload a CSV file to AWS S3 using Pentaho

    Posted 04-15-2022 03:51

    Facing same issue but no response from anyone and couldn't find this topic troubleshooting in google.


    My AARP Medicare
    ------------------------------
    Alphonse Smith
    Chief Information Officer
    Edwards
    ------------------------------



  • 3.  RE: Upload a CSV file to AWS S3 using Pentaho

    Posted 04-19-2022 11:13
    I think that if you mention the version of Pentaho you are using it would be useful so that other members of the community can help you.
    Best regards

    ------------------------------
    Carl Messner
    Data Analyst
    MCSF
    ------------------------------



  • 4.  RE: Upload a CSV file to AWS S3 using Pentaho

    Posted 04-19-2022 20:33
    Hi Saket

    Try adding the intermediate certificate with the root certificate before importing it to the keystore.  Google 'certificate chaining' for how-tos.

    ------------------------------
    Andrew Cave
    Systems Engineer
    BizCubed Pty Ltd
    Australia
    ------------------------------