Details
-
Type:
Bug
-
Status:
Closed
(View Workflow)
-
Priority:
Normal
-
Resolution: Fixed
-
Component/s: NEP
-
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 .
Attachments
Activity
| 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) |
| Component/s | NEP [ 16200 ] |
| Labels | NEP_D |
| 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. |
| 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 |
| Attachment | route report issue.png [ 119704 ] |
| 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 |
| 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 |
| Attachment | site list route report.xlsx [ 119705 ] |
| Assignee | Khaled Khalil [ kkhalil ] | Priyasha Tiwari [ ptiwari ] |
| Assignee | Priyasha Tiwari [ ptiwari ] | Khaled Khalil [ kkhalil ] |
| 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 |
| Attachment | route report issue.png [ 119704 ] |
| Attachment | ROUTE REPORT DL1.png [ 119900 ] | |
| Attachment | ROUTE REPORT DL.png [ 119901 ] |
| 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 . |
| Attachment | Airtel task.xlsx [ 120001 ] |
| Attachment | Airtel task.xlsx [ 120001 ] |
| Attachment | route report discrepancy.png [ 120002 ] |
| 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 . |
| Attachment | site list route report.xlsx [ 119705 ] |
| Summary | Airtel_Route Report not showing all routed sites_Prod_All Circle | Airtel_Route Report not showing all routed sites_DL CIRCLE |
| Summary | Airtel_Route Report not showing all routed sites_DL CIRCLE | Airtel_Route Report not showing all routed sites_Delhi Circle Prod |
-
- 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
-
- Time Spent:
- 1 hour
-
i have shared logs from DL circle with dev team
-
- Time Spent:
- 1 hour
-
shared DL circle logs with dev team .
-
- 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
| Remaining Estimate | 0 minutes [ 0 ] | |
| Time Spent | 6 hours, 30 minutes [ 23400 ] | |
| Worklog Id | 282452 [ 282452 ] |
| 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) |
| Worklog Id | 282452 [ 282452 ] |
-
- 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
| Time Spent | 6 hours, 30 minutes [ 23400 ] | 7 hours, 30 minutes [ 27000 ] |
| Worklog Id | 282545 [ 282545 ] |
| Time Spent | 7 hours, 30 minutes [ 27000 ] | 1 day, 30 minutes [ 30600 ] |
| Worklog Id | 282550 [ 282550 ] |
-
- Time Spent:
- 1 hour
-
Query executed on DL PROD DB — count from circuit service relation table for active version_id is 195.
-
- Time Spent:
- 2 hours
-
Nep Build 3.7.71.522 has been deployed on 177 test and DL DB configured on .177
-
- 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
| Time Spent | 1 day, 30 minutes [ 30600 ] | 1 day, 7 hours, 42 minutes [ 56520 ] |
| Worklog Id | 282610 [ 282610 ] |
| Time Spent | 1 day, 7 hours, 42 minutes [ 56520 ] | 2 days, 4 hours, 42 minutes [ 74520 ] |
| Worklog Id | 282613 [ 282613 ] |
| Time Spent | 2 days, 4 hours, 42 minutes [ 74520 ] | 2 days, 5 hours, 42 minutes [ 78120 ] |
| Worklog Id | 282641 [ 282641 ] |
| Time Spent | 2 days, 5 hours, 42 minutes [ 78120 ] | 2 days, 7 hours, 42 minutes [ 85320 ] |
| Worklog Id | 282643 [ 282643 ] |
| Status | Open Bug [ 10108 ] | Dev Scheduled [ 10014 ] |
| Status | Dev Scheduled [ 10014 ] | Implementation in progress [ 10016 ] |
| Assignee | Khaled Khalil [ kkhalil ] | Srishti Kashyap [ skashyap ] |
| Time Spent | 2 days, 7 hours, 42 minutes [ 85320 ] | 3 days, 4 hours, 42 minutes [ 103320 ] |
| Worklog Id | 282803 [ 282803 ] |
| Worklog Id | 282803 [ 282803 ] |
| Status | Implementation in progress [ 10016 ] | Dev Paused [ 10017 ] |
| Status | Dev Paused [ 10017 ] | Implementation in progress [ 10016 ] |
| Status | Implementation in progress [ 10016 ] | Dev Paused [ 10017 ] |
-
- Time Spent:
- 30 minutes
-
data validation on prod after patch was applied and logs added .
| Time Spent | 3 days, 4 hours, 42 minutes [ 103320 ] | 3 days, 5 hours, 12 minutes [ 105120 ] |
| Worklog Id | 284734 [ 284734 ] |
-
- Time Spent:
- 1 hour
-
shared server logs from DL prod to priyasha for Airtel_Route Report not showing all routed sites_Delhi Circle Prod
-
- Time Spent:
- 1 hour
-
sample cases form test server shared with l3 team
-
- 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.
| Attachment | LS-722 TESTSERVER SAMPLE.png [ 123105 ] | |
| Attachment | LS-722 TEST SAMPLE.png [ 123106 ] |
-
- 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.
-
- Time Spent:
- 1 hour
-
shared AS circle logs for Airtel_Route Report not showing all routed sites_Delhi Circle Prod
-
- Time Spent:
- 1 hour
-
ONE MORE SAMPLE CASE REQUESTED FROM L3 FROM TEST SERVER .. SHARED SAME
| Time Spent | 3 days, 5 hours, 12 minutes [ 105120 ] | 3 days, 6 hours, 12 minutes [ 108720 ] |
| Worklog Id | 285015 [ 285015 ] |
| Time Spent | 3 days, 6 hours, 12 minutes [ 108720 ] | 3 days, 7 hours, 12 minutes [ 112320 ] |
| Worklog Id | 285043 [ 285043 ] |
-
- Time Spent:
- 2 hours
-
NEP_AIRTEL - Build 3.7.71.534 - Successful patch has been deployed on all test servers and DB configured .
-
- 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
| Time Spent | 3 days, 7 hours, 12 minutes [ 112320 ] | 4 days, 6 hours, 42 minutes [ 139320 ] |
| Worklog Id | 285118 [ 285118 ] |
| Time Spent | 4 days, 6 hours, 42 minutes [ 139320 ] | 1 week, 5 hours, 42 minutes [ 164520 ] |
| Worklog Id | 285123 [ 285123 ] |
-
- Time Spent:
- 2 hours
-
applied NEP_AIRTEL - Build 3.7.71.534 - Successful on DL and AP prod .
-
- Time Spent:
- 30 minutes
-
Testing- test platform
| Status | Dev Paused [ 10017 ] | Implementation in progress [ 10016 ] |
| Status | Implementation in progress [ 10016 ] | To Be Released [ 10400 ] |
| Status | To Be Released [ 10400 ] | Ready for QA [ 10023 ] |
| Assignee | Srishti Kashyap [ skashyap ] | Priyasha Tiwari [ ptiwari ] |
| Time Spent | 1 week, 5 hours, 42 minutes [ 164520 ] | 1 week, 6 hours, 42 minutes [ 168120 ] |
| Worklog Id | 285318 [ 285318 ] |
| Time Spent | 1 week, 6 hours, 42 minutes [ 168120 ] | 1 week, 1 day, 42 minutes [ 175320 ] |
| Worklog Id | 285321 [ 285321 ] |
| Time Spent | 1 week, 1 day, 42 minutes [ 175320 ] | 1 week, 1 day, 2 hours, 42 minutes [ 182520 ] |
| Worklog Id | 285334 [ 285334 ] |
| Time Spent | 1 week, 1 day, 2 hours, 42 minutes [ 182520 ] | 1 week, 1 day, 3 hours, 12 minutes [ 184320 ] |
| Worklog Id | 285341 [ 285341 ] |
| Time Spent | 1 week, 1 day, 3 hours, 12 minutes [ 184320 ] | 1 week, 1 day, 4 hours, 12 minutes [ 187920 ] |
| Worklog Id | 285344 [ 285344 ] |
-
- Time Spent:
- 1 hour
-
i have shared DL circle logs to telco team .
-
- Time Spent:
- 1 hour
-
i have shared RB logs for delay import status in AP circle .
| Time Spent | 1 week, 1 day, 4 hours, 12 minutes [ 187920 ] | 1 week, 2 days, 3 hours, 42 minutes [ 214920 ] |
| Worklog Id | 285511 [ 285511 ] |
| Time Spent | 1 week, 2 days, 3 hours, 42 minutes [ 214920 ] | 1 week, 2 days, 4 hours, 42 minutes [ 218520 ] |
| Worklog Id | 285538 [ 285538 ] |
| Time Spent | 1 week, 2 days, 4 hours, 42 minutes [ 218520 ] | 1 week, 2 days, 5 hours, 42 minutes [ 222120 ] |
| Worklog Id | 285543 [ 285543 ] |
-
- Time Spent:
- 2 hours
-
NEP_AIRTEL - Build 3.7.71.534 - Successful has been applied on AP and DL prod.
| Status | Ready for QA [ 10023 ] | QA In Progress [ 10015 ] |
| Status | QA In Progress [ 10015 ] | Closed [ 6 ] |
| Resolution | Fixed [ 1 ] |
| Time Spent | 1 week, 2 days, 5 hours, 42 minutes [ 222120 ] | 1 week, 2 days, 7 hours, 42 minutes [ 229320 ] |
| Worklog Id | 285746 [ 285746 ] |
-
- Time Spent:
- 3 hours
-
NEP_AIRTEL - Build 3.7.71.534 - Successful has been applied on all prod servers .
| Time Spent | 1 week, 2 days, 7 hours, 42 minutes [ 229320 ] | 1 week, 3 days, 2 hours, 42 minutes [ 240120 ] |
| Worklog Id | 286029 [ 286029 ] |
-
- Time Spent:
- 2 hours
-
NEP_AIRTEL - Build 3.7.71.534 - Successful has been deployed on all test server .
| 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 | |||||
|---|---|---|---|---|---|---|---|---|---|
|
23d 22h 43m | 1 | Srishti Kashyap | 07/Nov/25 4:49 AM | |||||
|
7s | 1 | Srishti Kashyap | 07/Nov/25 4:50 AM | |||||
|
3d 4h 44m | 2 | Srishti Kashyap | 11/Nov/25 4:44 AM | |||||
|
24d 17h 59m | 2 | Khaled Khalil | 05/Dec/25 3:34 AM | |||||
|
11s | 1 | Khaled Khalil | 05/Dec/25 3:34 AM | |||||
|
5s | 1 | Khaled Khalil | 05/Dec/25 3:34 AM | |||||
|
6d 1h 53m | 1 | Priyasha Tiwari | 11/Dec/25 5:27 AM | |||||
|
24s | 1 | Priyasha Tiwari | 11/Dec/25 5:28 AM |
|
Links Hierarchy |
Documentation
|
Documentation
7th nov is the timeline shared with the customer after discussing internally