The Hana Studio
shows the following alert "Statistical server has been disabled; data
may be out of date"
The Statistics Server is showing green in the "Services" tab but no statistical data is being collected.
2: Go to "Administration Console" -> "Configuration" -> "Statisticsserver.ini" -> "Statisticsserver_general" -> "active".
3: Set the parameter "active" to "true".
4: Alternatively execute the SQL command : alter system alter configuration('nameserver.ini','SYSTEM') SET ('statisticsserver','active') = 'true' with reconfigure
The Statistics Server is showing green in the "Services" tab but no statistical data is being collected.
Resolution
1: Open Sap Hana Studio --> open SYSTEM DB2: Go to "Administration Console" -> "Configuration" -> "Statisticsserver.ini" -> "Statisticsserver_general" -> "active".
3: Set the parameter "active" to "true".
4: Alternatively execute the SQL command : alter system alter configuration('nameserver.ini','SYSTEM') SET ('statisticsserver','active') = 'true' with reconfigure
Now we there is no alert at overview tab in HANA Studio
Thanks