Symptom
For a SAP Datasphere tenant connectivity is enabled via DP Agents.
The following issues are observed:
- DP Agent has DISCONNECTED status in SAP Datasphere
- SAP Datasphere is not recognizing the DP Agent
- DP Agent cannot be registered
- In DP Agent's trace file "framework.trc", occurs error: Unable to make JDBC connection to server
- Unable to connect remote source: exception 151044: Agent "DPAgent_ID" is not available. , Code: 5921, SQL State: HY000
Environment
SAP Datasphere
Resolution
Follow these steps:
- Download and upgrade into latest DP Agent version (see KBA 2563103 - How to check the Data Provisioning Agent version).
- Latest version can be identified in the following location on the SAP for Me Software Center → Support Packages & Patches tab → By Alphabetical Index (A-Z) → H → SAP HANA SDI > SAP HANA SDI <version_number> → Comprised Software Component Versions → HANA DP AGENT 2.0
- Verify that the external/public IP (IP for untrusted networks) of the server where the DP Agent is installed is allowlisted (see SAP Note 2894588 - IP Allowlisting in SAP Datasphere)
- Allowlist is NOT relevant for private IP ranges (10.0.0.0 ~ 10.255.255.255, 172.16.0.0 ~ 172.31.255.255, 192.168.0.0 ~ 192.168.255.255)
Trusted networks use private IP addresses to communicate within trusted environment.
Communication between the trusted networks over an untrusted network, use a single public IP address. Network Address Translation (NAT) manages this communication.
Therefore if the DPAgent is installed in a private network, make sure to add the public IP address into SAP Datasphere's Allowlist for untrusted networks. -
To determine the external IP proceed:
-
In Linux, run from the terminal: curl ifconfig.me OR dig +short myip.opendns.com @resolver1.opendns.com
-
In Windows, run from CMD: nslookup myip.opendns.com. resolver1.opendns.com
- Verify if there is a firewall that can block outbound requests
- Perform command telnet in the agent side to SAP Datasphere tenant on HANA port 443
- When using proxy, the proxy's address needs to be included in Datasphere's IP Allowlist as well
- Check all points of the Troubleshooting Guide for the DP Agent step by step: Troubleshooting Guide
In case issue persists, SAP Support requests following info in the case ticket:
- DP Agent name in SAP Datasphere
- Attach into ticket a Full System dump as per KBA 2807852 - How to create DP agent FullSystemDump - Smart Data Integration
Enable "Review Logs" to be consumed on demand from SAP Datasphere's UI.
Follow SAP Help Portal Documentation Enable Access to Data Provisioning Agent Logs in order to enable this self-service,
or in Datasphere's community blog post Access Data Provisioning Agent logs directly from DataSphere.
See Also
-
KBA 3299170 - Error "authentication failed" causes DataProvisioning Agent unavailable for SAP Datasphere
-
SAP Help Portal Documentation: Troubleshooting the Data Provisioning Agent (SAP HANA Smart Data Integration)
For DP Agent traces files:
Keywords
DPAgent, DWC, Data Warehouse, Cloud, There was an error when adding an adapter to the agent, Data Provisioning Agent is disconnected , KBA , DS-DI-CON , Connections , HAN-DP-SDI , SAP HANA smart data integration (SDI) , Problem