L3 Support
  1. L3 Support
  2. LS-711

Airtel_remove duplicate route where FTTH route are created_prod

        Details

        • Customer:
          Airtel India

          Description

          as observed multiple route has been created for the FTTH nodes, the old route should ideally be deleted from the RB report

          In the Site PoP report and Traffic report, multiple PoPs are being created, whereas it should only reflect the FTTH PoP value- As mentioned in the Document the FTTH site is given the priority irrespective of the MW media. In the below snap for a single ran site, there are multiple pop defined and as well as multiple routing path also , ideally the old logic should not reflect as per the requirement from the airtel.

          Please check the sample case mentioned below with screenshot for JK circle prod , Site SCT950_JK.

          1. FTTH 1.png
            24 kB
          2. ftth 2.png
            29 kB
          3. ftth 3.png
            61 kB
          4. ftth4.png
            40 kB
          5. ftth5.png
            23 kB

            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-10-13 24:00 (milestone: set planned start date to due date)
            Planned End 2025-10-13 24:00 (milestone: set planned end date to due date)
            Priyasha Tiwari made changes -
            Description as observed multiple route has been created for the FTTH nodes, the old route should ideally be deleted from the RB report as observed multiple route has been created for the FTTH nodes, the old route should ideally be deleted from the RB report

            In the Site PoP report and Traffic report, multiple PoPs are being created, whereas it should only reflect the FTTH PoP value- As mentioned in the Document the FTTH site is given the priority irrespective of the MW media. In the below snap for a single ran site, there are multiple pop defined and as well as multiple routing path also , ideally the old logic should not reflect as per the requirement from the airtel.

            Please check the sample case mentioned below with screenshot for JK circle prod , Site SCT950_JK.
            Priyasha Tiwari made changes -
            Attachment ftth5.png [ 119503 ]
            Attachment ftth4.png [ 119504 ]
            Attachment ftth 3.png [ 119505 ]
            Attachment ftth 2.png [ 119506 ]
            Attachment FTTH 1.png [ 119507 ]
            Priyasha Tiwari made changes -
            Labels NEP_D
            Hassan Abdine made changes -
            Component/s NEP [ 16200 ]
            Khaled Khalil made changes -
            Assignee Khaled Khalil [ kkhalil ] Bessem Manita [ bmanita ]
            Permalink
            Priyasha Tiwari logged work - 11/Nov/25 12:00 AM
            • Time Spent:
              4 hours
               

              SAMPLE CASES requested by L3 team FROM a SMALL CIRCLE HP or AS as there DB is connected to test server ..

            Priyasha Tiwari made changes -
            Remaining Estimate 0 minutes [ 0 ]
            Time Spent 4 hours [ 14400 ]
            Worklog Id 283153 [ 283153 ]
            Priyasha Tiwari made changes -
            Baseline Start 2025-10-13 24:00 (set baseline based of initial work logging)
            Baseline End 2025-10-13 24:00 (set baseline based of initial work logging)
            Priyasha Tiwari made changes -
            Remaining Estimate 0 minutes [ 0 ] 4 hours [ 14400 ]
            Time Spent 4 hours [ 14400 ] 0 minutes [ 0 ]
            Worklog Id 283153 [ 283153 ]
            Worklog Time Spent 4 hours [ 14400 ]
            Priyasha Tiwari made changes -
            Remaining Estimate 4 hours [ 14400 ] 0 minutes [ 0 ]
            Time Spent 0 minutes [ 0 ] 4 hours [ 14400 ]
            Worklog Id 283155 [ 283155 ]
            Permalink
            Priyasha Tiwari logged work - 26/Nov/25 12:00 AM
            • Time Spent:
              2 hours
               

              logic implementation discussed with customer and iL3 team

            Hide
            Permalink
            Bessem Manita added a comment -

            Dear Priyasha,
            Kindly note that the new API has been implemented in the patch 3.7.71.530.
            Please find the API link below:

            http://NEP_SERVER_IP:NEP_SERVER_PORT/NEP_SERVER/services/airtel/deletion/rb/cleanup/oldroutes?versionName=VERSION_NAME&key=y@8j-bZHqp@teHvVB3-@w?K!R5M?YX&nbDaysWithoutEdit=100

            Parameters:
            versionName: Represents the Network Version Name (e.g., FULL_AP_PROD).
            nbDaysWithoutEdit: Represents the number of days with no changes on a route before it becomes eligible for deletion.

            BR,
            Bessem

            Show
            Bessem Manita added a comment - Dear Priyasha, Kindly note that the new API has been implemented in the patch 3.7.71.530. Please find the API link below: http://NEP_SERVER_IP:NEP_SERVER_PORT/NEP_SERVER/services/airtel/deletion/rb/cleanup/oldroutes?versionName=VERSION_NAME&key=y@8j-bZHqp@teHvVB3-@w?K!R5M?YX&nbDaysWithoutEdit=100 Parameters: versionName: Represents the Network Version Name (e.g., FULL_AP_PROD). nbDaysWithoutEdit: Represents the number of days with no changes on a route before it becomes eligible for deletion. BR, Bessem
            Priyasha Tiwari made changes -
            Time Spent 4 hours [ 14400 ] 6 hours [ 21600 ]
            Worklog Id 284744 [ 284744 ]
            Permalink
            Basant Kumar logged work - 28/Nov/25 12:00 AM
            • Time Spent:
              2 hours
               

              NEP_AIRTEL - Build 3.7.71.530 - Successful has been deployed on all test servers . and DB configured

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

              API for old route deletion testing

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

              shared logs from .37 test for Service routing -Old route deletion requirement

            Basant Kumar made changes -
            Time Spent 6 hours [ 21600 ] 1 day [ 28800 ]
            Worklog Id 285020 [ 285020 ]
            Priyasha Tiwari made changes -
            Time Spent 1 day [ 28800 ] 1 day, 1 hour [ 32400 ]
            Worklog Id 285042 [ 285042 ]
            Permalink
            Priyasha Tiwari logged work - 04/Dec/25 12:00 AM
            • Time Spent:
              2 hours
               

              `sample case from Production shared for 2g tech also,

            Permalink
            Priyasha Tiwari logged work - 05/Dec/25 12:00 AM
            • Time Spent:
              30 minutes
               

              TESTING DONE ON TEST PLATFORM

            Basant Kumar made changes -
            Time Spent 1 day, 1 hour [ 32400 ] 1 day, 2 hours [ 36000 ]
            Worklog Id 285319 [ 285319 ]
            Priyasha Tiwari made changes -
            Time Spent 1 day, 2 hours [ 36000 ] 1 day, 4 hours [ 43200 ]
            Worklog Id 285339 [ 285339 ]
            Priyasha Tiwari made changes -
            Time Spent 1 day, 4 hours [ 43200 ] 1 day, 4 hours, 30 minutes [ 45000 ]
            Worklog Id 285340 [ 285340 ]
            Permalink
            Priyasha Tiwari logged work - 12/Dec/25 12:00 AM
            • Time Spent:
              1 hour
               

              traffic report sample shared with L3

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

              adding insert date and update date in pop site report checked the code have blank report in local checked the code did the changes...checking the dev machine restarting and checking there report.

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

              checked the site pop report , checking the code for traffic report and debugging making changes restarting dev server testing checking...discussed with bessem pop site date are need to be circuit route one not site related changing the related code again after analysing doing ttesting restarting at dev checking committed the code

            Priyasha Tiwari made changes -
            Time Spent 1 day, 4 hours, 30 minutes [ 45000 ] 1 day, 5 hours, 30 minutes [ 48600 ]
            Worklog Id 286013 [ 286013 ]
            Srishti Kashyap made changes -
            Time Spent 1 day, 5 hours, 30 minutes [ 48600 ] 2 days, 30 minutes [ 59400 ]
            Worklog Id 286105 [ 286105 ]
            Srishti Kashyap made changes -
            Worklog Id 286105 [ 286105 ]
            Srishti Kashyap made changes -
            Time Spent 2 days, 30 minutes [ 59400 ] 3 days [ 86400 ]
            Worklog Id 286109 [ 286109 ]
            Permalink
            Basant Kumar logged work - 17/Dec/25 12:00 AM
            • Time Spent:
              2 hours
               

              Build 3.7.71.538 has been applied on all test servers and then configured the DB .

            Basant Kumar made changes -
            Time Spent 3 days [ 86400 ] 3 days, 2 hours [ 93600 ]
            Worklog Id 286330 [ 286330 ]
            Permalink
            Priyasha Tiwari logged work - 19/Dec/25 12:00 AM
            • Time Spent:
              1 hour
               

              testing on test server for patch 538

            Permalink
            Srishti Kashyap logged work - 19/Dec/25 12:00 AM - edited
            • Time Spent:
              1 hour
               

              checked issue raised for site pop report column mismatch

            Bessem Manita made changes -
            Status Open Bug [ 10108 ] Dev Scheduled [ 10014 ]
            Bessem Manita made changes -
            Status Dev Scheduled [ 10014 ] Implementation in progress [ 10016 ]
            Bessem Manita made changes -
            Status Implementation in progress [ 10016 ] To Be Released [ 10400 ]
            Khaled Khalil made changes -
            Status To Be Released [ 10400 ] Ready for QA [ 10023 ]
            Assignee Bessem Manita [ bmanita ] Priyasha Tiwari [ ptiwari ]
            Permalink
            Basant Kumar logged work - 22/Dec/25 12:00 AM
            • Time Spent:
              30 minutes
               

              i have unlocked hpcopy2025 db schema on dev machine .

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

              checked the code connecting dev problem db locked requested unlock did changes and restarted server checking the fixes testing committing

            Priyasha Tiwari made changes -
            Time Spent 3 days, 2 hours [ 93600 ] 3 days, 3 hours [ 97200 ]
            Worklog Id 286612 [ 286612 ]
            Permalink
            Basant Kumar logged work - 23/Dec/25 12:00 AM
            • Time Spent:
              1 hour
               

              i have created the HP DB-clone and shared credentials with dev team .

            Basant Kumar made changes -
            Time Spent 3 days, 3 hours [ 97200 ] 3 days, 3 hours, 30 minutes [ 99000 ]
            Worklog Id 286721 [ 286721 ]
            Srishti Kashyap made changes -
            Time Spent 3 days, 3 hours, 30 minutes [ 99000 ] 3 days, 4 hours, 30 minutes [ 102600 ]
            Worklog Id 287417 [ 287417 ]
            Srishti Kashyap made changes -
            Worklog Id 287417 [ 287417 ]
            Srishti Kashyap made changes -
            Time Spent 3 days, 4 hours, 30 minutes [ 102600 ] 4 days, 4 hours [ 129600 ]
            Worklog Id 287418 [ 287418 ]
            Srishti Kashyap made changes -
            Worklog Id 287418 [ 287418 ]
            Permalink
            Priyasha Tiwari logged work - 30/Dec/25 12:00 AM
            • Time Spent:
              5 hours
               

              TESTING ON TEST SERVER, CALL WITH L3 AND CUSTOMER , FULL RB TRIGGER AND VALIDATION OF OUTCOME AFTERTHAT

            Priyasha Tiwari made changes -
            Status Ready for QA [ 10023 ] QA In Progress [ 10015 ]
            Hide
            Permalink
            Priyasha Tiwari added a comment -

            closed

            Show
            Priyasha Tiwari added a comment - closed
            Priyasha Tiwari made changes -
            Status QA In Progress [ 10015 ] Closed [ 6 ]
            Resolution Fixed [ 1 ]
            Basant Kumar made changes -
            Time Spent 4 days, 4 hours [ 129600 ] 4 days, 5 hours [ 133200 ]
            Worklog Id 287534 [ 287534 ]
            Priyasha Tiwari made changes -
            Time Spent 4 days, 5 hours [ 133200 ] 1 week, 2 hours [ 151200 ]
            Worklog Id 287827 [ 287827 ]
            Permalink
            Priyasha Tiwari logged work - 02/Jan/26 12:00 AM
            • Time Spent:
              4 hours
               

              test case validation for the API and call with L2 and L3 for API execution procedure and post validation of logs with L3

            Permalink
            Basant Kumar logged work - 05/Jan/26 12:00 AM
            • Time Spent:
              1 hour
               

              i have triggered API on .177 server .

            Permalink
            Basant Kumar logged work - 05/Jan/26 12:00 AM
            • Time Spent:
              1 hour
               

              i have triggered API on .177 after that i found error and shared logs to dev team.

            Basant Kumar made changes -
            Time Spent 1 week, 2 hours [ 151200 ] 1 week, 3 hours [ 154800 ]
            Worklog Id 288099 [ 288099 ]
            Basant Kumar made changes -
            Time Spent 1 week, 3 hours [ 154800 ] 1 week, 4 hours [ 158400 ]
            Worklog Id 288318 [ 288318 ]
            Priyasha Tiwari made changes -
            Time Spent 1 week, 4 hours [ 158400 ] 1 week, 1 day [ 172800 ]
            Worklog Id 288411 [ 288411 ]
            Permalink
            Basant Kumar logged work - 09/Jan/26 12:00 AM
            • Time Spent:
              1 hour
               

              i checked the NEP patch status on all airtel test servers after that informed to dev team and retriggered the API on .177 and shared log.

            Basant Kumar made changes -
            Time Spent 1 week, 1 day [ 172800 ] 1 week, 1 day, 1 hour [ 176400 ]
            Worklog Id 288629 [ 288629 ]
            Permalink
            Basant Kumar logged work - 15/Jan/26 12:00 AM
            • Time Spent:
              1 hour
               

              i have triggered API on .177 and monitored logs until completed .

            Permalink
            Basant Kumar logged work - 16/Jan/26 12:00 AM
            • Time Spent:
              1 hour
               

              i have triggered the API for 110 days and after that i monitored the logs and shared on mail .

            Permalink
            Priyasha Tiwari logged work - 16/Jan/26 12:00 AM
            • Time Spent:
              2 hours
               

              testing, pre post validation and internal call with L3

            Basant Kumar made changes -
            Time Spent 1 week, 1 day, 1 hour [ 176400 ] 1 week, 1 day, 2 hours [ 180000 ]
            Worklog Id 289109 [ 289109 ]
            Basant Kumar made changes -
            Time Spent 1 week, 1 day, 2 hours [ 180000 ] 1 week, 1 day, 3 hours [ 183600 ]
            Worklog Id 289116 [ 289116 ]
            Priyasha Tiwari made changes -
            Time Spent 1 week, 1 day, 3 hours [ 183600 ] 1 week, 1 day, 5 hours [ 190800 ]
            Worklog Id 289392 [ 289392 ]
            Permalink
            Basant Kumar logged work - 27/Jan/26 12:00 AM
            • Time Spent:
              1 hour
               

              i have triggered API on .177 after that i have monitored the logs then shared on mail

            Basant Kumar made changes -
            Time Spent 1 week, 1 day, 5 hours [ 190800 ] 1 week, 1 day, 6 hours [ 194400 ]
            Worklog Id 290426 [ 290426 ]
            Transition Time In Source Status Execution Times Last Executer Last Execution Date
            Open Bug Open Bug Dev Scheduled Dev Scheduled
            		70d 7h 19m 1 Bessem Manita 19/Dec/25 1:54 PM
            Dev Scheduled Dev Scheduled Implementation in progress Implementation in progress
            		5s 1 Bessem Manita 19/Dec/25 1:55 PM
            Implementation in progress Implementation in progress To Be Released To Be Released
            		7s 1 Bessem Manita 19/Dec/25 1:55 PM
            To Be Released To Be Released Ready for QA Ready for QA
            		1h 51m 1 Khaled Khalil 19/Dec/25 3:46 PM
            Ready for QA Ready for QA QA In Progress QA In Progress
            		10d 11h 47m 1 Priyasha Tiwari 30/Dec/25 3:33 AM
            QA In Progress QA In Progress Closed Closed
            		14s 1 Priyasha Tiwari 30/Dec/25 3:34 AM
            Subversion JIRA

            Links Hierarchy

            		  Documentation

            Invalid license: EXPIRED

            Cancel

              People

              • Assignee:
                Priyasha Tiwari
                Reporter:
                Priyasha Tiwari
              • 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 - 1 week, 1 day, 6 hours
                  1w 1d 6h

                    Drag and Drop