Issue
The following errors appears while refreshing tables from Oracle to Amazon Redshift in an Amazon EC2 Windows server:
F_JG20D5: Attempt to start execute command 'curl' failed, because this file could
not be located in any directory in path '.;C:Windowssystem32;C:Windowssystem32SYSTEM;
C:Windows;C:hvrhvr_configagents;C:hvrhvr_homebin;C:appclienttestuserproduct 12.2.0client_64_12cbin;C:apptestuserproduct11.2.0client_32BIN;C:Program
Files (x86)Common FilesOracleJavajavapath;C:Perl64sitebin;C:Perl64bin;C:Oracle_64
product11.2.0client_64BIN;C:Informatica9.1.0clientsPowerCenterClientclientbin;
C:Informatica9.1.0clientstoolsdatadirect;C:Informatica9.1.0clientsjavajrebin
server;C:Informatica9.1.0clientsDeveloperClientbin;C:Oracle_64product11.2.0 client_64BIN;C:Oracle_64product11.2.0client_64bin;C:apptestuserproduct11.2.0
client_32BINBIN;C:apptestuserproduct11.2.0client_32BINbin;C:Informatica10.0.0
clientstoolsdatadirect;C:Informatica10.0.0clientstoolsodbcdrv;C:Program Files
(x86)ExamDiff;C:Program FilesEmEditor;C:Informatica10.0.0clientsPowerCenterClient
clientbin;C:Program FilesJavajdk1.7.0_80bin;C:Program FilesMicrosoft SQL Server
120DTSBinn;C:Program FilesMicrosoft SQL ServerClient SDKODBC110ToolsBinn; C:Program
Files (x86)Microsoft SQL Server120ToolsBinn;C:Program FilesMicrosoft SQL Server120ToolsBinn;C:Program
Files (x86)Microsoft SQL Server120ToolsBinn ManagementStudio;C:Program Files
(x86)Microsoft SQL Server120DTSBinn;C:Program FilesMicroStrategyMicroStrategy
DesktopDataServices180_7764-bitbinserver'.
F_JG2912: The previous error occurred while getting EC2 instance role from 'http://250.199.199.99/2018-11-05/meta-data//iam/security-credentials/'.
F_JG350D: The previous error occurred while creating a mountpoint for url 's3://miscbucket/hvrhub/ebs_shift/shift'.
F_JT04C2: The previous error occurred on line 124 of script 'C:hvrhvr_configjob
hvrhubebs_shiftebs_shift-refr-ebs-shift'.
Resolution
AWS credential handling, when using an AWS Role, depends on the external tool "curl" when using IAM/EC2 instance roles.
You should
- Make sure "curl.exe" is in your path, or is in one of those paths shown in the message you received. The recommended Windows download for curl can be found at https://curl.haxx.se/windows/
OR
- Not use instance roles, and instead, use the AWS key/secret. Even if you didn't specify a "role=xxxx" in HVR, if you didn't provide any other credentials, it might try to fetch default role of EC2 instance.