Symptom
The connection type is Amazon Simple Storage Service. Validating connection is valid when "Use Assume Role" is checked as false, but when it is checked as true, the following error occurs:
---------------------------------------------------------------------
Connection "XXX" couldn’t be established.
- Data flows can’t be used because of errors in the connection.
- Replication flows can’t be used because of errors in the connection.
- Remote tables are not supported.
Data Flows: Cause: Failed to retrieve connection ......::HTTP::AccessKey. Server responded with 500
Error while executing type extension: Error during exchange with Storage Gateway: Invalid response status 400 from storage gateway. Reason: The connection verification failed! Please make sure the connection info is configured properly. Configuration errors are:
Please provide region or region endpoint when using a role.
Replication Flows: Cause: Failed to retrieve connection ......::HTTP::AccessKey. Server responded with 500
Error while executing type extension: Error during exchange with Storage Gateway: Invalid response status 400 from storage gateway. Reason: The connection verification failed! Please make sure the connection info is configured properly. Configuration errors are:
Please provide region or region endpoint when using a role.
Correlation ID: xxx-xxx-xxx-xxx-xxx
Replication Flows: Right-hand side of 'instanceof' is not an object
Environment
SAP Datasphere
Cause
When "Use Assume Role" is selected as 'true', the region must be specified in the Endpoint field under "Connection Details".
Resolution
When "Use assumed roles" is selected as false, Endpoint can use s3.amazonaws.com, but when it is selected as true, the region must be explicitly specified in the Endpoint filed s3.<AWS Region code>.amazonaws.com (e.g. s3.eu-central-1.amazonaws.com).
Refer to AWS document for details.
Keywords
KBA , DS-DI-CON , Connections , CA-DI-CP-SGW , Storage Gateway , Problem