3465311 - Datasphere remote table connection validation error - Connect to SAP gateway failed

When validating the Datasphere connection, get below error message:

Remote Tables: Unable to connect remote source: Initialization of destination xxx failed: Connect to SAP gateway failed
connection parameters: TYPE=x DESTINATION=xxx ASHOST=xxx SYSNR=xx PCS=x SERIALIZATION_FORMAT=xxx NETWORK=xxx

LOCATION CPIC (TCP/IP) on local host with Unicode
ERROR partner 'xxx' not reached
TIME xxx
RELEASE xxx
COMPONENT NI (network interface)
VERSION, Code: 5921, SQL State: HY000

SAP Datasphere

1. Log into Datasphere.
2. Go to connect part.
3. Select the connection.
4. Click the "validation" button.

The issue is caused by an RFC gateway communication problem between the server where the SAP Data Provisioning Agent is installed and the SAP ABAP source system.

Ensure that the server where the SAP Data Provisioning Agent is installed can reach the SAP ABAP application server.

• KBA 2993942 - RFC Gateway security (Access Control Lists): Troubleshooting - Guided Answers

If issue persist after checking the above, please raise a case/ticket under HAN-DP-SDI-DS component (Choose Datasphere Connection product function and then Connection Validation Issue -> Remote Table -> Data Provisioning Agent).

"Unable to connect remote source" , KBA , HAN-DP-SDI-DS , SAP Datasphere specific SDI issues , DS-DI-CON , Connections , Problem