Details

    • Type: Bug Bug
    • Status: Cancelled Cancelled (View Workflow)
    • Priority: Normal 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)

        Activity

        Hide
        Mustapha Al-Hage added a comment -

        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

        Show
        Mustapha Al-Hage added a comment - 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
        Hide
        Abir Messaikeh added a comment -

        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

        Show
        Abir Messaikeh added a comment - 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

          People

          • Assignee:
            Manjit Kumar
            Reporter:
            Manjit Kumar
            Rejected By:
            Mustapha Al-Hage
          • Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

            • Due:
              Created:
              Updated:
              Resolved:
              Planned Start:
              Planned End:
              Actual Start:
              Date of Baselining:

              Time Tracking

              Estimated:
              Original Estimate - Not Specified
              Not Specified
              Remaining:
              Remaining Estimate - 0 minutes
              0m
              Logged:
              Time Spent - 7 hours, 30 minutes
              7h 30m

                Drag and Drop