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 database can be found via -
1. Hana Studio > administration console for the tenant database > Landscape > port # is under "SQL Port" column
2. Execute the below sql command:
SELECT SERVICE_NAME, PORT, SQL_PORT, (PORT + 2) HTTP_PORT FROM SYS.M_SERVICES WHERE (SERVICE_NAME='indexserver' and COORDINATOR_TYPE= 'MASTER')
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 ...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 ...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 the password of a new user should be changed when the user is used ...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 ...