KnowledgeBase Content Details

December 31, 2020

Question:

User has a problematic section, whenever that section is selected the ELN client hangs requiring a restart of the client itself.
The experiment is no longer needed and that section can be deleted, but selecting experiment /section is causing the ELN client to hang.
How can I do it?

Answer:

Following script uses procedure that marks collection as not active(not visible); replace _your_collection_key_ with collection key of target experiment.

DECLARE
TZB NUMBER;
sKey NUMBER(10, 0);
versionKey ENA_VERSIONS.PRIMARY_KEY%TYPE;
ssk ELN_COLLECTIONS.SECTION_SET_KEY%TYPE := _your_collection_key_;
BEGIN

SELECT -1*TO_NUMBER(SUBSTR(TZ_OFFSET(SESSIONTIMEZONE),1,1)||'1')*(60*TO_NUMBER(SUBSTR(TZ_OFFSET(SESSIONTIMEZONE),2,2))+TO_NUMBER(SUBSTR(TZ_OFFSET(SESSIONTIMEZONE),5,2))) INTO tzb FROM DUAL;

START_SESSION(sKey, 1, TZB);
CREATE_VERSION(versionKey, ssk, 'Program manually remove the collection, because customer has some issues with one section of collection', 0);

ENCOLLECTION.REMOVE_COLLECTION(ssk);
for cur in (select primary_key from eln_references where target_key = ssk)
loop
ENCOLLECTION.REMOVE_reference(cur.primary_key);
end loop;
update eln_sessions
set end_time = sys_extract_utc(systimestamp), END_TIME_ZONE_BIAS = TZB
where primary_key = sKey;
END_SESSION(sKey);

COMMIT;
END;
/

Back to KnowledgeBase