Details

    • Type: Bug Bug
    • Status: Cancelled Cancelled (View Workflow)
    • Priority: Urgent Urgent
    • Resolution: Fixed
    • Component/s: NEP
    • Labels:
      None Labels
    • Customer:
      Zain Kuwait

      Description

      Error while saving data to DB after the xml import process on test server which lead to process unbinding and application shutdown.

      2025-10-02 02:59:09,945 ERROR [com.mobinets.nps.dao.impl.NetworkUpdateDAO] (Thread-126) Failed SaveOrUpdate com.mobinets.nps.model.nodeinterfaces.NodeSlot.: org.hibernate.exception.ConstraintViolationException: could not execute batch

      Caused by: java.sql.BatchUpdateException: ORA-02291: integrity constraint (ZAINKW_SEP30.FK_SLOTID_SHELFID) violated - parent key not found

      link to server log: https://we.tl/t-WH55iklxtb

      2025-10-02 02:59:10,394 ERROR [com.mobinets.nps.services.imtDataInput.impl.ImtCreateWS] (Thread-126) Unavailable Service 'Save to Database'.: org.hibernate.exception.ConstraintViolationException: could not execute batch

        Activity

        Mohamad Merheb made changes -
        Field Original Value New Value
        Gantt Options Milestone (set to milestone: having a due date but zero effort)
        Planned Start 2025-10-02 24:00 (milestone: set planned start date to due date)
        Planned End 2025-10-02 24:00 (milestone: set planned end date to due date)
        Hassan Abdine made changes -
        Component/s NEP [ 16200 ]
        Khaled Khalil made changes -
        Assignee Khaled Khalil [ kkhalil ] Wajdi Jomaa [ wjomaa ]
        Hide
        Abir Messaikeh added a comment -

        Constraint was removed to allow import to be done

        Show
        Abir Messaikeh added a comment - Constraint was removed to allow import to be done
        Hide
        Abir Messaikeh added a comment -

        L3 to confirm if we can re-establish the constraint.

        Show
        Abir Messaikeh added a comment - L3 to confirm if we can re-establish the constraint.
        Khaled Khalil made changes -
        Assignee Wajdi Jomaa [ wjomaa ] Mustapha Al-Hage [ malhage ]
        Hide
        Mustapha Al-Hage added a comment - - edited

        Please note that the constraint is re-established. Try to import the XML and confirm if the issue is still persisting

        Show
        Mustapha Al-Hage added a comment - - edited Please note that the constraint is re-established. Try to import the XML and confirm if the issue is still persisting
        Abir Messaikeh made changes -
        Status Open Bug [ 10108 ] Cancelled [ 10013 ]
        Resolution Fixed [ 1 ]
        Hide
        Abir Messaikeh added a comment -

        import is OK with constraint also as checked

        Show
        Abir Messaikeh added a comment - import is OK with constraint also as checked
        Transition Time In Source Status Execution Times Last Executer Last Execution Date
        Open Bug Open Bug Cancelled Cancelled
        63d 21h 16m 1 Abir Messaikeh 05/Dec/25 7:16 AM
        Subversion JIRA

        Links Hierarchy

         Documentation

        Invalid license: EXPIRED

          People

          • Assignee:
            Mustapha Al-Hage
            Reporter:
            Mohamad Merheb
          • Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

            • Due:
              Created:
              Updated:
              Resolved:
              Planned Start:
              Planned End:

              Drag and Drop