How to resolve alert 'statistics server has been disabled'?
Solution 1)
Please follow the steps below:
1) First, you need to check topology consistency with the following SQL-Statement:
- CALL CHECK_CATALOG('CHECK_TOPOLOGY','','');
If the above sql-statement return errors to the user may try the below sql-statement it might be able to fix the topology:
- CALL CHECK_CATALOG('REPAIR_TOPOLOGY','','','');
Solution 2)
You can also re-install the embedded statistics server (ESS) in order to resolve this issue
Background Information:
The "Embedded Statistics Service" (ESS) uses triggers for executing procedures which are collecting statistics of system-states. Those procedures are executed by the indexserver.
The collected data are then stored in tables, views in the _SYS_STATISTICS folder. This implies that the statistic service is a totally separate service and therefore except system statistics, it does not affect any other functionality or components of the system.
This re-install procedure may result in a system downtime or on some occasions might require more than one server restart for recreating the tables again.
NOTE: The statistic data which was collected by the statistic server before re-installation, will be lost.
Please follow the steps below in order to re-install the embedded statistics service (ESS):
1) Disable the embedded statistics service with:
alter system alter configuration ('nameserver.ini','SYSTEM') set ('statisticsserver','active')='false' with reconfigure;
2) Now please connect HANA-Studio to the database.
3) Now expand all folder and sub-folder of the _SYS_STATISTICS schema.
4) Delete all tables, views, ... in the _SYS_STATISTICS schema except the Triggers(which you cannot delete them due to a security mechanism that you could not delete objects where the name starts with "_SYS").
5) Now if you see all folders in the _SYS_STATISTICS schema are empty (except for the "Triggers" folder), then start the installation of the embedded statistics service (ESS) with that will also re-create all formerly deleted objects (step 4):
alter system alter configuration ('nameserver.ini','SYSTEM') set ('statisticsserver','active')='true' with reconfigure;