I found SAP note 1977293 - How to handle HANA Alert 47: 'Check a long-running serializable transactions'
Symptom
In SAP HANA Studio or SAP HANA Cockpit you see the Alert 47 Long-running serializable transactions
Environment
SAP HANA Database
Cause
Alert is visible when there is a long-running serializable transaction
Resolution
Close the serializable transaction in the application or kill the connection on the SAP HANA Database side.
You can close the connection on HANA by executing the SQL statement ALTER SYSTEM DISCONNECT SESSION <LOGICAL_CONNECTION_ID>.
To see the long running serializable transaction and associated LOGICAL_CONNECTION_ID execute the SQL statement select * from "_SYS_STATISTICS"."HOST_LONG_SERIALIZABLE_TRANSACTION";
---------------------
I got the result when I run this statement
select * from "_SYS_STATISTICS"."HOST_LONG_SERIALIZABLE_TRANSACTION";
I have attached the print screen of the result, as you can see the 'LOGICAL_CONNECTION_ID' are 312778 and 312766.
So, i want to close the connection, as I think it affect the server performance.
When I tried to run the following statement to close the connection, it was not able and error.
ALTER SYSTEM DISCONNECT SESSION '312766';
ALTER SYSTEM DISCONNECT SESSION '312778';
it give following error:
null
Could not execute 'ALTER SYSTEM DISCONNECT SESSION '312766''
null
How can I close the connection of these 2 'LOGICAL_CONNECTION_ID' 312778 and 312766?