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

to confirm by hassan if we need to close this ticket

no new occurence for now , closing it and will re-open if happens again