Details
-
Type:
Bug
-
Status:
Cancelled
(View Workflow)
-
Priority:
Normal
-
Resolution: Done
-
Component/s: NEP
-
Labels:None Labels
-
Customer:Zain Kuwait
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)
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