L3 Support
  1. L3 Support
  2. LS-684

Zain Kuwait saving to DB error

        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

            Descending order - Click to sort in ascending order
            Hide
            Permalink
            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
            Hide
            Permalink
            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
            Hide
            Permalink
            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.
            Hide
            Permalink
            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
            Cancel

              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