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
Product
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.
SAP Knowledge Base Article - Preview