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 #
2. Port value is present is under "SQL Port" column.
3. 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
3. 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