Details

    • Customer:
      OMAN-Tel
    • Complexity:
      High
    • Severity:
      Critical
    • Product:
      NEP
    • REQUESTER:
      INTERNAL

      Description

      it is found the the additional Information for the 4G nodes are not updating in NEP. there are around 65K ass/Adj nodes in XML. But in NEP the count is around 320K in NEP.

      So need a cleanup script to be applied in NEP.

      I have attached SS from NEP and XML. Please check.

        Activity

        Aurobinda Panda logged work - 04/Nov/25 12:00 AM
        • Time Spent:
          1 hour, 30 minutes
           

          Issue checked and raised to L3.

        Aurobinda Panda made changes -
        Field Original Value New Value
        Gantt Options Milestone (set to milestone: having a due date but zero effort)
        Planned Start 2025-11-07 24:00 (milestone: set planned start date to due date)
        Planned End 2025-11-07 24:00 (milestone: set planned end date to due date)
        Aurobinda Panda made changes -
        Summary Additional info not Updating in NEP for 4G Nodes OT | Additional info not Updating in NEP for 4G Nodes
        Aurobinda Panda made changes -
        Remaining Estimate 0 minutes [ 0 ]
        Time Spent 1 hour, 30 minutes [ 5400 ]
        Worklog Id 282509 [ 282509 ]
        Aurobinda Panda made changes -
        Baseline Start 2025-11-07 24:00 (set baseline based of initial work logging)
        Baseline End 2025-11-07 24:00 (set baseline based of initial work logging)
        Aurobinda Panda made changes -
        Link This issue blocks OMAN-7273 [ OMAN-7273 ]
        Aurobinda Panda made changes -
        Link This issue blocks OMAN-7273 [ OMAN-7273 ]
        Aurobinda Panda logged work - 05/Nov/25 12:00 AM
        • Time Spent:
          30 minutes
           

          discussed with L3 for the requirement.

        Marwan Kanaan logged work - 05/Nov/25 12:00 AM
        • Time Spent:
          1 hour
           

          create quary to delete the additional info for SranBs and EnodeB

        Khaled Khalil made changes -
        Assignee Khaled Khalil [ kkhalil ] Marwan Kanaan [ mkanaan ]
        Marwan Kanaan made changes -
        Status Open Bug [ 10108 ] Dev Scheduled [ 10014 ]
        Marwan Kanaan made changes -
        Status Dev Scheduled [ 10014 ] Implementation in progress [ 10016 ]
        Hide
        Aurobinda Panda added a comment - - edited

        Dear @marwan,

        Please prepare a script to remove all the Association and Adj Node from NEP additional Information data for SRANBS and EnodeB. We need to import new data related to this.

        Show
        Aurobinda Panda added a comment - - edited Dear @marwan, Please prepare a script to remove all the Association and Adj Node from NEP additional Information data for SRANBS and EnodeB. We need to import new data related to this.
        Aurobinda Panda made changes -
        Time Spent 1 hour, 30 minutes [ 5400 ] 2 hours [ 7200 ]
        Worklog Id 282645 [ 282645 ]
        Marwan Kanaan made changes -
        Time Spent 2 hours [ 7200 ] 3 hours [ 10800 ]
        Worklog Id 282661 [ 282661 ]
        Natnael Asfaw logged work - 06/Nov/25 12:00 AM
        • Time Spent:
          1 hour
           

          Apply script and restart .180

        Aurobinda Panda logged work - 06/Nov/25 12:00 AM - edited
        • Time Spent:
          1 hour
           

          Asked L2 to generate XML and upload to test server. XM: checked post generation.

        Marwan Kanaan made changes -
        Status Implementation in progress [ 10016 ] To Be Released [ 10400 ]
        Natnael Asfaw made changes -
        Time Spent 3 hours [ 10800 ] 4 hours [ 14400 ]
        Worklog Id 282736 [ 282736 ]
        Aurobinda Panda made changes -
        Time Spent 4 hours [ 14400 ] 4 hours, 15 minutes [ 15300 ]
        Worklog Id 282747 [ 282747 ]
        Khaled Khalil made changes -
        Status To Be Released [ 10400 ] Ready for QA [ 10023 ]
        Assignee Marwan Kanaan [ mkanaan ] Aurobinda Panda [ apanda ]
        Aurobinda Panda made changes -
        Worklog Id 282747 [ 282747 ]
        Aurobinda Panda made changes -
        Time Spent 4 hours, 15 minutes [ 15300 ] 5 hours [ 18000 ]
        Worklog Id 282747 [ 282747 ]
        Aurobinda Panda logged work - 07/Nov/25 12:00 AM
        • Time Spent:
          1 hour
           

          Data checked post cleanup done. But found same issue. issue again raised to L3.

        Natnael Asfaw logged work - 07/Nov/25 12:00 AM
        • Time Spent:
          1 hour
           

          Apply script and restart .180

        Aurobinda Panda made changes -
        Time Spent 5 hours [ 18000 ] 6 hours [ 21600 ]
        Worklog Id 282837 [ 282837 ]
        Aurobinda Panda made changes -
        Status Ready for QA [ 10023 ] QA In Progress [ 10015 ]
        Hide
        Aurobinda Panda added a comment -

        As checked still required data not removed from NEP 180. Marwan checking for the issue.

        Show
        Aurobinda Panda added a comment - As checked still required data not removed from NEP 180. Marwan checking for the issue.
        Aurobinda Panda made changes -
        Assignee Aurobinda Panda [ apanda ] Marwan Kanaan [ mkanaan ]
        Natnael Asfaw made changes -
        Time Spent 6 hours [ 21600 ] 7 hours [ 25200 ]
        Worklog Id 282847 [ 282847 ]
        Aurobinda Panda logged work - 10/Nov/25 12:00 AM
        • Time Spent:
          30 minutes
           

          Discussed with Team. script again run and found OK. Ticket closed.

        Natnael Asfaw logged work - 10/Nov/25 12:00 AM
        • Time Spent:
          1 hour
           

          Applyscript and restart

        Marwan Kanaan logged work - 10/Nov/25 12:00 AM
        • Time Spent:
          1 day
           

          fixing and running query

        Hide
        Marwan Kanaan added a comment -

        Dear @Aurobinda Panda,

        Kindly recheck after @Natnael Asfaw restarts the server and verify if the issue persists.

        Show
        Marwan Kanaan added a comment - Dear @Aurobinda Panda, Kindly recheck after @Natnael Asfaw restarts the server and verify if the issue persists.
        Marwan Kanaan made changes -
        Assignee Marwan Kanaan [ mkanaan ] Aurobinda Panda [ apanda ]
        Aurobinda Panda made changes -
        Link This issue is parent task of OMAN-7273 [ OMAN-7273 ]
        Aurobinda Panda made changes -
        Status QA In Progress [ 10015 ] Closed [ 6 ]
        Resolution Fixed [ 1 ]
        Hide
        Aurobinda Panda added a comment -

        Script has been run again and found OK. Ticket closed.

        Show
        Aurobinda Panda added a comment - Script has been run again and found OK. Ticket closed.
        Aurobinda Panda made changes -
        Time Spent 7 hours [ 25200 ] 7 hours, 30 minutes [ 27000 ]
        Worklog Id 282939 [ 282939 ]
        Natnael Asfaw made changes -
        Time Spent 7 hours, 30 minutes [ 27000 ] 1 day, 30 minutes [ 30600 ]
        Worklog Id 282963 [ 282963 ]
        Marwan Kanaan made changes -
        Time Spent 1 day, 30 minutes [ 30600 ] 2 days, 30 minutes [ 59400 ]
        Worklog Id 283593 [ 283593 ]
        Transition Time In Source Status Execution Times Last Executer Last Execution Date
        Open Bug Open Bug Dev Scheduled Dev Scheduled
        1d 6h 18m 1 Marwan Kanaan 05/Nov/25 11:42 AM
        Dev Scheduled Dev Scheduled Implementation in progress Implementation in progress
        2s 1 Marwan Kanaan 05/Nov/25 11:42 AM
        Implementation in progress Implementation in progress To Be Released To Be Released
        20h 17m 1 Marwan Kanaan 06/Nov/25 7:59 AM
        To Be Released To Be Released Ready for QA Ready for QA
        6h 35m 1 Khaled Khalil 06/Nov/25 2:34 PM
        Ready for QA Ready for QA QA In Progress QA In Progress
        21h 3m 1 Aurobinda Panda 07/Nov/25 11:37 AM
        QA In Progress QA In Progress Closed Closed
        2d 21h 15m 1 Aurobinda Panda 10/Nov/25 8:52 AM
        Subversion JIRA

        Links Hierarchy

         Documentation

        Invalid license: EXPIRED

          People

          • Assignee:
            Aurobinda Panda
            Reporter:
            Aurobinda Panda
          • Votes:
            0 Vote for this issue
            Watchers:
            2 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 - 2 days, 30 minutes
              2d 30m

                Drag and Drop