cancel
Showing results for 
Search instead for 
Did you mean: 

indexserver on host hanaxxxx02 port 32003 was restarted at 2000-01-01

davidebruno
Participant
0 Kudos

Hi,

we have a SAP Hana 1.0 rev 85.03

after a restart we saw that in alerts details we have this High indication:

ID 4: 'Alert Restarted services'

indexserver on host hanaxxxx02 port 32003 was restarted at 2000-01-01 00:00:00.0000000.

it's very strange alert..

it's a known bug?

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Davide,

You can check the status of the indexserver in HANA studio. Goto Administration --> Landscape --> Services.

Check the Starttime of the service to determine whether it was a false alert.

Looking at the time stamp you have mentioned, it appears to be a false alert. It is expected to be corrected in SPS10 Rev-102.06 and SPS11 Rev-111

Refer note 2265765 for more details.

If those are false alerts and you would like to disable them, please use the below SQL query.

update _SYS_STATISTICS.STATISTICS_SCHEDULE set STATUS = 'Inactive' where ID = 4;

Use the below command to delete the logs of this alert in your system.

delete from _sys_statistics.statistics_alerts_base where alert id='4';

Award points if it helps

Thanks,

Harsha Naik

Bojan-lv-85
Advisor
Advisor
0 Kudos

Hello Bruno,

this issue is caused by high load or oom situations where a certain statistical table is not being inserted with the restart times properly and the corresponding value in the table-column is NULL.

If the alert collerctors come across those NULL values for restart time they use this "strage" default value.

BR, Bojan

davidebruno
Participant
0 Kudos

Thank you, but if we want to delete this alert?

Bojan-lv-85
Advisor
Advisor
0 Kudos

Hello Bruno,

sorry for the late follow up, the wording for these alerts was adjusted as of SPS10 revision 102.04 and SPS11 revision 111

BR, Bojan