How to kill ELN locked sessions in case you can't do it from ELN (requires database access)

How to kill ELN locked sessions in case you can't do it from ELN (requires database access)

Sometimes an ELN session can get locked, if it cannot be unlocked from ELN we can kill it from the database using the following script.

Login to sqlplus as the ELN schema owner

select
p.username username,
s.primary_key session_key,
s.start_time,
s.end_time
from eln_sessions s, eln_session_locks l, eln_people p
where l.session_key=s.primary_key and s.owner_key=p.primary_key;


After that, you can run the following script to delete the session from the database:


begin

DELETE FROM ELN_session_locks where session_key=&session_key;
UPDATE ELN_sessions
SET end_time = (SYS_EXTRACT_UTC(SYSTIMESTAMP)),
end_time_zone_bias = transaction_time_zone_bias
WHERE primary_key=&session_key;
commit;

end;


that is all