CODEWITHSUNDEEP
amazon-s3talend
Berra2k
Berra2k

Reputation: 328

ERROR: Talend S3 - AWS authentication requires a valid Date or x-amz-date header

I'm using talend open studio to push salesforce data to my redshift database. By pushing data using the following:

1. tSalesforceInput
2. tMap
3. tFileOutputDelimited
4. tRedshiftOutput

I am only getting about 2-5 rows/s which does not work at all for me.

By pushing the delimited file to tS3Put and then pushing data to redshift the transfer would go MUCH faster, about 500 rows/s. The issue I continue to face is that I get the error:

AWS authentication requires a valid Date or x-amz-date header (Service: Amazon S3; Status Code: 403; Error Code: AccessDenied; Request ID: CC9C86CCC65625C0

And I have no idea how to solve. I have tried using tLibraryLoad to load joda time 2.8.2 before running and then running after but it still fails. Any advice greatly appreciated.

Upvotes: 0

Views: 1524

Answers (1)

Paul Friedman
Paul Friedman

Reputation: 1

I also had this problem using Talend 6.1 The issue is an incompatibility of Java8, the AWS SDK and the joda-time 2.3 library that Talend bundles.

The solution I found was adapted from: TalendForge

Download joda-time 2.8.2 jar from Joda Time

Add a tLibraryLoad and point it to the new joda-time jar file you downloaded.

Go to your project's Run tab/Advanced Settings and add an additional JVM argument of:

-Xbootclasspath/p:$ROOT_PATH/../lib/joda-time-2.8.2.jar

Upvotes: 0

Related Questions