Details
-
Type:
Bug
-
Status:
Closed
(View Workflow)
-
Resolution: Duplicate
-
Component/s: NEP
-
Labels:None Labels
-
Customer:Airtel India
-
Defect Category:Regression
-
Classification:Req. Tuning
Description
IP data of around 600 node of both SRAN and Enodeb are not getting imported in NEP ,data is available in XML. please check . reference snapshot attached.
Attachments
Issue Links
- relates to
-
LS-788
AIRTEL_IP Count Mismatch in IP Report_ALL PROD
-
Activity
| Field | Original Value | New Value |
|---|---|---|
| Gantt Options | Milestone (set to milestone: having a due date but zero effort) | |
| Planned Start | 2025-04-21 24:00 (milestone: set planned start date to due date) | |
| Planned End | 2025-04-21 24:00 (milestone: set planned end date to due date) |
-
- Time Spent:
- 2 hours
-
details missing asked the telco to provide detailed analysis with sample case to study
As requested, please check whether the related nodes are being imported, as the initial data provided is limited and lacks sufficient detail.
If the nodes are not importing, and the import errors are unclear, kindly share a few sample cases to help me analyse the situation further from my end.
| Assignee | Ankit Bhardwaj [ abhardwaj ] | Srishti Kashyap [ skashyap ] |
| Remaining Estimate | 0 minutes [ 0 ] | |
| Time Spent | 2 hours [ 7200 ] | |
| Worklog Id | 265514 [ 265514 ] |
| Baseline Start | 2025-04-21 24:00 (set baseline based of initial work logging) | |
| Baseline End | 2025-04-21 24:00 (set baseline based of initial work logging) |
-
- Time Spent:
- 4 hours
-
checked the issue checked the error report forwarded the same to telco for analysis
all required details shared on email on 23-04-2025
-
- Time Spent:
- 1 day
-
comparing the data checking the Db requesting permission found data anomaly on logical interface testing on clone making related queries executing them on PROD
-
- Time Spent:
- 1 day
-
debugged the code version active two, logical interface missing in nep existing in nep checking the code and debugging the reports found the error checking on clone DL for the same making amendments query testing on clone releasing the same on PROD
| Time Spent | 2 hours [ 7200 ] | 6 hours [ 21600 ] |
| Worklog Id | 266505 [ 266505 ] |
| Status | Open Bug [ 10108 ] | Dev Scheduled [ 10014 ] |
| Due Date | 21/Apr/25 | 09/May/25 |
| Planned Start | 21/Apr/25 12:00 AM | 29/Apr/25 12:00 AM |
| Planned End | 21/Apr/25 12:00 AM | 09/May/25 12:00 AM |
| Status | Dev Scheduled [ 10014 ] | Implementation in progress [ 10016 ] |
| Status | Implementation in progress [ 10016 ] | To Be Released [ 10400 ] |
| Defect Category | Integration [ 11212 ] | |
| Dev Verification Done | Code Review [ 10702 ] | |
| Classification | Query [ 13700 ] |
| Time Spent | 6 hours [ 21600 ] | 1 day, 6 hours [ 50400 ] |
| Worklog Id | 266508 [ 266508 ] |
| Time Spent | 1 day, 6 hours [ 50400 ] | 2 days, 6 hours [ 79200 ] |
| Worklog Id | 266509 [ 266509 ] |
| Time Spent | 2 days, 6 hours [ 79200 ] | 3 days, 2 hours [ 93600 ] |
| Worklog Id | 266512 [ 266512 ] |
| Status | To Be Released [ 10400 ] | Ready for QA [ 10023 ] |
| Assignee | Srishti Kashyap [ skashyap ] | Priyasha Tiwari [ ptiwari ] |
| Status | Ready for QA [ 10023 ] | QA In Progress [ 10015 ] |
| Status | QA In Progress [ 10015 ] | Closed [ 6 ] |
| Resolution | Fixed [ 1 ] |
-
- Time Spent:
- 3 hours
-
worked on checking data on PROD for making deletion queries for IP
| Time Spent | 3 days, 2 hours [ 93600 ] | 3 days, 5 hours [ 104400 ] |
| Worklog Id | 266835 [ 266835 ] |
-
- Time Spent:
- 4 hours
-
test server not connecting due to large size cant test data, testing test server, taking test with another clone for db script testing analysing and mailing script finally after having a discussion meeting with nazih
-
- Time Spent:
- 1 hour
-
worked with integartion to resolve problem of data not reflecting in dbview
| Time Spent | 3 days, 5 hours [ 104400 ] | 3 days, 6 hours [ 108000 ] |
| Worklog Id | 267014 [ 267014 ] |
| Time Spent | 3 days, 6 hours [ 108000 ] | 4 days, 2 hours [ 122400 ] |
| Worklog Id | 267015 [ 267015 ] |
| Worklog Id | 267015 [ 267015 ] |
-
- Time Spent:
- 5 hours
-
checking the ipdatas with respect to db and generating the queries and sharing the same
-
- Time Spent:
- 4 hours
-
some remaining at DL circle testing for same generation queries for same
updation and deletion queries executed
| Attachment | deletionscript_20250513.txt [ 109300 ] |
| Attachment | updationQueryNodeinterface06052025.txt [ 109301 ] |
-
- Time Spent:
- 2 hours
-
checked the report on all circles mentioned share dthe script checked for manual deletion of same
| Time Spent | 4 days, 2 hours [ 122400 ] | 4 days, 7 hours [ 140400 ] |
| Worklog Id | 267736 [ 267736 ] |
| Time Spent | 4 days, 7 hours [ 140400 ] | 1 week, 3 hours [ 154800 ] |
| Worklog Id | 267759 [ 267759 ] |
| Worklog Id | 267759 [ 267759 ] |
| Time Spent | 1 week, 3 hours [ 154800 ] | 1 week, 5 hours [ 162000 ] |
| Worklog Id | 267762 [ 267762 ] |
| Worklog Id | 267762 [ 267762 ] |
-
- Time Spent:
- 1 hour
-
blank IP coming on some circle checked
| Time Spent | 1 week, 5 hours [ 162000 ] | 1 week, 6 hours [ 165600 ] |
| Worklog Id | 269408 [ 269408 ] |
deletion script not working as required.. the deleted data is reoccurring after a week again .. need to validate the cronjob output and share that with L3 team.
| Assignee | Priyasha Tiwari [ ptiwari ] | Srishti Kashyap [ skashyap ] |
Srishti shall review the API execution to check why IPs are left blank in IP data
As we observed that they belong to deleted RAN nodes
Cronjob -
- XML generation and run
00 20 * * 1,2,3,4,6,7 /product/Airtel/scripts/XML_GENSAV/xmlGenSaveSeq.sh > /product/Airtel/scripts/logs/xml-gen-and-save-$(date +%d-%m-%Y-%H-%M).log
#During DELETION PROCEDURE Import Process
00 21 * * 5 /product/Airtel/scripts/XML_GENSAV/xmlGenSaveSeq.sh > /product/Airtel/scripts/logs/xml-gen-and-save-$(date +%d-%m-%Y-%H-%M).log
As per discussion with Basant, Other deletion procedures are running than API during week end , need to Stop them and monitor if API deletion is not causing such behavior
| Status | Closed [ 6 ] | QA In Progress [ 10015 ] |
| Assignee | Srishti Kashyap [ skashyap ] | Priyasha Tiwari [ ptiwari ] |
-
- Time Spent:
- 5 hours, 30 minutes
-
checked the sample case shared by telco ...it doesnt exist in ipreport no blank in ipdata report for MP..checking for other blank case ipn ipdatav6 report ..asking db permission..releated ip present but nodeinterface is not found checking node update date and other in xml also ipdata related errors and investigating
deletion procedure stopped after that script was run on MP Circle prod , then it was found that node details for some of the ip is getting blank may be due the parent node is getting deleted, l3 will check again how this node are getting deleted when all the deletion procedure are paused.. apart form this point the deletion script is not cleaning the whole data at once
| Status | QA In Progress [ 10015 ] | Reopened [ 4 ] |
| Assignee | Priyasha Tiwari [ ptiwari ] | Khaled Khalil [ kkhalil ] |
| Resolution | Fixed [ 1 ] | Incomplete [ 4 ] |
| Component/s | NEP [ 16200 ] |
| Status | Reopened [ 4 ] | Dev Scheduled [ 10014 ] |
| Assignee | Khaled Khalil [ kkhalil ] | Srishti Kashyap [ skashyap ] |
-
- Time Spent:
- 4 hours
-
checking data from xml for paticular node its ip and interface confirming in nep..node interface present in Nep ...where as ip6 relates to unexisting interface in db..requested RJ circle small circle xml for further checks..goin through the code for interface import
| Time Spent | 1 week, 6 hours [ 165600 ] | 1 week, 1 day, 3 hours, 30 minutes [ 185400 ] |
| Worklog Id | 274303 [ 274303 ] |
-
- Time Spent:
- 1 day
-
xml received..get it copied at test as expiriencing issue in local during import..restarted test server..solved local issue..recreating issue at local doesnt persist ...trying at test ..during debuggging found missing ipdatav6 code..and deletion only for ipdata ip nodes during interface updation..trying to discuss before doing any change
-
- Time Spent:
- 4 hours
-
checked for a sample case for RJ to debug blank for both PROD and test...checked the details most of the blanks in RJ test of virtual interface and on investigation RJ node of ubr idu refrencing virtual interface in current xml in prod where as in report its prefix as loopbackinterface requested the xml from telco containing refrenced node of sample for further debugs
| Time Spent | 1 week, 1 day, 3 hours, 30 minutes [ 185400 ] | 1 week, 1 day, 7 hours, 30 minutes [ 199800 ] |
| Worklog Id | 274801 [ 274801 ] |
| Time Spent | 1 week, 1 day, 7 hours, 30 minutes [ 199800 ] | 1 week, 2 days, 7 hours, 30 minutes [ 228600 ] |
| Worklog Id | 274802 [ 274802 ] |
-
- Time Spent:
- 1 hour
-
get the xml requested for node copied on test server ..the requested xml doesnt contain ipdatav6 for nodes requested xml again..
requested small xml small xml containing all related data(interface,ipdata) for these nodes:RJUBRDHO016,RJUBRHPSC2400 from RJ circle. xml shared doesnt have related ips in ipdatav6 requested again
| Status | Dev Scheduled [ 10014 ] | Implementation in progress [ 10016 ] |
| Status | Implementation in progress [ 10016 ] | Dev Paused [ 10017 ] |
| Time Spent | 1 week, 2 days, 7 hours, 30 minutes [ 228600 ] | 1 week, 3 days, 30 minutes [ 232200 ] |
| Worklog Id | 275104 [ 275104 ] |
| Worklog Id | 275104 [ 275104 ] |
| Time Spent | 1 week, 3 days, 30 minutes [ 232200 ] | 1 week, 3 days, 4 hours, 30 minutes [ 246600 ] |
| Worklog Id | 275106 [ 275106 ] |
-
- Time Spent:
- 5 hours, 30 minutes
-
checked the xml shared by telco for proper data imported xml on local ..restarted service at dev imported there ..debugging no difference in local
requested XML shared on email , awaiting the update on resolution.
| Time Spent | 1 week, 3 days, 4 hours, 30 minutes [ 246600 ] | 1 week, 4 days, 2 hours [ 266400 ] |
| Worklog Id | 275529 [ 275529 ] |
-
- Time Spent:
- 1 day
-
Debugged the code found issue during duplication check for virtual interface method being used for ipdata in ipdatav6 discussed with Bessem and created the similar methods for ipdatav6
-
- Time Spent:
- 6 hours, 30 minutes
-
Did testing after deleting all ipv6 multiple import over import
-
- Time Spent:
- 4 hours
-
tested for creation of blank formation for ipdata4 also
| Status | Dev Paused [ 10017 ] | Implementation in progress [ 10016 ] |
| Time Spent | 1 week, 4 days, 2 hours [ 266400 ] | 2 weeks, 2 hours [ 295200 ] |
| Worklog Id | 276108 [ 276108 ] |
| Time Spent | 2 weeks, 2 hours [ 295200 ] | 2 weeks, 1 day, 30 minutes [ 318600 ] |
| Worklog Id | 276109 [ 276109 ] |
| Worklog Id | 276109 [ 276109 ] |
| Time Spent | 2 weeks, 1 day, 30 minutes [ 318600 ] | 2 weeks, 1 day, 4 hours, 30 minutes [ 333000 ] |
| Worklog Id | 276110 [ 276110 ] |
Build 3.7.71.482 released with change in checking used ipv6 in repo, previously ipv4 is being checked in code and if not found error being thrown and ipdataV6 being set to null wrt to virtual interface.Also the code was Updating oldManagementInterface1 with the new (ipData orV6) — then immediately it sets the same virtualInterfaceToSave again causing the inconsistency.
| Status | Implementation in progress [ 10016 ] | To Be Released [ 10400 ] |
| Defect Category | Integration [ 11212 ] | Regression [ 11213 ] |
| Classification | Query [ 13700 ] | Req. Tuning [ 13204 ] |
| Status | To Be Released [ 10400 ] | Ready for QA [ 10023 ] |
| Assignee | Srishti Kashyap [ skashyap ] | Priyasha Tiwari [ ptiwari ] |
under testing, testing involves mutliple import of XML in test DB timeline -04-09
| Time Spent | 2 weeks, 1 day, 4 hours, 30 minutes [ 333000 ] | 2 weeks, 1 day, 6 hours, 30 minutes [ 340200 ] |
| Worklog Id | 276305 [ 276305 ] |
-
- Time Spent:
- 30 minutes
-
discussion with srishti
-
- Time Spent:
- 30 minutes
-
checked the deletion of ipv6 at .37 ,only ipdata v4 deletion query shared by telco shared ipv6 also
| Time Spent | 2 weeks, 1 day, 6 hours, 30 minutes [ 340200 ] | 2 weeks, 1 day, 7 hours, 30 minutes [ 343800 ] |
| Worklog Id | 276403 [ 276403 ] |
| Time Spent | 2 weeks, 1 day, 7 hours, 30 minutes [ 343800 ] | 2 weeks, 2 days [ 345600 ] |
| Worklog Id | 276405 [ 276405 ] |
| Assignee | Priyasha Tiwari [ ptiwari ] | Srishti Kashyap [ skashyap ] |
| Time Spent | 2 weeks, 2 days [ 345600 ] | 2 weeks, 2 days, 30 minutes [ 347400 ] |
| Worklog Id | 276422 [ 276422 ] |
-
- Time Spent:
- 30 minutes
-
testing and discussion with L3
| Status | Ready for QA [ 10023 ] | QA In Progress [ 10015 ] |
| Assignee | Srishti Kashyap [ skashyap ] | Priyasha Tiwari [ ptiwari ] |
in test server the script executed , all blank IP was removed then after this we re imported the new XML to check if the blank entries are occuring or not.. so the result is that after xml import the balnk entry are appering for same report are attched for working.
| Status | QA In Progress [ 10015 ] | Reopened [ 4 ] |
| Due Date | 09/May/25 | 11/Sep/25 |
| Assignee | Priyasha Tiwari [ ptiwari ] | Khaled Khalil [ kkhalil ] |
| Resolution | Incomplete [ 4 ] | Not Fixed [ 10200 ] |
| Attachment | ipv6 after script.csv [ 117009 ] | |
| Attachment | ipv4 report after script.csv [ 117010 ] | |
| Attachment | IPV6 AFTER SCRIPT AND RE-IMPORT.csv [ 117011 ] | |
| Attachment | IPV4 after Reimport.csv [ 117012 ] |
| Planned End | 2025-05-09 24:00 | 2025-09-11 24:00 (auto-generated by shift of due date) |
also attach the updated script that was shared on mail for both ipv4 and v6
| Time Spent | 2 weeks, 2 days, 30 minutes [ 347400 ] | 2 weeks, 2 days, 1 hour [ 349200 ] |
| Worklog Id | 276525 [ 276525 ] |
Build 3.7.71.486 is released containing file committed with changes.
| Assignee | Khaled Khalil [ kkhalil ] | Priyasha Tiwari [ ptiwari ] |
| Status | Reopened [ 4 ] | Dev Scheduled [ 10014 ] |
| Status | Dev Scheduled [ 10014 ] | Implementation in progress [ 10016 ] |
| Assignee | Priyasha Tiwari [ ptiwari ] | Khaled Khalil [ kkhalil ] |
| Status | Implementation in progress [ 10016 ] | To Be Released [ 10400 ] |
| Status | To Be Released [ 10400 ] | Ready for QA [ 10023 ] |
| Assignee | Khaled Khalil [ kkhalil ] | Priyasha Tiwari [ ptiwari ] |
not on customer priority list, will check this after service routing topic are closed
-
- Time Spent:
- 7 hours
-
checked the issue found duplicacy on ipdata with respect to nodeinetrface on prod checked in db checking at local found duplicacy in ipdata trying to check the ipdata code
-
- Time Spent:
- 3 hours, 30 minutes
-
discussed issue with marwan as suggested by him to do chnage in physicalconf and do duplicacy testing by importing before and after change in new version so proceeding to that
| Time Spent | 2 weeks, 2 days, 1 hour [ 349200 ] | 2 weeks, 3 days [ 374400 ] |
| Worklog Id | 284265 [ 284265 ] |
| Time Spent | 2 weeks, 3 days [ 374400 ] | 2 weeks, 3 days, 3 hours, 30 minutes [ 387000 ] |
| Worklog Id | 284267 [ 284267 ] |
| Worklog Id | 284267 [ 284267 ] |
| Status | Ready for QA [ 10023 ] | QA In Progress [ 10015 ] |
new ticket ls-788 for this issue
| Status | QA In Progress [ 10015 ] | Closed [ 6 ] |
| Resolution | Not Fixed [ 10200 ] | Duplicate [ 3 ] |
| Transition | Time In Source Status | Execution Times | Last Executer | Last Execution Date | |||||
|---|---|---|---|---|---|---|---|---|---|
|
15d 18h 51m | 1 | Srishti Kashyap | 07/May/25 4:27 AM | |||||
|
76d 8h 10m | 1 | Abir Messaikeh | 23/Jul/25 2:52 PM | |||||
|
11s | 1 | Srishti Kashyap | 20/Aug/25 9:14 AM | |||||
|
11d 23h 29m | 1 | Khaled Khalil | 01/Sep/25 8:44 AM | |||||
|
20d 19h 16m | 2 | Priyasha Tiwari | 05/Sep/25 11:37 AM | |||||
|
18d 5h 4m | 2 | Khaled Khalil | 23/Sep/25 2:16 PM | |||||
|
6d 20h 42m | 3 | Khaled Khalil | 23/Sep/25 2:16 PM | |||||
|
19h 46m | 3 | Khaled Khalil | 23/Sep/25 2:16 PM | |||||
|
6h 15m | 3 | Khaled Khalil | 23/Sep/25 2:16 PM | |||||
|
110d 23h 33m | 3 | Priyasha Tiwari | 08/Jan/26 9:47 AM | |||||
|
1m 25s | 2 | Priyasha Tiwari | 08/Jan/26 9:48 AM |
|
Links Hierarchy |
 Documentation
|
asked integration to run the configuration cleanup on the DL circle and restart the service.
@Priyasha Tiwari, please check the system post-cleanup and restart. Also, verify whether the related nodes are being imported successfully or not.