L3 Support
  1. L3 Support
  2. LS-788

AIRTEL_IP Count Mismatch in IP Report_ALL PROD

        Details

        • Customer:
          Airtel India

          Description

          data is available in XML but the IP are not getting parsed in NEP the error ss attached from JK circle.. the issue is observed in all the circle

          Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. LS-354 IP data report issue

          • Closed - The issue is considered finished, the resolution is correct. Issues which are closed can be reopened.

          Bug - A problem which impairs or prevents the functions of the product. LS-900 ipV6 detail missing in NEP KK CIRCLE

          • Implementation in progress -

            Activity

            Ascending order - Click to sort in descending order
            Priyasha Tiwari made changes -
            Field Original Value New Value
            Gantt Options Milestone (set to milestone: having a due date but zero effort)
            Planned Start 2025-11-21 24:00 (milestone: set planned start date to due date)
            Planned End 2025-11-21 24:00 (milestone: set planned end date to due date)
            Priyasha Tiwari made changes -
            Labels NEP_D
            Priyasha Tiwari made changes -
            Assignee Ankit Bhardwaj [ abhardwaj ] Priyasha Tiwari [ ptiwari ]
            Hide
            Permalink
            Priyasha Tiwari added a comment -

            ADD THE DETAILS AFTER ANALYSIS

            Show
            Priyasha Tiwari added a comment - ADD THE DETAILS AFTER ANALYSIS
            Priyasha Tiwari made changes -
            Project Airtel_Support [ 13603 ] L3 Support [ 14300 ]
            Key ATS-10845 LS-788
            Priyasha Tiwari made changes -
            Component/s NEP [ 16200 ]
            Priyasha Tiwari made changes -
            Attachment ip data report ss.png [ 122500 ]
            Attachment ip data count xml ss.png [ 122501 ]
            Attachment IP data count issue.png [ 122502 ]
            Priyasha Tiwari made changes -
            Summary AIRTEL_IP Count Mismatch in DL Circle IN IP Report_ALL PROD AIRTEL_IP Count Mismatch in IP Report_ALL PROD
            Priyasha Tiwari made changes -
            Description data is available in XML but the IP are not getting parsed in NEP the error ss attached from JK circle.. the issue is observed in all the circle
            Priyasha Tiwari made changes -
            Assignee Priyasha Tiwari [ ptiwari ] Srishti Kashyap [ skashyap ]
            Khaled Khalil made changes -
            Assignee Srishti Kashyap [ skashyap ] Bessem Manita [ bmanita ]
            Permalink
            Priyasha Tiwari logged work - 24/Nov/25 12:00 AM
            • Time Spent:
              2 hours
               

              issue analysis and script executed and post result check

            Permalink
            Basant Kumar logged work - 25/Nov/25 12:00 AM
            • Time Spent:
              1 hour
               

              i have shared logs from jk circle to dev team for some ipdata and ipv6 data deletion .

            Permalink
            Srishti Kashyap logged work - 25/Nov/25 12:00 AM
            • Time Spent:
              7 hours, 30 minutes
               

              tested the scenerio for generating duplicates at local before code change not able to reoccur with available xml..found duplicates ip in xml..shared with marwan and bessem checked another case where ip present in db but not reflecting in nep checked logs and condstructed updation queries and deletion

            Basant Kumar made changes -
            Remaining Estimate 0 minutes [ 0 ]
            Time Spent 1 hour [ 3600 ]
            Worklog Id 284270 [ 284270 ]
            Bkumar made changes -
            Baseline Start 2025-11-21 24:00 (set baseline based of initial work logging)
            Baseline End 2025-11-21 24:00 (set baseline based of initial work logging)
            Permalink
            Srishti Kashyap logged work - 26/Nov/25 12:00 AM
            • Time Spent:
              4 hours
               

              checked the prod data for changes and updation checked the report at prod discussed with integartion regarding script excution requested latestest logs checked logs still the exception during load of logical interface regiving scripts.

            Srishti Kashyap made changes -
            Time Spent 1 hour [ 3600 ] 1 day, 30 minutes [ 30600 ]
            Worklog Id 284403 [ 284403 ]
            Hide
            Permalink
            Srishti Kashyap added a comment -

            found exception during server startup
            org.hibernate.ObjectNotFoundException: No row with the given identifier exists: com.mobinets.nps.model.ipaddress.IPDataV6#DBD54EB54702400BBA59DA2A1F603789
            at org.hibernate.boot.internal.StandardEntityNotFoundDelegate.handleEntityNotFound(StandardEntityNotFoundDelegate.java:28) [hibernate-core-5.1.10.Final.jar:5.1.10.Final]

            shared scripts for deletion of unrefrenced ipdata and ipdatav6 and nodeinterface updation vice versa. attaching script.

            Show
            Srishti Kashyap added a comment - found exception during server startup org.hibernate.ObjectNotFoundException: No row with the given identifier exists: com.mobinets.nps.model.ipaddress.IPDataV6#DBD54EB54702400BBA59DA2A1F603789 at org.hibernate.boot.internal.StandardEntityNotFoundDelegate.handleEntityNotFound(StandardEntityNotFoundDelegate.java:28) [hibernate-core-5.1.10.Final.jar:5.1.10.Final] shared scripts for deletion of unrefrenced ipdata and ipdatav6 and nodeinterface updation vice versa. attaching script.
            Srishti Kashyap made changes -
            Attachment updateinterface20251125.txt [ 122816 ]
            Srishti Kashyap made changes -
            Attachment DeletionScript_IPV4&6_220525.txt [ 122817 ]
            Bessem Manita made changes -
            Assignee Bessem Manita [ bmanita ] Srishti Kashyap [ skashyap ]
            Permalink
            Priyasha Tiwari logged work - 27/Nov/25 12:00 AM
            • Time Spent:
              1 hour
               

              DATA VALIDATION FOR DUPLICATE IP ENTRY

            Permalink
            Srishti Kashyap logged work - 27/Nov/25 12:00 AM - edited
            • Time Spent:
              6 hours, 30 minutes
               

              checked logs contacted integration for exact time of query execution last and activity description happend during that time..had discussion with bessem reviewed script..reupdated the script found ipdatav6id missing reupdated script tested at local double checked with bessem and re released for execution on PROD

            Permalink
            Basant Kumar logged work - 27/Nov/25 12:00 AM
            • Time Spent:
              1 hour
               

              i have run deletion queries on JK prod after that restarted the services .

            Srishti Kashyap made changes -
            Time Spent 1 day, 30 minutes [ 30600 ] 1 day, 4 hours, 30 minutes [ 45000 ]
            Worklog Id 284514 [ 284514 ]
            Priyasha Tiwari made changes -
            Time Spent 1 day, 4 hours, 30 minutes [ 45000 ] 1 day, 6 hours, 30 minutes [ 52200 ]
            Worklog Id 284731 [ 284731 ]
            Priyasha Tiwari made changes -
            Time Spent 1 day, 6 hours, 30 minutes [ 52200 ] 1 day, 7 hours, 30 minutes [ 55800 ]
            Worklog Id 284746 [ 284746 ]
            Permalink
            Aurobinda Panda logged work - 28/Nov/25 12:00 AM
            • Time Spent:
              30 minutes
               

              Internal discussion with team for the issue.

            Permalink
            Srishti Kashyap logged work - 28/Nov/25 12:00 AM - edited
            • Time Spent:
              3 hours
               

              checked prod for if the blanks and ip not reflecting error solved after query execution checked logs aswell as prod data had discussion with marwan for further testing of root cause and its solvation process asked the telco for two small xml with same sample node diff ip config

            Permalink
            Basant Kumar logged work - 28/Nov/25 12:00 AM
            • Time Spent:
              1 hour
               

              we have Executed the SQL queries on the DL and JK databases after that restated the services then shared logs with priyasha

            Hide
            Permalink
            added a comment -

            attaching updated scripts.

            Show
            added a comment - attaching updated scripts.
            made changes -
            Attachment updateinterface20251127.txt [ 123001 ]
            Aurobinda Panda made changes -
            Time Spent 1 day, 7 hours, 30 minutes [ 55800 ] 2 days [ 57600 ]
            Worklog Id 284864 [ 284864 ]
            Permalink
            Basant Kumar logged work - 01/Dec/25 12:00 AM
            • Time Spent:
              1 hour
               

              we have triggred xml on .37 server

            Srishti Kashyap made changes -
            Time Spent 2 days [ 57600 ] 2 days, 3 hours [ 68400 ]
            Worklog Id 284909 [ 284909 ]
            Srishti Kashyap made changes -
            Worklog Id 284909 [ 284909 ]
            Srishti Kashyap made changes -
            Time Spent 2 days, 3 hours [ 68400 ] 3 days, 1 hour, 30 minutes [ 91800 ]
            Worklog Id 284912 [ 284912 ]
            Srishti Kashyap made changes -
            Worklog Id 284912 [ 284912 ]
            Permalink
            Basant Kumar logged work - 02/Dec/25 12:00 AM
            • Time Spent:
              1 hour
               

              copied dumps and generated xml for IP Count Mismatch in DL Circle IN IP Report

            Permalink
            Basant Kumar logged work - 02/Dec/25 12:00 AM
            • Time Spent:
              1 hour
               

              xml generated and shared with priyasha for Count Mismatch in DL Circle IN IP Report

            Basant Kumar made changes -
            Time Spent 3 days, 1 hour, 30 minutes [ 91800 ] 3 days, 2 hours, 30 minutes [ 95400 ]
            Worklog Id 285005 [ 285005 ]
            Basant Kumar made changes -
            Time Spent 3 days, 2 hours, 30 minutes [ 95400 ] 3 days, 3 hours, 30 minutes [ 99000 ]
            Worklog Id 285023 [ 285023 ]
            Basant Kumar made changes -
            Time Spent 3 days, 3 hours, 30 minutes [ 99000 ] 3 days, 4 hours, 30 minutes [ 102600 ]
            Worklog Id 285028 [ 285028 ]
            Permalink
            Basant Kumar logged work - 04/Dec/25 12:00 AM
            • Time Spent:
              1 hour
               

              shared static sheet from JK circle for IP Count Mismatch in DL Circle IN IP Report

            Permalink
            Priyasha Tiwari logged work - 04/Dec/25 12:00 AM
            • Time Spent:
              3 hours
               

              XML shared with sample cases whose interface ,phy conifg are changing

            Basant Kumar made changes -
            Time Spent 3 days, 4 hours, 30 minutes [ 102600 ] 3 days, 5 hours, 30 minutes [ 106200 ]
            Worklog Id 285315 [ 285315 ]
            Basant Kumar made changes -
            Time Spent 3 days, 5 hours, 30 minutes [ 106200 ] 3 days, 6 hours, 30 minutes [ 109800 ]
            Worklog Id 285316 [ 285316 ]
            Basant Kumar made changes -
            Time Spent 3 days, 6 hours, 30 minutes [ 109800 ] 3 days, 7 hours, 30 minutes [ 113400 ]
            Worklog Id 285327 [ 285327 ]
            Priyasha Tiwari made changes -
            Time Spent 3 days, 7 hours, 30 minutes [ 113400 ] 4 days, 2 hours, 30 minutes [ 124200 ]
            Worklog Id 285338 [ 285338 ]
            Permalink
            Srishti Kashyap logged work - 11/Dec/25 12:00 AM
            • Time Spent:
              6 hours
               

              checked the issue and xml working on it

            Permalink
            Srishti Kashyap logged work - 12/Dec/25 12:00 AM
            • Time Spent:
              2 hours, 30 minutes
               

              had discussion with marwan require a new small xml with full physical config as the shared one have only logical config ...checked the related config on prod if the sample case shared have proper info or not

            Srishti Kashyap made changes -
            Time Spent 4 days, 2 hours, 30 minutes [ 124200 ] 4 days, 5 hours [ 133200 ]
            Worklog Id 286107 [ 286107 ]
            Srishti Kashyap made changes -
            Time Spent 4 days, 5 hours [ 133200 ] 1 week, 3 hours [ 154800 ]
            Worklog Id 286108 [ 286108 ]
            Permalink
            Priyasha Tiwari logged work - 18/Dec/25 12:00 AM
            • Time Spent:
              3 hours
               

              new sample case to L3 as requested

            Permalink
            Basant Kumar logged work - 18/Dec/25 12:00 AM
            • Time Spent:
              1 hour
               

              i have extract FSCT564 node from JK circle logical IP and shared on mail .

            Permalink
            Priyasha Tiwari logged work - 19/Dec/25 12:00 AM
            • Time Spent:
              3 hours
               

              coordinating with AI team for XML file for single node of ericssion

            Permalink
            Basant Kumar logged work - 22/Dec/25 12:00 AM
            • Time Spent:
              1 hour
               

              i shared dumps from jk prod server

            Priyasha Tiwari made changes -
            Time Spent 1 week, 3 hours [ 154800 ] 1 week, 6 hours [ 165600 ]
            Worklog Id 286614 [ 286614 ]
            Priyasha Tiwari made changes -
            Time Spent 1 week, 6 hours [ 165600 ] 1 week, 1 day, 1 hour [ 176400 ]
            Worklog Id 286616 [ 286616 ]
            Basant Kumar made changes -
            Time Spent 1 week, 1 day, 1 hour [ 176400 ] 1 week, 1 day, 2 hours [ 180000 ]
            Worklog Id 286709 [ 286709 ]
            Basant Kumar made changes -
            Time Spent 1 week, 1 day, 2 hours [ 180000 ] 1 week, 1 day, 3 hours [ 183600 ]
            Worklog Id 286719 [ 286719 ]
            Permalink
            Srishti Kashyap logged work - 26/Dec/25 12:00 AM
            • Time Spent:
              30 minutes
               

              checked the xml shared by telco not proper re requested again xml shared in evening as checked is ok

            Srishti Kashyap made changes -
            Time Spent 1 week, 1 day, 3 hours [ 183600 ] 1 week, 1 day, 3 hours, 30 minutes [ 185400 ]
            Worklog Id 287422 [ 287422 ]
            Permalink
            Priyasha Tiwari logged work - 06/Jan/26 12:00 AM
            • Time Spent:
              1 hour
               

              internal and call and validating the sample case with l3 team

            Permalink
            Priyasha Tiwari logged work - 07/Jan/26 12:00 AM
            • Time Spent:
              30 minutes
               

              CALL WI l3

            Priyasha Tiwari made changes -
            Time Spent 1 week, 1 day, 3 hours, 30 minutes [ 185400 ] 1 week, 1 day, 4 hours, 30 minutes [ 189000 ]
            Worklog Id 288414 [ 288414 ]
            Priyasha Tiwari made changes -
            Time Spent 1 week, 1 day, 4 hours, 30 minutes [ 189000 ] 1 week, 1 day, 5 hours [ 190800 ]
            Worklog Id 288426 [ 288426 ]
            Hide
            Permalink
            Priyasha Tiwari added a comment -

            permanent fix for this issue is still pending to be resolved by L3 team, all requirement shared

            Show
            Priyasha Tiwari added a comment - permanent fix for this issue is still pending to be resolved by L3 team, all requirement shared
            Priyasha Tiwari made changes -
            Link This issue relates to LS-354 [ LS-354 ]
            Khaled Khalil made changes -
            Status Open Bug [ 10108 ] Dev Scheduled [ 10014 ]
            Khaled Khalil made changes -
            Status Dev Scheduled [ 10014 ] Implementation in progress [ 10016 ]
            Assignee Srishti Kashyap [ skashyap ] Khaled Khalil [ kkhalil ]
            Khaled Khalil made changes -
            Status Implementation in progress [ 10016 ] Dev Paused [ 10017 ]
            Khaled Khalil made changes -
            Assignee Khaled Khalil [ kkhalil ] Srishti Kashyap [ skashyap ]
            Permalink
            Srishti Kashyap logged work - 19/Jan/26 12:00 AM
            • Time Spent:
              4 hours
               

              checking the xml shared last importing in local checking the flow for saving of nodeinterface and ipdata debugging on that

            Permalink
            Srishti Kashyap logged work - 20/Jan/26 12:00 AM
            • Time Spent:
              2 hours
               

              checking the on reimport the flow debugging

            Srishti Kashyap made changes -
            Time Spent 1 week, 1 day, 5 hours [ 190800 ] 1 week, 2 days, 1 hour [ 205200 ]
            Worklog Id 289505 [ 289505 ]
            Srishti Kashyap made changes -
            Time Spent 1 week, 2 days, 1 hour [ 205200 ] 1 week, 2 days, 3 hours [ 212400 ]
            Worklog Id 289506 [ 289506 ]
            Permalink
            Priyasha Tiwari logged work - 30/Jan/26 12:00 AM
            • Time Spent:
              1 hour
               

              CALL WITH l2 AND l3 FOR DELETION SCRIPT

            Permalink
            Marwan Kanaan logged work - 03/Feb/26 12:00 AM - edited
            • Time Spent:
              4 hours
               

              migrated the code and give it to srishti to test it

            Permalink
            Srishti Kashyap logged work - 04/Feb/26 12:00 AM
            • Time Spent:
              2 hours, 30 minutes
               

              applied patch shared by marwan for ip added attribute in DB and manipulated xml ...some regression in code not building correcting workspace

            Marwan Kanaan made changes -
            Time Spent 1 week, 2 days, 3 hours [ 212400 ] 1 week, 2 days, 7 hours [ 226800 ]
            Worklog Id 290610 [ 290610 ]
            Marwan Kanaan made changes -
            Worklog Id 290610 [ 290610 ]
            Priyasha Tiwari made changes -
            Time Spent 1 week, 2 days, 7 hours [ 226800 ] 1 week, 3 days [ 230400 ]
            Worklog Id 290708 [ 290708 ]
            Hide
            Permalink
            Priyasha Tiwari added a comment -

            timeline for this resolution is end of feb. and we already shifted the timeline twice please act accordingly.

            Show
            Priyasha Tiwari added a comment - timeline for this resolution is end of feb. and we already shifted the timeline twice please act accordingly.
            Srishti Kashyap made changes -
            Time Spent 1 week, 3 days [ 230400 ] 1 week, 3 days, 2 hours, 30 minutes [ 239400 ]
            Worklog Id 290744 [ 290744 ]
            Hide
            Permalink
            Abir Messaikeh added a comment - - edited

            this is as LS-900 , we will close this one and continue follow up on new ticket

            Show
            Abir Messaikeh added a comment - - edited this is as LS-900 , we will close this one and continue follow up on new ticket
            Srishti Kashyap made changes -
            Status Dev Paused [ 10017 ] Implementation in progress [ 10016 ]
            Srishti Kashyap made changes -
            Status Implementation in progress [ 10016 ] To Be Released [ 10400 ]
            Abir Messaikeh made changes -
            Link This issue relates to LS-900 [ LS-900 ]
            Abir Messaikeh made changes -
            Status To Be Released [ 10400 ] Ready for QA [ 10023 ]
            Assignee Srishti Kashyap [ skashyap ] Priyasha Tiwari [ ptiwari ]
            Abir Messaikeh made changes -
            Status Ready for QA [ 10023 ] QA In Progress [ 10015 ]
            Assignee Priyasha Tiwari [ ptiwari ] Abir Messaikeh [ amessaikeh ]
            Abir Messaikeh made changes -
            Status QA In Progress [ 10015 ] Closed [ 6 ]
            Resolution Duplicate [ 3 ]
            Transition Time In Source Status Execution Times Last Executer Last Execution Date
            Open Bug Open Bug Dev Scheduled Dev Scheduled
            		51d 23h 57m 1 Khaled Khalil 09/Jan/26 6:44 AM
            Dev Scheduled Dev Scheduled Implementation in progress Implementation in progress
            		10s 1 Khaled Khalil 09/Jan/26 6:44 AM
            Implementation in progress Implementation in progress Dev Paused Dev Paused
            		6s 1 Khaled Khalil 09/Jan/26 6:44 AM
            Dev Paused Dev Paused Implementation in progress Implementation in progress
            		49d 1h 33m 1 Srishti Kashyap 27/Feb/26 8:17 AM
            Implementation in progress Implementation in progress To Be Released To Be Released
            		10s 1 Srishti Kashyap 27/Feb/26 8:18 AM
            To Be Released To Be Released Ready for QA Ready for QA
            		10m 39s 1 Abir Messaikeh 27/Feb/26 8:28 AM
            Ready for QA Ready for QA QA In Progress QA In Progress
            		2s 1 Abir Messaikeh 27/Feb/26 8:28 AM
            QA In Progress QA In Progress Closed Closed
            		7s 1 Abir Messaikeh 27/Feb/26 8:28 AM
            Subversion JIRA

            Links Hierarchy

            		  Documentation

            Invalid license: EXPIRED

            Cancel

              People

              • Assignee:
                Abir Messaikeh
                Reporter:
                Priyasha Tiwari
              • 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 - 1 week, 3 days, 2 hours, 30 minutes
                  1w 3d 2h 30m

                    Drag and Drop