SAP HANA Troubleshooting
This article provides troubleshooting steps for common issues encountered while adding or monitoring SAP HANA databases in Applications Manager.
Problem 1: No Data Displayed in the SAP HANA Database Monitor
Symptom: No data is displayed in the SAP HANA Database monitor, or the following error is shown:
SAP DBTech JDBC: [414]: As per your password policy, current user is forced to change DB password.
Solution: Change the SAP HANA database user's password or update the password policy as required.
Problem 2: Unable to Add a SAP HANA Database Monitor
Troubleshooting steps:
- Verify that the correct SQL port (Index Server port) has been configured in Applications Manager.
- Verify the JDBC connection to the SAP HANA database using SAP HANA Studio or Database Manager. Also, ensure that the correct database instance name has been specified.
- The SQL port for a tenant database can be found in SAP HANA Studio under Administration Console → Tenant Database → Landscape. Refer to the SQL Port column for the appropriate port number.
- If the JDBC connection fails even when the correct database name is specified, refer to SAP Note 2800117.
Problem 3: Semaphore Timeout Error While Connecting to SAP HANA
Symptom: The following error is displayed while connecting to the SAP HANA database.
com.sap.db.jdbc.exceptions.JDBCDriverException:
SAP DBTech JDBC: Cannot connect to jdbc:sap://Host:30915/
[Data received failed. java.io.IOException:
The semaphore timeout period has expired.]
Solution:
For On-Premises SAP HANA Instances
- Verify that the SAP HANA host IP address is reachable from the Applications Manager server.
- Check network connectivity between the Applications Manager server and the SAP HANA server.
- Ensure that firewall rules allow communication through the configured SAP HANA SQL port.
For SAP HANA Cloud Instances
- Verify that the Applications Manager server's IP address has been added to the SAP HANA Cloud allowlist (whitelist).
- Ensure that network access is permitted from the Applications Manager server.
For more information, refer to the SAP HANA documentation on allowing connections to a SAP HANA instance.
New to ADSelfService Plus?
Related Articles
SAP Server - No Data for SAP OS Tab
Problem: SAP Server, OS Data is not collected. Troubleshooting Steps: Verify if SAP OS Collector (SAPOSCOL) is running. Connect to SAP Server using SAP Logon. Use TCODE RZ20 Expand 'SAP CCMS Monitor Templates' monitor set, select 'Operating System' ...No Data in SAP Server monitor/ Unable to add SAP monitor
Problem: In Appmanager_home/logs/nms/stdout.txt , the error message "SAPDataCollector : Host information not found for server" is found. Solution: Add entry for IP Address and SAP Instance name in etc/hosts file of Applications Manager server and ...SYSTEMDB not connected - SAP HANA
Error : general error : SYSTEMDB not connected Cause : The DEFAULT entry in the hdbuserstore on the sap application server is incorrectly pointing to the sql port of the SYSTEMDB instead of tenant database. Solution : The sql port for the tenant ...How to change SAP HANA password ?
Error : "SAP DBTech JDBC: [414]: As per your password policy, current user is forced to change DB password." error message is shown. Cause : The standard password policy specifies that a new user must change their password upon logging into HANA for ...SAP HANA Driver not Found Error
Error : SAP HANA Driver not Found. Kindly check whether ngdbc.jar is placed under <APM_HOME>/working/classes and Applications Manager is restarted. Fix : Download ngdbc.jar from: https://tools.hana.ondemand.com/#cloud Place the JAR under: ...