Unfortunately, there is no easy answer for cases of an initial connection timeout. My presumption would be that something is tying up the connection attempt unrelated to the target database, i.e.:
- Firewall
- Proxy/Reverse Proxy Server
- Load balancer
That said, some reasons why HANA may not respond in time to a new connection request (resulting in such timeouts) include:
- Low available compute resources (near 100% CPU utilization)
- System tied up in memory resource management (OOM, resource container shrinks, etc.)
- Failover to a replication site
Considering the context of this post (attempting to register a remote HANA database for smart data access) my feeling would be that this is likely related to network infrastructure.
If you would like to take the SAP software out of the equation to validate that there is an external problem, I would suggest testing with another ODBC client (e.g. isql) using the same HANA ODBC driver. This is a nice sanity check to ensure that all ODBC clients are similarly affected.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.