Abir Messaikeh added a comment - 13/Aug/25 2:01 PM Dear Abir Please note that there is no historical table available to check the frequency of long-running sessions. However, such occurrences have been no frequent and have only happened 3 or 4 times this year. Best, From: Abir Messaikeh <Abir.Messaikeh@nuiva.com> Sent: Tuesday, May 13, 2025 11:57 AM To: Natnael Asfaw <Natnael.Asfaw@mobinets.com>; Khaled Khalil <Khaled.Khalil@nuiva.com> Cc: Malek Ibrahim <Malek.Ibrahim@mobinets.com>; support <support@mobinets.com>; integration <integration@mobinets.com>; Hassan Abdine <Hassan.Abdine@nuiva.com> Subject: RE: FN functions not working due to DB lock Dear Natnael Could u please check in last 1 year , how frequent this long running session happened impacting FN activity and was it for same query if we have such information As Integration feedback was that nothing abnormal was observed on DB , I will raise it to L3 to see if this is something that needs to be adjusted but such information about occurrence frequency is useful Thx Abir From: Natnael Asfaw <Natnael.Asfaw@mobinets.com> Sent: Thursday, May 8, 2025 4:56 PM To: Abir Messaikeh <Abir.Messaikeh@nuiva.com>; support <support@mobinets.com>; integration <integration@mobinets.com> Cc: Malek Ibrahim <Malek.Ibrahim@mobinets.com> Subject: RE: FN functions not working due to DB lock Dear Abir Please find attached the long-running SQL sessions that were active during the NEP issue and may have caused to the database deadlock Best, From: Abir Messaikeh <abir.messaikeh@nuiva.com> Sent: Thursday, May 8, 2025 3:09 PM To: Yasssin Geehad <Yasssin.Geehad@omantel.om>; support <support@mobinets.com>; integration <integration@mobinets.com> Cc: NGOSS_Support <NGOSS_Support@omantel.om>; Hamed Hamid Saif Al Sulaimani <hamed.sulaimani@omantel.om> Subject: RE: FN functions not working due to DB lock ++ Integration to check promptly Regards From: Yasssin Geehad <Yasssin.Geehad@omantel.om> Sent: Thursday, May 8, 2025 3:05 PM To: Abir Messaikeh <abir.messaikeh@nuiva.com>; support <support@mobinets.com> Cc: NGOSS_Support <NGOSS_Support@omantel.om>; Hamed Hamid Saif Al Sulaimani <hamed.sulaimani@omantel.om> Subject: FN functions not working due to DB lock Dear @Abir Messaikeh , Please support as FN main functionalities not working. 2025-05-08 16:02:43.808 [https-jsse-nio-8450-exec-24] INFO c.m.n.c.workflow.soap.SoapDelegate - >>> End Executing Service With Exception: "I/O error: Connection reset; nested exception is java.net.SocketException: Connection reset" SoapDelegate.FnService.updateOltPort 2025-05-08 16:02:43.809 [https-jsse-nio-8450-exec-24] ERROR c.m.n.c.workflow.soap.SoapDelegate - I/O error: Connection reset; nested exception is java.net.SocketException: Connection reset org.springframework.ws.client.WebServiceIOException: I/O error: Connection reset; nested exception is java.net.SocketException: Connection reset 2025-05-08 16:02:43.809 [https-jsse-nio-8450-exec-24] INFO c.m.n.c.workflow.soap.SoapDelegate - >>> End Executing Service: FnService|updateOltPort|300934.0|ms|KO|WebServiceIOException|I/O error: Connection reset; nested exception is java.net.SocketException: Connection reset [nep@wat-sf-nep-ws01p-v:6 logs] $ utmpdump Regards, Yasssin

Abir Messaikeh added a comment - 30/Dec/25 3:02 PM to confirm by hassan if we need to close this ticket

Abir Messaikeh added a comment - 15/Apr/26 11:02 AM no new occurence for now , closing it and will re-open if happens again