1977276 - How to handle HANA Alert 48: 'Check a long-running uncommitted write transaction'

• You receive HANA Alert 'Uncommitted Write Transaction' (Alert ID 48).
• The corresponding Alert text (as displayed in HANA Studio) is:
  'Uncommitted write transaction running for n minutes found. Transaction ID: <id>. Client PID: <pid>.'
• These alerts are also recorded in the alert trace of the indexserver (indexserver_alert_<host>.trc), for eg:

long running uncommitted write transaction detected: CONNECTION ID = 200647, HOST = <dbhost>:30003, CLIENT HOST = <clienthost>, CLIENT PID = 11567, TRANSACTION_ID = "902", TRANSACTION TOTAL EXECUTED TIME = 6321 sec
The long running uncommitted write transaction possibly incurs performance degradation of HANA database. Please commit/rollback a transaction in application or kill the connection by "ALTER SYSTEM DISCONNECT SESSION '200647' "

SAP HANA Database

Indexserver alert, DBACOCKPIT;  m_connections;  m_service_threads; call stacks; threads; , KBA , HAN-DB-MON , SAP HANA Monitoring , HAN-DB-PERF , SAP HANA Database Performance , SV-PERF , Performance Problems , How To