SAP Knowledge Base Article - Preview

3307159 - DB statistics server is not working

Symptom

Statistics server doesn't work, you tried to execute below statements to enable statistics server.

alter system alter configuration ('indexserver.ini','SYSTEM') set ('statisticsserver','active')='true' with reconfigure;
alter system alter configuration ('indexserver.ini','SYSTEM') set ('statisticsserver','active')='true' with reconfigure; 

Although the above commands finished, statistics server still doesn't work, and you can see error like below in indexserver trace.


{-1}[-1/-1] i STATS_CTRL       NameServerControllerThread.cpp(00526) : retry installation of the Embedded Statistics Server
{-1}[-1/-1] i STATS_CTRL       NameServerControllerThread.cpp(00535) : installing... 
{-1}[-1/-1] i STATS_CTRL       NameServerControllerThread.cpp(00536) : delay time: 900
{-1}[-1/-1] i STATS_CTRL       NameServerControllerThread.cpp(00717) : no old StatisticsServer in topology
{-1}[-1/-1] i STATS_CTRL       NameServerControllerThread.cpp(00829) : no old StatisticsServer in topology
{-1}[-1/-1] i STATS_WORKER     Startup_Appendix.cpp(00403) : initial profile: M
{-1}[-1/-1] i STATS_WORKER     ConfigurableRegistry.cpp(00446) : start installation
{-1}[-1/-1] e STATS_WORKER     ConfigurableInstaller.cpp(00214) : exception  1: no.9002001  (StatisticsServerAsSQLScript/global/SQLInterfaceEAPI.cpp:122) TID: 230630
    SQL error 2584: can not make cyclic dependency: Cyclic dep - base db id: 0, base oid : 41992855, base object type : 6, dependent db id: 0, dependent oid : 41992855, dependent object type : 6, dependency type: 1 at Metadata/objects/ObjectDependencyInfo.cpp:151. 


Read more...

Environment

  • SAP HANA Platform Edition 2.0

Keywords

Statistics Server, SQL error 2584 , KBA , HAN-DB-MON , SAP HANA Monitoring , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.