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 NOVEMBER 03, 2023
Applies to:
Oracle Analytics Cloud - Version 105.6.0 and laterInformation in this document applies to any platform.
Symptoms
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.
Error:
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
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
Cause
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
Symptoms |
Cause |
Solution |
References |