L3 Support
  1. L3 Support
  2. LS-741

OT_IP address duplicating in IP data with and without NE

        Details

        • Customer:
          OMAN-Tel
        • REQUESTER:
          INTERNAL

          Description

          It is observed that, same IP is available in NEP IP data. One of them is free and another one is with NE. SS is attached for your reference.

          And it is found that, same IP is populated in NEP multiple times also.
          SS attached.

          So please check to remove all the Ips without Object ID from NEP.

            Activity

            Descending order - Click to sort in ascending order
            Subversion JIRA

            Links Hierarchy

            		  Documentation

            Invalid license: EXPIRED

            Transition Time In Source Status Execution Times Last Executer Last Execution Date
            To Be Released To Be Released Ready for QA Ready for QA
            		1d 1h 2m 2 Khaled Khalil 22/Oct/25 1:21 PM
            Ready for QA Ready for QA QA In Progress QA In Progress
            		46d 19h 35m 2 Aurobinda Panda 28/Oct/25 10:00 AM
            QA In Progress QA In Progress Reopened Reopened
            		22s 2 Aurobinda Panda 28/Oct/25 10:01 AM
            Reopened Reopened Dev Scheduled Dev Scheduled
            		21d 20h 25m 2 Hassan Abdine 05/Nov/25 10:51 AM
            Dev Scheduled Dev Scheduled Need More Info Need More Info
            		14m 52s 2 Marwan Kanaan 05/Nov/25 11:06 AM
            Need More Info Need More Info Open Bug Open Bug
            		15d 8h 40m 2 Aurobinda Panda 07/Nov/25 11:43 AM
            Open Bug Open Bug Dev Scheduled Dev Scheduled
            		8d 19h 14m 3 Marwan Kanaan 11/Nov/25 9:03 AM
            Dev Scheduled Dev Scheduled Implementation in progress Implementation in progress
            		21h 21m 3 Marwan Kanaan 11/Nov/25 9:04 AM
            Implementation in progress Implementation in progress Dev Paused Dev Paused
            		7d 22h 7m 1 Marwan Kanaan 19/Nov/25 7:11 AM
            Dev Paused Dev Paused Implementation in progress Implementation in progress
            		107d 1h 44m 1 Marwan Kanaan 06/Mar/26 8:56 AM
            Implementation in progress Implementation in progress To Be Released To Be Released
            		9d 2h 10m 3 Marwan Kanaan 06/Mar/26 8:56 AM
            To Be Released To Be Released Implementation in progress Implementation in progress
            		2m 5s 1 Marwan Kanaan 06/Mar/26 8:58 AM
            Implementation in progress Implementation in progress Need More Info Need More Info
            		1m 1 Marwan Kanaan 06/Mar/26 8:59 AM
            Marwan Kanaan made changes -
            Status Implementation in progress [ 10016 ] Need More Info [ 10011 ]
            Assignee Marwan Kanaan [ mkanaan ] Aurobinda Panda [ apanda ]
            Hide
            Permalink
            Marwan Kanaan added a comment -

            @aurobinda kindly add new details if the issue still exsit

            Show
            Marwan Kanaan added a comment - @aurobinda kindly add new details if the issue still exsit
            Marwan Kanaan made changes -
            Status To Be Released [ 10400 ] Implementation in progress [ 10016 ]
            Marwan Kanaan made changes -
            Status Implementation in progress [ 10016 ] To Be Released [ 10400 ]
            Marwan Kanaan made changes -
            Status Dev Paused [ 10017 ] Implementation in progress [ 10016 ]
            Marwan Kanaan made changes -
            Time Spent 2 weeks, 1 day, 7 hours [ 342000 ] 2 weeks, 2 days, 7 hours [ 370800 ]
            Worklog Id 283821 [ 283821 ]
            Marwan Kanaan made changes -
            Status Implementation in progress [ 10016 ] Dev Paused [ 10017 ]
            Permalink
            Marwan Kanaan logged work - 18/Nov/25 12:00 AM
            • Time Spent:
              1 day
               

              try finding solutions for two import issue

            Marwan Kanaan made changes -
            Status Dev Scheduled [ 10014 ] Implementation in progress [ 10016 ]
            Marwan Kanaan made changes -
            Status Open Bug [ 10108 ] Dev Scheduled [ 10014 ]
            Aurobinda Panda made changes -
            Attachment IP without NE post cleanup.JPG [ 121509 ]
            Aurobinda Panda made changes -
            Status Need More Info [ 10011 ] Open Bug [ 10108 ]
            Hide
            Permalink
            Aurobinda Panda added a comment - - edited

            @marwan,
            Still IPs found without NE. Please check again.

            SS attached for your reference.

            Show
            Aurobinda Panda added a comment - - edited @marwan, Still IPs found without NE. Please check again. SS attached for your reference.
            Aurobinda Panda made changes -
            Assignee Aurobinda Panda [ apanda ] Marwan Kanaan [ mkanaan ]
            Marwan Kanaan made changes -
            Status Dev Scheduled [ 10014 ] Need More Info [ 10011 ]
            Assignee Marwan Kanaan [ mkanaan ] Aurobinda Panda [ apanda ]
            Hassan Abdine made changes -
            Status Reopened [ 4 ] Dev Scheduled [ 10014 ]
            Hide
            Permalink
            Marwan Kanaan added a comment - - edited

            Dear @aurobinda,

            the last clean up done on .180.

            Best Regards,
            Marwan Kanaan I Software Developer

            Show
            Marwan Kanaan added a comment - - edited Dear @aurobinda, the last clean up done on .180. Best Regards, Marwan Kanaan I Software Developer
            Hide
            Permalink
            Marwan Kanaan added a comment -

            Dear @Aurobinda Panda,

            Another clean script for IPS has been completed. Kindly check and verify it at your earliest convenience.

            Best Regards,

            Marwan Kanaan I Software Developer

            Show
            Marwan Kanaan added a comment - Dear @Aurobinda Panda, Another clean script for IPS has been completed. Kindly check and verify it at your earliest convenience. Best Regards, Marwan Kanaan I Software Developer
            Hide
            Permalink
            Aurobinda Panda added a comment -

            Dear @Marwan, As checked, Still issue not fixed post script run on 180 and prod. Please check again.

            Show
            Aurobinda Panda added a comment - Dear @Marwan, As checked, Still issue not fixed post script run on 180 and prod. Please check again.
            Aurobinda Panda made changes -
            Assignee Khaled Khalil [ kkhalil ] Marwan Kanaan [ mkanaan ]
            Aurobinda Panda made changes -
            Status QA In Progress [ 10015 ] Reopened [ 4 ]
            Assignee Aurobinda Panda [ apanda ] Khaled Khalil [ kkhalil ]
            Aurobinda Panda made changes -
            Status Ready for QA [ 10023 ] QA In Progress [ 10015 ]
            Hide
            Permalink
            Aurobinda Panda added a comment -

            Changes will be checked post XML Import.

            Show
            Aurobinda Panda added a comment - Changes will be checked post XML Import.
            Khaled Khalil made changes -
            Status To Be Released [ 10400 ] Ready for QA [ 10023 ]
            Assignee Marwan Kanaan [ mkanaan ] Aurobinda Panda [ apanda ]
            Hide
            Permalink
            Marwan Kanaan added a comment -

            Dear @Aurobinda Panda,

            Kindly note that another cleanup script was executed today to address any IPs without a node ID and with a status of “UsedByNetwork” or “Free.” This aligns with the new IP data saving logic, which now deletes any IP entries lacking a node ID to prevent duplication.

            Kindly verify when possible.

            Show
            Marwan Kanaan added a comment - Dear @Aurobinda Panda, Kindly note that another cleanup script was executed today to address any IPs without a node ID and with a status of “UsedByNetwork” or “Free.” This aligns with the new IP data saving logic, which now deletes any IP entries lacking a node ID to prevent duplication. Kindly verify when possible.
            Marwan Kanaan made changes -
            Status Implementation in progress [ 10016 ] To Be Released [ 10400 ]
            Marwan Kanaan made changes -
            Status Dev Scheduled [ 10014 ] Implementation in progress [ 10016 ]
            Marwan Kanaan made changes -
            Assignee Aurobinda Panda [ apanda ] Marwan Kanaan [ mkanaan ]
            Hide
            Permalink
            Marwan Kanaan added a comment -

            a clean up is needed for ips without nodeid and status is usedbynetowrk and free

            Show
            Marwan Kanaan added a comment - a clean up is needed for ips without nodeid and status is usedbynetowrk and free
            Marwan Kanaan made changes -
            Component/s NEP [ 16200 ]
            Abir Messaikeh made changes -
            Project NEP_OMAN_TEL [ 12300 ] L3 Support [ 14300 ]
            Key OMAN-7274 LS-741
            Abir Messaikeh made changes -
            Project L3 Support [ 14300 ] NEP_OMAN_TEL [ 12300 ]
            Key LS-535 OMAN-7274
            Component/s NEP [ 16200 ]
            Abir Messaikeh made changes -
            Status Open Bug [ 10108 ] Dev Scheduled [ 10014 ]
            Abir Messaikeh made changes -
            Status Need More Info [ 10011 ] Open Bug [ 10108 ]
            Marwan Kanaan made changes -
            Status Dev Scheduled [ 10014 ] Need More Info [ 10011 ]
            Marwan Kanaan made changes -
            Status Reopened [ 4 ] Dev Scheduled [ 10014 ]
            Assignee Khaled Khalil [ kkhalil ] Aurobinda Panda [ apanda ]
            Hide
            Permalink
            Marwan Kanaan added a comment -

            to check if the solution of LS-561 solved this issue

            Show
            Marwan Kanaan added a comment - to check if the solution of LS-561 solved this issue
            Aurobinda Panda made changes -
            Time Spent 2 weeks, 1 day, 6 hours [ 338400 ] 2 weeks, 1 day, 7 hours [ 342000 ]
            Worklog Id 278404 [ 278404 ]
            Aurobinda Panda made changes -
            Attachment IP Duplication_with and Without Object ID.jpg [ 118208 ]
            Attachment IP Duplication_with same Object ID.jpg [ 118209 ]
            Aurobinda Panda made changes -
            Status QA In Progress [ 10015 ] Reopened [ 4 ]
            Assignee Aurobinda Panda [ apanda ] Khaled Khalil [ kkhalil ]
            Resolution Not Fixed [ 10200 ]
            Aurobinda Panda made changes -
            Status Ready for QA [ 10023 ] QA In Progress [ 10015 ]
            Assignee Marwan Kanaan [ mkanaan ] Aurobinda Panda [ apanda ]
            Aurobinda Panda made changes -
            Assignee Aurobinda Panda [ apanda ] Marwan Kanaan [ mkanaan ]
            Aurobinda Panda made changes -
            Time Spent 2 weeks, 1 day, 4 hours [ 331200 ] 2 weeks, 1 day, 6 hours [ 338400 ]
            Worklog Id 278326 [ 278326 ]
            Hide
            Permalink
            Aurobinda Panda added a comment -

            It is found that still issues are available in NEP IP Data.
            Details are shared with Marwan.

            Show
            Aurobinda Panda added a comment - It is found that still issues are available in NEP IP Data. Details are shared with Marwan.
            Permalink
            Aurobinda Panda logged work - 23/Sep/25 12:00 AM
            • Time Spent:
              2 hours
               

              Issue checked for Duplicate IPs.

            Permalink
            Aurobinda Panda logged work - 19/Sep/25 12:00 AM
            • Time Spent:
              1 hour
               

              Issue checked in NEP IP Address.

            Marwan Kanaan made changes -
            Time Spent 2 weeks, 1 day, 3 hours [ 327600 ] 2 weeks, 1 day, 4 hours [ 331200 ]
            Worklog Id 275236 [ 275236 ]
            Aurobinda Panda made changes -
            Time Spent 2 weeks, 1 day, 2 hours [ 324000 ] 2 weeks, 1 day, 3 hours [ 327600 ]
            Worklog Id 275228 [ 275228 ]
            Permalink
            Marwan Kanaan logged work - 22/Aug/25 12:00 AM
            • Time Spent:
              1 hour
               

              connect to the prod and do some quaries to and give reponse for an asked issue

            Marwan Kanaan made changes -
            Time Spent 2 weeks, 6 hours [ 309600 ] 2 weeks, 1 day, 2 hours [ 324000 ]
            Worklog Id 275132 [ 275132 ]
            Hide
            Permalink
            Marwan Kanaan added a comment -

            Dear @Aurobinda Panda,

            After rechecking, I found that the issue was caused by an incorrect node ID.

            "screenshot attatched"

            The problematic entry has been deleted, kindly restart the server and verify the changes.
            Best Regards,

            Marwan Kanaan I Software Developer

            Show
            Marwan Kanaan added a comment - Dear @Aurobinda Panda, After rechecking, I found that the issue was caused by an incorrect node ID. "screenshot attatched" The problematic entry has been deleted, kindly restart the server and verify the changes. Best Regards, Marwan Kanaan I Software Developer
            Marwan Kanaan made changes -
            Attachment Screenshot 2025-08-21 084920.png [ 115901 ]
            Hide
            Permalink
            Marwan Kanaan added a comment -

            Dears @Abir Messaikeh, @Aurobinda Panda,

            The duplicate entries in IPdata have been addressed. I applied the scripts to remove all entries that have a nodeID Null.
            Please apply the latest patch, restart the server, and confirm once the changes are verified.
            Best Regards,

            Marwan Kanaan I Software Developer

            Show
            Marwan Kanaan added a comment - Dears @Abir Messaikeh, @Aurobinda Panda, The duplicate entries in IPdata have been addressed. I applied the scripts to remove all entries that have a nodeID Null. Please apply the latest patch, restart the server, and confirm once the changes are verified. Best Regards, Marwan Kanaan I Software Developer
            Marwan Kanaan made changes -
            Time Spent 2 weeks, 5 hours [ 306000 ] 2 weeks, 6 hours [ 309600 ]
            Worklog Id 275111 [ 275111 ]
            Marwan Kanaan made changes -
            Time Spent 2 weeks, 3 hours [ 298800 ] 2 weeks, 5 hours [ 306000 ]
            Worklog Id 275110 [ 275110 ]
            Permalink
            Aurobinda Panda logged work - 21/Aug/25 12:00 AM
            • Time Spent:
              1 hour
               

              Issue checked post script run and shared observation with L3.

            Permalink
            Marwan Kanaan logged work - 21/Aug/25 12:00 AM
            • Time Spent:
              4 hours
               

              The scripts were applied on production under the supervision of Mr. Hassan Adbine.

            Permalink
            Marwan Kanaan logged work - 21/Aug/25 12:00 AM
            • Time Spent:
              1 hour
               

              Some ipdata still shown with empty nodeid in the ip data report,So after rechecking I found that the issue was caused by an incorrect node ID.
              The problematic entry has been deleted.

            Permalink
            Marwan Kanaan logged work - 20/Aug/25 12:00 AM
            • Time Spent:
              2 hours
               

              The duplicate entries in IPdata have been addressed on .180. I applied the scripts to remove all entries that have a nodeID Null.

            Mustapha Al-Hage made changes -
            Time Spent 3 hours [ 10800 ] 2 weeks, 3 hours [ 298800 ]
            Worklog Id 274723 [ 274723 ]
            Aurobinda Panda made changes -
            Time Spent 2 hours [ 7200 ] 3 hours [ 10800 ]
            Worklog Id 274568 [ 274568 ]
            Permalink
            Aurobinda Panda logged work - 14/Aug/25 12:00 AM
            • Time Spent:
              1 hour
               

              Issue checked post script run on 180.

            Khaled Khalil made changes -
            Status To Be Released [ 10400 ] Ready for QA [ 10023 ]
            Assignee Mustapha Al-Hage [ malhage ] Aurobinda Panda [ apanda ]
            Khaled Khalil made changes -
            Status Implementation in progress [ 10016 ] To Be Released [ 10400 ]
            Hide
            Permalink
            Mustapha Al-Hage added a comment -

            Dears, 

            There was an issue in implemented logic but it has been handled. 
            Patch is needed: 3.7.0.1335

            Regards, 
            Mustapha

            Show
            Mustapha Al-Hage added a comment - Dears,  There was an issue in implemented logic but it has been handled.  Patch is needed: 3.7.0.1335 Regards,  Mustapha
            Aurobinda Panda made changes -
            Time Spent 1 hour [ 3600 ] 2 hours [ 7200 ]
            Worklog Id 273837 [ 273837 ]
            Khaled Khalil made changes -
            Assignee Khaled Khalil [ kkhalil ] Mustapha Al-Hage [ malhage ]
            Khaled Khalil made changes -
            Status Dev Scheduled [ 10014 ] Implementation in progress [ 10016 ]
            Assignee Mustapha Al-Hage [ malhage ] Khaled Khalil [ kkhalil ]
            Khaled Khalil made changes -
            Status Open Bug [ 10108 ] Dev Scheduled [ 10014 ]
            Khaled Khalil made changes -
            Assignee Nouha Mhadhbi [ nmhadhbi ] Mustapha Al-Hage [ malhage ]
            Permalink
            Aurobinda Panda logged work - 04/Aug/25 12:00 AM
            • Time Spent:
              1 hour
               

              Issue discussed with Team.

            Permalink
            Mustapha Al-Hage logged work - 01/Aug/25 8:55 AM
            • Time Spent:
              2 weeks
               

              Writing a script, debugging issue and applying script on 180

            Nouha Mhadhbi made changes -
            Assignee Khaled Khalil [ kkhalil ] Nouha Mhadhbi [ nmhadhbi ]
            Aurobinda Panda made changes -
            Baseline Start 2025-07-31 24:00 (set baseline based of initial work logging)
            Baseline End 2025-07-31 24:00 (set baseline based of initial work logging)
            Aurobinda Panda made changes -
            Remaining Estimate 0 minutes [ 0 ]
            Time Spent 1 hour [ 3600 ]
            Worklog Id 273123 [ 273123 ]
            Aurobinda Panda made changes -
            Summary IP address duplicating in IP data with and without NE OT_IP address duplicating in IP data with and without NE
            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-07-31 24:00 (milestone: set planned start date to due date)
            Planned End 2025-07-31 24:00 (milestone: set planned end date to due date)
            Permalink
            Aurobinda Panda logged work - 30/Jul/25 12:00 AM
            • Time Spent:
              1 hour
               

              issue checked & shared with L3.

            Cancel

              People

              • Assignee:
                Aurobinda Panda
                Reporter:
                Aurobinda Panda
              • 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 - 2 weeks, 2 days, 7 hours
                  2w 2d 7h

                    Drag and Drop