SAP Knowledge Base Article - Preview

3654387 - Services card shows "Not support" in SAP HANA Cockpit

Symptom

In SAP HANA Cockpit, when adding its own database (SYSTEMDB) and opening the "Services" tile under the Database Overview, the status displays "Not Support" as shown below. 


Upon opening the tile, it shows "Cannot load data" as shown below. 



  • Attempts to log in to SYSTEMDB using the SYSTEM user, it results in the same symptom. 

  • Assigning privileges as per the Authorizations Needed for Monitoring and Administration guide, it reveals that the following system views do not exist at the database level:
    _SYS_STATISTICS.STATISTICS_SCHEDULE
    _SYS_STATISTICS.HELPER_ALERT_CHECK_INACTIVE_SERVICES_AGE 
  • The cockpit-hdb-svc.log (collected as per KBA 3159911) shows the following error messages:
    ----------------------------------
    9/01/25 2:58:59.598 PM [APP/3-1] ERR   #2.0#2025 09 10 13:58:59.598#+09:00#ERROR#com.sap.hana.cockpit.hdb.odata.core.entities.perf.PerfThresholdManager#
                                           ###1FD550C3248XXXXXXX0B0221C86EAA##cockpit-hdb-svc#com.sap.hana.cockpit.hdb.odata.core.entities.perf.PerfThresholdManager########http-nio-127.0.0.1-40313-exec-2#PLAIN##
                                           getThreshold--->
                                           com.sap.db.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: [259]: invalid table name:  Could not find table/view STATISTICS_ALERT_THRESHOLDS in schema _SYS_STATISTICS: line 48 col 22 (at pos 1730)
                                           
    ...
    9/01/25 3:01:35.921 PM [APP/3-1] ERR   #2.0#2025 09 10 14:01:35.921#+09:00#ERROR#com.sap.hana.cockpit.hdb.api.monitoring.DatabaseStatus#
                                           ###F8AF2C3B3B6EXXXXXX81CF8478B3C9##cockpit-hdb-svc#com.sap.hana.cockpit.hdb.api.monitoring.DatabaseStatus########http-nio-127.0.0.1-40313-exec-1#PLAIN##
                                           FAIL_TO_RETRIEVE_REQUEST: Fail to retrieve request: {}: SAP DBTech JDBC: [259]: invalid table name:  Could not find table/view HELPER_ALERT_CHECK_INACTIVE_SERVICES_AGE in schema _SYS_STATISTICS: line 1 col 1835 (at pos 1834)
    ----------------------------------

 "Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."


Read more...

Environment

SAP HANA Cockpit 2.0 SP16 running on HANA Express

Product

SAP HANA, platform edition all versions

Keywords

HANA Cockpit, HANA Express, Services, Not Supported, invalid table name, Could not find table/view STATISTICS_ALERT_THRESHOLDS in schema _SYS_STATISTICS, HELPER_ALERT_CHECK_INACTIVE_SERVICES_AGE , KBA , HAN-CPT-CPT2-ADM , SAP HANA Cockpit 2 (Administration Core) , 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.