3370178 - HANA Alert: "Long running open cursor" when this hana database is used as remote source for SAP HANA Smart Data Integration

• HANA database used as remote source for SAP HANA Smart Data Integration
• Frequently there is alert : "Long running/idling cursors"
  "Long running open cursor with suspended statement (i.e. currently in idle mode) found. Cursor runtime since last statement execution: *** min, since last action time (Last Cursor Idle Time): *** min, Application: ***, Application Source:*** , Application Version: , Application User: ***, (Logical) Connection Id: ***, Statement Id: ***, Statement Hash: ***
  Identifies long running/idling cursors. The threshold is based on M_INIFILE_CONTENTS.VALUE where KEY = "idle_cursor_lifetime".
  Close the cursor in the application, or kill the connection by executing the SQL statement ALTER SYSTEM DISCONNECT SESSION <LOGICAL_CONNECTION_ID>.For more information, see the table HOST_LONG_IDLE_CURSOR (_SYS_STATISTICS). 
  
  

SAP HANA Smart Data Integration

SDI, SOURCE HANA, cursor, DP agent , KBA , HAN-DP-SDI , SAP HANA smart data integration (SDI) , Problem