SAP HANA : Function GetDatabaseStatus shows statisticserver as stopped on Tenant data base

Issue:

When you run  "-function GetDatabaseStatus -dbname @ -dbtype hdb" for Teant daba base id shows statisticserver as stopped

Component name: hdbstatisticsserver (HDB embedded Statisticsserver), Status: Stopped (Stopped)

But it is running corrctly

Issue in HANA version 2.00.040.00

Reproducing the Issue

Run ther command "-function GetDatabaseStatus -dbname @ -dbtype hdb"

Cause

The Sap HANA host agent checks the ini file to see if the statisticserver is avtive
on revision 2.00.040.00 the SQL to check this
select * from sys.m_inifile_contents where section = 'statisticsserver'
 
returns 0 rows which means the host agent interperates this as it is not active

Solution:
 
Run this SQL

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