SAP HANA Troubleshooting

SAP HANA Troubleshooting

Problem 1: No Data in SAP HANA Database monitor (or) "SAP DBTech JDBC: [414]: As per your password policy,current user is forced to change DB password." error message is shown.

Solution: Change SAP HANA DB password or Update Password policy. Refer SAP Note: 2532668

Problem 2: Unable to add SAP HANA Database monitor. Follow below troubleshooting steps,

1. Verify if the correct SQL port (indexserver port) has been provided in Applications Manager. 

2. Verify the JDBC connection to SAP HANA DB via HANA Client Studio/DB Manager.  Also verify the instance name.

3. The SQL port for the tenant database can be found in Hana Studio > administration console for the tenant database > Landscape > port #  under the SQL Port column. For reference, check the screenshot below:

Preview 

4. If JDBC connection is unsuccessful with correct the DB name, refer SAP note 2800117.


                  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 ...
                    • Troubleshooting steps for SAP Server/SAP CCMS Monitor addition

                      SAP Monitor addition gets failed due to the following reasons. User Name / Password is given wrong Check the username and password in SAP Server Logon User account locked - Too many failed attempts : (Need to unlock the user from SAP Server) In SAP ...
                    • Real User Monitor (RUM) - Troubleshooting

                      If the monitor has not polled data for a long time, follow the steps below for troubleshooting: Step 1: Check the RUM Agent configuration Real User Monitor requires the RUM Agent to be installed and mapped to the Applications Manager. Refer the help ...
                    • How to execute SAP Debug script

                      1. Steps to execute troubleshooting script SAPDebug.bat/sh: Open command prompt/terminal with administrator privileges. Navigate to <AppManager_home>\bin\troubleshooting folder. Execute the script file SAPDebug.bat or SAPDebug.sh Usage: SAPDebug.bat  ...