Skip to Content
-1
Feb 05, 2019 at 07:35 PM

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

508 Views

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"