HANA Alert : internal statistics server problem

[Former Member]

Hello,

We encountered with an ALERT on HANA as following:

"Internal statistics server problem"

HANA version is SP8 and SAP Note: 2007437 is already applied on the STATISTICS PLAN CACHE Table.

Table "_SYS_STATISTICS.HOST_SQL_PLAN_CACHE"

Column Name,Type,Length,Nullable,Keypos

"ACCESSED_OBJECTS","VARCHAR","5000","YES","n/a"

But when we query the STATISTICS_LAST_CHECKS table we got the following output with a "?" on the ALERT_LAST_CHECK_RATING column.

select ALERT_ID,ALERT_DESCRIPTION,ALERT_NAME,ALERT_LAST_CHECK_RATING from _sys_statistics.STATISTICS_LAST_CHECKS

ALERT_ID,ALERT_DESCRIPTION,ALERT_NAME,ALERT_LAST_CHECK_RATING

0,"Identifies internal statistics server problem.","Internal statistics server problem",?

Have someone encounter similar issue earlier?

It would be great if you can share some inputs? I did a search and found nothing other than the SAP Note.

Thanks

Sajeev

[former_member182967 · Accepted solution]

Hello Sajeev,

Check if note 1931334 - NULL value in index of array OBJECT_LOCKS_ACQUIRED_TIME helps?

The value of ALERT_LAST_CHECK_RATING is also ? in my environment.

Regards,

Ning Tong

[Former Member]

Can you run the appropriate Mini Check command from SAP Notes 1999993 and 1969700 and provide the output of the STATISTICS SERVER section (starting with check ID 700)?

[AtulKumarJain]

Hi Sanjeev,

Please check below sap note

2133799 - Analyzing problems with delivery of e-mails for Alerts raised by the SAP HANA Embedded

Statisticsserver checks

BR

AKJ