The following statement has been running for 132300 seconds: Transaction ID: 60, client PID: 19766.

[former_member192558]

Hi

I have 67 alerts in SAP HANA studio and keeps growing and all the alerts are of same type.

The following statement has been running for 132300 seconds: Transaction ID: 60, client PID: 19766.

User action: Investigate the statement. For more information, see the table _SYS_STATISTICS.HOST_LONG_RUNNING_STATEMENTS.

The SQL Statement for the client PID is run by the user name: _SYS_STATISTICS

select "SCHEMA_NAME" || '.' || "TABLE_NAME" || '.' || "PART_ID" "SCHEMA_TABLE_PART", "HOST", "PORT", "SCHEMA_NAME", "TABLE_NAME", "PART_ID", "MEMORY_SIZE_IN_TOTAL", "MEMORY_SIZE_IN_MAIN", "MEMORY_SIZE_IN_DELTA", "MEMORY_SIZE_IN_HISTORY_MAIN", "MEMORY_SIZE_IN_HISTORY_DELTA", "ESTIMATED_MAX_MEMORY_SIZE_IN_TOTAL", "RECORD_COUNT", "RAW_RECORD_COUNT_IN_MAIN", "RAW_RECORD_COUNT_IN_DELTA", "RAW_RECORD_COUNT_IN_HISTORY_MAIN", "RAW_RECORD_COUNT_IN_HISTORY_DELTA", "LAST_COMPRESSED_RECORD_COUNT", "READ_COUNT", "WRITE_COUNT", "MERGE_COUNT", map("CREATE_TIME",null,'9999-12-31 23:59:59.999',"CREATE_TIME") "CREATE_TIME", map("MODIFY_TIME",null,'9999-12-31 23:59:59.999',"MODIFY_TIME") "MODIFY_TIME", map("LAST_MERGE_TIME",null,'9999-12-31 23:59:59.999',"LAST_MERGE_TIME") "LAST_MERGE_TIME", map("LAST_REPLAY_LOG_TIME",null,'9999-12-31 23:59:59.999',"LAST_REPLAY_LOG_TIME") "LAST_REPLAY_LOG_TIME", "LOADED", "IS_DELTA_LOADED","IS_LOG_DELTA",PERSISTENT_MERGE, (select count("COLUMN_NAME") from SYS.TABLE_COLUMNS where "SCHEMA_NAME" = T1."SCHEMA_NAME" and "TABLE_NAME" = T1."TABLE_NAME") "TABLE_COLUMN_COUNT" from SYS."M_CS_TABLES" T1 where "MEMORY_SIZE_IN_TOTAL" > 1000000 order by "MEMORY_SIZE_IN_TOTAL" desc, "PART_ID" desc, "SCHEMA_NAME", "TABLE_NAME"

[former_member192558]

How do i get rid of these alerts ? How do i stop my alerts growing ?

[pfefferf]

And what is your question?

[HakanHaslaman]

Please check https://launchpad.support.sap.com/#/notes/2092196 - How-To: Terminating Sessions in SAP HANA, and following the resolution section to terminate the session.
If a session cannot be canceled by ALTER SYSTEM CANCEL SESSION '<connection_id>' or ALTER SYSTEM DISCONNECT SESSION '<connection_id>', possibly a restart is the only option.