Remote Data gateway Connection To On-Premise Database Fails With "Connection Refused. This Host Is Blocked By Agent Security Policy." Error
(Doc ID 2707128.1)
Last updated on SEPTEMBER 07, 2020
Applies to:Oracle Analytics Cloud - Version 105.6.0 and later
Information in this document applies to any platform.
User trying to create a Dataset from Client Machine using the Remote Data Gateway connection to on-premise database
The IP address of Client Machine has been set in the option "Allowed hosts" in the Data Gateway window.
Cause: java.io.IOException: execute query failed[nQSError: 43113] Message returned from OBIS. [nQSError: 77031] Error occurs while calling remote service DatasourceService. Details: [JDSError : 119] Connection refused. This host is blocked by agent security policy. - Cause: Connection refused. This host is blocked by agent security policy Action: Please contact system administrator for the required access. Action: Please refer to logs for more Details
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document