on 11-29-2015 2:48 AM
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?
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.