Details

    • Customer:
      Airtel India

      Description

      the route report count is not correct ,Ran source site showing as routed in RB and not showing in route report under custom reports. L

      sample Site ID from DL prod 51908_DL
      Please check the logic and data source used for route report .

        Activity

        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-15 24:00 (milestone: set planned start date to due date)
        Planned End 2025-10-15 24:00 (milestone: set planned end date to due date)
        Priyasha Tiwari made changes -
        Component/s NEP [ 16200 ]
        Priyasha Tiwari made changes -
        Labels NEP_D
        Priyasha Tiwari made changes -
        Description as checked around 949 ran source site showing as routed in RB and not showing in route report under customer reports. as checked around 949 ran source site showing as routed in RB and not showing in route report under customer reports. List of 949 sites attached with required reports.
        Priyasha Tiwari made changes -
        Description as checked around 949 ran source site showing as routed in RB and not showing in route report under customer reports. List of 949 sites attached with required reports. as checked around 949 ran source site showing as routed in RB and not showing in route report under customer reports. List of 949 sites attached with required reports.

        sample Site ID from gj prod
        GT3242_GJ
        GW6425_GJ
        GT3242_GJ
        GX5777_GJ
        GT4402_GJ
        GT1257_GJ
        GX3206_GJ
        GU1881_GJ
        GX2337_GJ
        GX3785_GJ
        Priyasha Tiwari made changes -
        Attachment route report issue.png [ 119704 ]
        Priyasha Tiwari made changes -
        Description as checked around 949 ran source site showing as routed in RB and not showing in route report under customer reports. List of 949 sites attached with required reports.

        sample Site ID from gj prod
        GT3242_GJ
        GW6425_GJ
        GT3242_GJ
        GX5777_GJ
        GT4402_GJ
        GT1257_GJ
        GX3206_GJ
        GU1881_GJ
        GX2337_GJ
        GX3785_GJ
        as checked around 949 ran source site showing as routed in RB and not showing in route report under customer reports. List of 949 sites attached with required reports.

        sample Site ID from gj prod
        GW1363_GJ
        Priyasha Tiwari made changes -
        Description as checked around 949 ran source site showing as routed in RB and not showing in route report under customer reports. List of 949 sites attached with required reports.

        sample Site ID from gj prod
        GW1363_GJ
        as checked around 949 ran source site showing as routed in RB and not showing in route report under custom reports. List of 949 sites attached with required reports.

        sample Site ID from gj prod
        GW1363_GJ
        Priyasha Tiwari made changes -
        Attachment site list route report.xlsx [ 119705 ]
        Priyasha Tiwari made changes -
        Assignee Khaled Khalil [ kkhalil ] Priyasha Tiwari [ ptiwari ]
        Priyasha Tiwari made changes -
        Assignee Priyasha Tiwari [ ptiwari ] Khaled Khalil [ kkhalil ]
        Priyasha Tiwari made changes -
        Description as checked around 949 ran source site showing as routed in RB and not showing in route report under custom reports. List of 949 sites attached with required reports.

        sample Site ID from gj prod
        GW1363_GJ
        as checked around 949 ran source site showing as routed in RB and not showing in route report under custom reports. List of 949 sites attached with required reports.

        sample Site ID from DL prod 51908_DL
        Priyasha Tiwari made changes -
        Attachment route report issue.png [ 119704 ]
        Priyasha Tiwari made changes -
        Attachment ROUTE REPORT DL1.png [ 119900 ]
        Attachment ROUTE REPORT DL.png [ 119901 ]
        Priyasha Tiwari made changes -
        Description as checked around 949 ran source site showing as routed in RB and not showing in route report under custom reports. List of 949 sites attached with required reports.

        sample Site ID from DL prod 51908_DL
        as checked around 949 ran source site showing as routed in RB and not showing in route report under custom reports. List of 949 sites attached with required reports.

        sample Site ID from DL prod 51908_DL
        Please check the logic and data source used for route report .
        Priyasha Tiwari made changes -
        Attachment Airtel task.xlsx [ 120001 ]
        Priyasha Tiwari made changes -
        Attachment Airtel task.xlsx [ 120001 ]
        Priyasha Tiwari made changes -
        Attachment route report discrepancy.png [ 120002 ]
        Priyasha Tiwari made changes -
        Description as checked around 949 ran source site showing as routed in RB and not showing in route report under custom reports. List of 949 sites attached with required reports.

        sample Site ID from DL prod 51908_DL
        Please check the logic and data source used for route report .
        the route report count is not correct ,Ran source site showing as routed in RB and not showing in route report under custom reports. L

        sample Site ID from DL prod 51908_DL
        Please check the logic and data source used for route report .
        Priyasha Tiwari made changes -
        Attachment site list route report.xlsx [ 119705 ]
        Priyasha Tiwari made changes -
        Summary Airtel_Route Report not showing all routed sites_Prod_All Circle Airtel_Route Report not showing all routed sites_DL CIRCLE
        Priyasha Tiwari made changes -
        Summary Airtel_Route Report not showing all routed sites_DL CIRCLE Airtel_Route Report not showing all routed sites_Delhi Circle Prod
        Hide
        Priyasha Tiwari added a comment -

        7th nov is the timeline shared with the customer after discussing internally

        Show
        Priyasha Tiwari added a comment - 7th nov is the timeline shared with the customer after discussing internally
        Srishti Kashyap logged work - 31/Oct/25 12:00 AM - edited
        • Time Spent:
          6 hours, 30 minutes
           

          checked the issue on jira..checked the related information on PROD application discussed with bessem checking and debugging code for route report at local

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

          i have shared logs from DL circle with dev team

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

          shared DL circle logs with dev team .

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

          checking the local code connecting to DEv to DL clone found circuit traffic table empty checking the code for same also the RB last run is on 26-10-25 checked and iscussed with integration some issue currently with db hence rb not executed also asked if rb deletion related script executed not sure putting a count of circuittraffic query on version basis to integration

        Srishti Kashyap made changes -
        Remaining Estimate 0 minutes [ 0 ]
        Time Spent 6 hours, 30 minutes [ 23400 ]
        Worklog Id 282452 [ 282452 ]
        Srishti Kashyap made changes -
        Baseline Start 2025-10-15 24:00 (set baseline based of initial work logging)
        Baseline End 2025-10-15 24:00 (set baseline based of initial work logging)
        Srishti Kashyap made changes -
        Worklog Id 282452 [ 282452 ]
        Srishti Kashyap logged work - 04/Nov/25 12:00 AM
        • Time Spent:
          5 hours
           

          query returned records do have data in traffic circuit again checking the tables data and tryng to debug the code..reconnected to DL clone checked reports there routes coming proper checking data related in db for clone

        Basant Kumar made changes -
        Time Spent 6 hours, 30 minutes [ 23400 ] 7 hours, 30 minutes [ 27000 ]
        Worklog Id 282545 [ 282545 ]
        Basant Kumar made changes -
        Time Spent 7 hours, 30 minutes [ 27000 ] 1 day, 30 minutes [ 30600 ]
        Worklog Id 282550 [ 282550 ]
        Basant Kumar logged work - 05/Nov/25 12:00 AM
        • Time Spent:
          1 hour
           

          Query executed on DL PROD DB — count from circuit service relation table for active version_id is 195.

        Basant Kumar logged work - 05/Nov/25 12:00 AM
        • Time Spent:
          2 hours
           

          Nep Build 3.7.71.522 has been deployed on 177 test and DL DB configured on .177

        Srishti Kashyap logged work - 05/Nov/25 12:00 AM - edited
        • Time Spent:
          5 hours
           

          found traffic relation table with less records shared query checked the code added tracking logs for further test on PROD as issue not reproducable at test dev platform released patch

        Srishti Kashyap made changes -
        Time Spent 1 day, 30 minutes [ 30600 ] 1 day, 7 hours, 42 minutes [ 56520 ]
        Worklog Id 282610 [ 282610 ]
        Srishti Kashyap made changes -
        Time Spent 1 day, 7 hours, 42 minutes [ 56520 ] 2 days, 4 hours, 42 minutes [ 74520 ]
        Worklog Id 282613 [ 282613 ]
        Basant Kumar made changes -
        Time Spent 2 days, 4 hours, 42 minutes [ 74520 ] 2 days, 5 hours, 42 minutes [ 78120 ]
        Worklog Id 282641 [ 282641 ]
        Basant Kumar made changes -
        Time Spent 2 days, 5 hours, 42 minutes [ 78120 ] 2 days, 7 hours, 42 minutes [ 85320 ]
        Worklog Id 282643 [ 282643 ]
        Hide
        Srishti Kashyap added a comment -

        build 3.7.71.522 is released with tracking logs need to be applied on RJ PROD for further results.Also no RB triggered on RJ from 26 oct due to ongoing db problem as informed by integration

        Show
        Srishti Kashyap added a comment - build 3.7.71.522 is released with tracking logs need to be applied on RJ PROD for further results.Also no RB triggered on RJ from 26 oct due to ongoing db problem as informed by integration
        Srishti Kashyap made changes -
        Status Open Bug [ 10108 ] Dev Scheduled [ 10014 ]
        Srishti Kashyap made changes -
        Status Dev Scheduled [ 10014 ] Implementation in progress [ 10016 ]
        Assignee Khaled Khalil [ kkhalil ] Srishti Kashyap [ skashyap ]
        Srishti Kashyap made changes -
        Time Spent 2 days, 7 hours, 42 minutes [ 85320 ] 3 days, 4 hours, 42 minutes [ 103320 ]
        Worklog Id 282803 [ 282803 ]
        Srishti Kashyap made changes -
        Worklog Id 282803 [ 282803 ]
        Khaled Khalil made changes -
        Status Implementation in progress [ 10016 ] Dev Paused [ 10017 ]
        Srishti Kashyap made changes -
        Status Dev Paused [ 10017 ] Implementation in progress [ 10016 ]
        Srishti Kashyap made changes -
        Status Implementation in progress [ 10016 ] Dev Paused [ 10017 ]
        Priyasha Tiwari logged work - 25/Nov/25 12:00 AM
        • Time Spent:
          30 minutes
           

          data validation on prod after patch was applied and logs added .

        Hide
        Priyasha Tiwari added a comment - - edited

        ISSUE STILL NOT RESOLVED .. ss shared on email

        Show
        Priyasha Tiwari added a comment - - edited ISSUE STILL NOT RESOLVED .. ss shared on email
        Priyasha Tiwari made changes -
        Time Spent 3 days, 4 hours, 42 minutes [ 103320 ] 3 days, 5 hours, 12 minutes [ 105120 ]
        Worklog Id 284734 [ 284734 ]
        Basant Kumar logged work - 28/Nov/25 12:00 AM
        • Time Spent:
          1 hour
           

          shared server logs from DL prod to priyasha for Airtel_Route Report not showing all routed sites_Delhi Circle Prod

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

          sample cases form test server shared with l3 team

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

          checked the logs requested ..rerequested rb logs checked it..shared script for checking traffic circuit relation data..low count ..checking the code..asked telco for sample from test..checking trafficcircuit relation with routes report.

        Priyasha Tiwari made changes -
        Attachment LS-722 TESTSERVER SAMPLE.png [ 123105 ]
        Attachment LS-722 TEST SAMPLE.png [ 123106 ]
        Hide
        Priyasha Tiwari added a comment -

        SAMPLE CASE ADBRI1_AS FORM AS CIRCLE DB CONNECTED TO .177 TEST SERVER SHARED AND SCREENSHOT ATTACHED

        Show
        Priyasha Tiwari added a comment - SAMPLE CASE ADBRI1_AS FORM AS CIRCLE DB CONNECTED TO .177 TEST SERVER SHARED AND SCREENSHOT ATTACHED
        Srishti Kashyap logged work - 02/Dec/25 12:00 AM
        • Time Spent:
          7 hours
           

          checked the sample and debugged it as thinked relation not existing for sample hence not reflecting checking for validatiy wrt to circuits and ranlogical interface debugging the code and logs found exception during apply circuit routes checking that also..connecting dev to sample as circle ,facing gui problem fixed it triggered single rb for sample case relation build node correctly reflecting in routes report.

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

          shared AS circle logs for Airtel_Route Report not showing all routed sites_Delhi Circle Prod

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

          ONE MORE SAMPLE CASE REQUESTED FROM L3 FROM TEST SERVER .. SHARED SAME

        Basant Kumar made changes -
        Time Spent 3 days, 5 hours, 12 minutes [ 105120 ] 3 days, 6 hours, 12 minutes [ 108720 ]
        Worklog Id 285015 [ 285015 ]
        Priyasha Tiwari made changes -
        Time Spent 3 days, 6 hours, 12 minutes [ 108720 ] 3 days, 7 hours, 12 minutes [ 112320 ]
        Worklog Id 285043 [ 285043 ]
        Basant Kumar logged work - 03/Dec/25 12:00 AM
        • Time Spent:
          2 hours
           

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

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

          worked on triggering single rb for node debugged the code ..working correctly checked reports visible in reports..requested logs again and checking for any other excepltion found during apply circuit saving of relation not executed due to exception comparing logs and checking code doing the required changes after discussion with bessem releasing build after commit

        Srishti Kashyap made changes -
        Time Spent 3 days, 7 hours, 12 minutes [ 112320 ] 4 days, 6 hours, 42 minutes [ 139320 ]
        Worklog Id 285118 [ 285118 ]
        Srishti Kashyap made changes -
        Time Spent 4 days, 6 hours, 42 minutes [ 139320 ] 1 week, 5 hours, 42 minutes [ 164520 ]
        Worklog Id 285123 [ 285123 ]
        Basant Kumar logged work - 05/Dec/25 12:00 AM
        • Time Spent:
          2 hours
           

          applied NEP_AIRTEL - Build 3.7.71.534 - Successful on DL and AP prod .

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

          Testing- test platform

        Hide
        added a comment -

        Build 3.7.71.534 contains changes for circuit relation saving which was skipped before.

        Show
        added a comment - Build 3.7.71.534 contains changes for circuit relation saving which was skipped before.
        Khaled Khalil made changes -
        Status Dev Paused [ 10017 ] Implementation in progress [ 10016 ]
        Khaled Khalil 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 Srishti Kashyap [ skashyap ] Priyasha Tiwari [ ptiwari ]
        Basant Kumar made changes -
        Time Spent 1 week, 5 hours, 42 minutes [ 164520 ] 1 week, 6 hours, 42 minutes [ 168120 ]
        Worklog Id 285318 [ 285318 ]
        Basant Kumar made changes -
        Time Spent 1 week, 6 hours, 42 minutes [ 168120 ] 1 week, 1 day, 42 minutes [ 175320 ]
        Worklog Id 285321 [ 285321 ]
        Basant Kumar made changes -
        Time Spent 1 week, 1 day, 42 minutes [ 175320 ] 1 week, 1 day, 2 hours, 42 minutes [ 182520 ]
        Worklog Id 285334 [ 285334 ]
        Priyasha Tiwari made changes -
        Time Spent 1 week, 1 day, 2 hours, 42 minutes [ 182520 ] 1 week, 1 day, 3 hours, 12 minutes [ 184320 ]
        Worklog Id 285341 [ 285341 ]
        Priyasha Tiwari made changes -
        Time Spent 1 week, 1 day, 3 hours, 12 minutes [ 184320 ] 1 week, 1 day, 4 hours, 12 minutes [ 187920 ]
        Worklog Id 285344 [ 285344 ]
        Basant Kumar logged work - 09/Dec/25 12:00 AM
        • Time Spent:
          1 hour
           

          i have shared DL circle logs to telco team .

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

          i have shared RB logs for delay import status in AP circle .

        Srishti Kashyap made changes -
        Time Spent 1 week, 1 day, 4 hours, 12 minutes [ 187920 ] 1 week, 2 days, 3 hours, 42 minutes [ 214920 ]
        Worklog Id 285511 [ 285511 ]
        Basant Kumar made changes -
        Time Spent 1 week, 2 days, 3 hours, 42 minutes [ 214920 ] 1 week, 2 days, 4 hours, 42 minutes [ 218520 ]
        Worklog Id 285538 [ 285538 ]
        Basant Kumar made changes -
        Time Spent 1 week, 2 days, 4 hours, 42 minutes [ 218520 ] 1 week, 2 days, 5 hours, 42 minutes [ 222120 ]
        Worklog Id 285543 [ 285543 ]
        Basant Kumar logged work - 10/Dec/25 12:00 AM
        • Time Spent:
          2 hours
           

          NEP_AIRTEL - Build 3.7.71.534 - Successful has been applied on AP and DL prod.

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

        issue resolved

        Show
        Priyasha Tiwari added a comment - issue resolved
        Priyasha Tiwari made changes -
        Status QA In Progress [ 10015 ] Closed [ 6 ]
        Resolution Fixed [ 1 ]
        Basant Kumar made changes -
        Time Spent 1 week, 2 days, 5 hours, 42 minutes [ 222120 ] 1 week, 2 days, 7 hours, 42 minutes [ 229320 ]
        Worklog Id 285746 [ 285746 ]
        Basant Kumar logged work - 12/Dec/25 12:00 AM
        • Time Spent:
          3 hours
           

          NEP_AIRTEL - Build 3.7.71.534 - Successful has been applied on all prod servers .

        Basant Kumar made changes -
        Time Spent 1 week, 2 days, 7 hours, 42 minutes [ 229320 ] 1 week, 3 days, 2 hours, 42 minutes [ 240120 ]
        Worklog Id 286029 [ 286029 ]
        Basant Kumar logged work - 02/Feb/26 12:00 AM
        • Time Spent:
          2 hours
           

          NEP_AIRTEL - Build 3.7.71.534 - Successful has been deployed on all test server .

        Basant Kumar made changes -
        Time Spent 1 week, 3 days, 2 hours, 42 minutes [ 240120 ] 1 week, 3 days, 4 hours, 42 minutes [ 247320 ]
        Worklog Id 290432 [ 290432 ]
        Transition Time In Source Status Execution Times Last Executer Last Execution Date
        Open Bug Open Bug Dev Scheduled Dev Scheduled
        23d 22h 43m 1 Srishti Kashyap 07/Nov/25 4:49 AM
        Dev Scheduled Dev Scheduled Implementation in progress Implementation in progress
        7s 1 Srishti Kashyap 07/Nov/25 4:50 AM
        Implementation in progress Implementation in progress Dev Paused Dev Paused
        3d 4h 44m 2 Srishti Kashyap 11/Nov/25 4:44 AM
        Dev Paused Dev Paused Implementation in progress Implementation in progress
        24d 17h 59m 2 Khaled Khalil 05/Dec/25 3:34 AM
        Implementation in progress Implementation in progress To Be Released To Be Released
        11s 1 Khaled Khalil 05/Dec/25 3:34 AM
        To Be Released To Be Released Ready for QA Ready for QA
        5s 1 Khaled Khalil 05/Dec/25 3:34 AM
        Ready for QA Ready for QA QA In Progress QA In Progress
        6d 1h 53m 1 Priyasha Tiwari 11/Dec/25 5:27 AM
        QA In Progress QA In Progress Closed Closed
        24s 1 Priyasha Tiwari 11/Dec/25 5:28 AM
        Subversion JIRA

        Links Hierarchy

         Documentation

        Invalid license: EXPIRED

          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, 3 days, 4 hours, 42 minutes
              1w 3d 4h 42m

                Drag and Drop