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 :
2006652 | SAP HANA Statistics Server - Switch to Embedded Statistics Service fails |
2092033 | Embedded Statistics Service Migration Guide |