SAP Note 2091256 - HANA Statistics Server - Embedded Statistics Server is deactivated automatically

Component : SAP HANA Database - SAP HANA Database Administration and Monitoring

Solution : https://service.sap.com/sap/support/notes/2091256 (SAP Service marketplace login required)

Summary :
After restarting a distributed instance, the Embedded Statistics Server in SAP HANA may automatically deactivate, as indicated by "nameserver.ini -> statisticsserver -> active" being set to false due to a program error. To resolve, tables in the _SYS_STATISTICS schema must be relocated to the master index server. First, identify tables using "select table_name, location from SYS.M_TABLE_LOCATIONS". Then, alter the system configuration and physically move these tables to the master server. Commands and detailed steps, including configuration adjustments, are specified for ensuring the accurate execution of this procedure.

Key words :
components han-std-adm-dba sap hana database administration, high priority category program error validity software componentfrom rel, customer component han-db sap hana database, sap notes 2006652   sap hana statistics server - switch, 2092033   embedded statistics service migration guide, embedded statistics service fails, / __%pdfstyle%__font-size, __%pdfstyle%__ / } symptom, reconfigure header data released, alter system alter configuration

Related Notes :

2006652SAP HANA Statistics Server - Switch to Embedded Statistics Service fails
2092033Embedded Statistics Service Migration Guide