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 ADManager Plus?

        New to ADSelfService Plus?

          Resources

              • Related Articles

              • 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 ...
              • 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  ...
              • Real User Monitor (RUM) - Troubleshooting

                If the monitor has not polled data for long time. Follow below steps for troubleshooting Check prerequisites to done : Real User Monitor requires RUM Agent to be installed and mapped to Applications Manager. Refer the help page to know how to setup ...
              • Frequently asked questions - SAP monitor

                1. SAP monitor's Health is always critical/warning state along with "System Error occurred" alert message. What should I do? These alerts are triggered when Applications manager receives Alerts from the SAP server itself. The same can be viewed under ...
              • SAP Alerts displaying incorrect time

                Problem :The time shown for SAP Alerts under Alarms tab in SAP monitor is incorrect. Solution : Enter the time difference (in hours) in <AppManager_Home>\conf\SAP.properties file am.sap.alerttime.offset key. For example, in the above screenshot the ...