[LS-773] Zain Kuwait nep get down with FATAL error Created: 05/Nov/25  Updated: 28/Nov/25  Due: 05/Nov/25  Resolved: 18/Nov/25

Status: Cancelled
Project: L3 Support
Component/s: NEP
Affects Version/s: None
Fix Version/s: None

Type: Bug Priority: Normal
Reporter: Manjit Kumar Assignee: Manjit Kumar
Resolution: Done Votes: 0
Labels: None
Remaining Estimate: 0 minutes
Time Spent: 7 hours, 30 minutes
Original Estimate: Not Specified

Attachments: File DELETE_FROM_BGP_PEER_20251107.sql    
Customer:
Zain Kuwait
Planned Start:
Planned End:
Rejected By: Mustapha Al-Hage
Actual Start:
Date of Baselining:

 Description   

Dear Team,

As checked in morning and found nep down, could you please check below error message and i will attach full log in mail and suggest.

2025-11-05 02:30:24,579 ERROR [com.mobinets.nps.services.imtDataInput.impl.ImtCreateWS] (Thread-124) Unavailable Service 'Save to Database'.: org.hibernate.exception.ConstraintViolationException: could not execute batch
at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:337)
at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:39)
at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1295)
at com.mobinets.nps.interceptor.NpsSessionInterceptor.doBatch(NpsSessionInterceptor.java:513)
at sun.reflect.GeneratedMethodAccessor4186.invoke(Unknown Source)
Caused by: java.sql.BatchUpdateException: ORA-00001: unique constraint (ZAINKW_SEP30.SYS_C0077046) violated
at oracle.jdbc.driver.OraclePreparedStatement.generateBatchUpdateException(OraclePreparedStatement.java:10345)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1135)
at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.performExecution(BatchingBatch.java:110)
... 31 more
2025-11-05 02:30:24,580 INFO [stdout] (AsyncAppender-Dispatcher-Thread-107) 02:30:24-[FATAL][SaveRunner][Thread-124] Error while it will may calling saving instances database
2025-11-05 02:30:24,580 FATAL [com.mobinets.nep.npt.db.ThreadSaveContainer] (Thread-124) Error while saving: java.lang.RuntimeException: com.mobinets.nep.npt.service.model.NptException: com.mobinets.nps.model.exception.NpsException: org.hibernate.exception.ConstraintViolationException: could not execute batch
at com.mobinets.nep.npt.db.SaveRunner.run(SaveRunner.java:82)
at com.mobinets.nep.npt.db.ThreadSaveContainer$1.run(ThreadSaveContainer.java:77)

 Comments   
Comment by Mustapha Al-Hage [ 07/Nov/25 ]

Dears,

After our discussions via teams. I have attached the requested script that you might use to delete data if the approach you mentioned did not work.

Regards,
Mustapha

Comment by Abir Messaikeh [ 18/Nov/25 ]

we did not use the script , we have stopped IP dumps with logical details with .info extension as they are not needed and used anymore on KW platform

Generated at Fri Apr 17 09:37:31 EEST 2026 using JIRA 6.1.4#6159-sha1:44eaedef2e4a625c6c7183698b2468d4719c20dc.