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.