SAP Knowledge Base Article - Preview

3530109 - Handling HANA Alert 42: 'Long-Running Cursors' in SAP Application

Symptom

  • A HANA alert is encountered across all service units where the SAP system is operational.
  • The alert pertains to an open cursor with a suspended statement, with the source identified as SAP Application.
  • The alert suggests closing the cursor or terminating the connection as a proposed solution.
  • The alert message: "Long running open cursor with suspended statement (i.e. currently in idle mode) found. Cursor runtime since last statement execution: 735 min, since last action time (Last Cursor Idle Time): 735 min. Application: SAP Application, Application Source: .Application Version: , Application User: ######, (Logical) Connection Id: ######, Statement Id: <Id>, Statement Hash: <HASH>"


Read more...

Environment

SAP HANA Monitoring

Keywords

HANA Alert 42, Long-Running Cursors,  open cursor, suspended statement, Cloud Control Center, KBA 1900261, KBA 2092196 , KBA , HAN-DB-MON , SAP HANA Monitoring , 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.