Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

facebook Twitter
Email
Print Bookmark Alert me when this article is updated

Feedback

"[ERROR] com.amazonaws.SdkClientException: Unable to load AWS credentials from any provider in the chain" when Jobs using Amazon Redshift connector as source fails
Problem Description
Jobs using Amazon Redshift connector as source fails with the following error: 

[ERROR] com.amazonaws.SdkClientException: Unable to load AWS credentials from any provider in the chain.

Error seen in session logs: 

READER_1_1_1> JAVA PLUGIN_1762 [2018-11-26 12:23:45.777] [ERROR] com.amazonaws.SdkClientException: Unable to load AWS credentials from any provider in the chain
READER_1_1_1> CMN_1761 [2018-11-26 12:23:45.777] Timestamp Event: [Mon Nov 26 12:23:45 2018]
READER_1_1_1> JAVA PLUGIN_1762 [2018-11-26 12:23:45.777] [ERROR] at com.amazonaws.auth.AWSCredentialsProviderChain.getCredentials(AWSCredentialsProviderChain.java:131)
READER_1_1_1> CMN_1761 [2018-11-26 12:23:45.777] Timestamp Event: [Mon Nov 26 12:23:45 2018]
READER_1_1_1> JAVA PLUGIN_1762 [2018-11-26 12:23:45.777] [ERROR] at com.informatica.cloud.adapter.redshift.runtime.RedshiftRead.<init>(Unknown Source)
READER_1_1_1> CMN_1761 [2018-11-26 12:23:45.777] Timestamp Event: [Mon Nov 26 12:23:45 2018]
READER_1_1_1> JAVA PLUGIN_1762 [2018-11-26 12:23:45.777] [ERROR] at com.informatica.cloud.adapter.redshift.plugin.RedshiftPlugin.getReader(Unknown Source)
READER_1_1_1> CMN_1761 [2018-11-26 12:23:45.777] Timestamp Event: [Mon Nov 26 12:23:45 2018]
READER_1_1_1> JAVA PLUGIN_1762 [2018-11-26 12:23:45.777] [ERROR] at com.informatica.cloud.api.adapter.reader.runtime.GenericRdrPartitionDriver.init(Unknown Source)
READER_1_1_1> CMN_1761 [2018-11-26 12:23:45.777] Timestamp Event: [Mon Nov 26 12:23:45 2018]
READER_1_1_1> SDKS_38200 [2018-11-26 12:23:45.777] Partition-level [NewSource]: Plug-in #505100 failed in init().
READER_1_1_1> GENERIC_READ_10031 [2018-11-26 12:23:45.777] [WARNING] Call to deinit in 'READER' failed due to : [java.lang.NullPointerException 
at com.informatica.cloud.api.adapter.utils.Utils.findDeinitMethod(Unknown Source) 
at com.informatica.cloud.api.adapter.reader.runtime.GenericRdrPartitionDriver.deinit(Unknown Source)

Cause
This issue is observed if Amazon Redshift connection does not have AWS Access key Id and AWS Secret access key. 

Note that if you are using Amazon Redshift connection then it is mandatory to use these keys to run the task on Informatica Cloud.
Solution
If you do not have access to these keys then you can use ODBC type connection or JDBC_IC type connection to connect to Redshift.
More Information
Applies To
Product(s): Cloud Data Integration
Product Version(s):
Database:
Operating System(s):
Other Software:

Reference
Attachments
Last Modified Date:12/3/2018 9:09 PMID:564267
People who viewed this also viewed

Feedback

Did this KB document help you?



What can we do to improve this information (2000 or fewer characters)