[LS-354] IP data report issue Created: 21/Apr/25  Updated: 08/Jan/26  Due: 11/Sep/25  Resolved: 08/Jan/26

Status: Closed
Project: L3 Support
Component/s: NEP
Affects Version/s: None
Fix Version/s: None

Type: Bug
Reporter: Priyasha Tiwari Assignee: Priyasha Tiwari
Resolution: Duplicate Votes: 0
Labels: None
Remaining Estimate: 0 minutes
Time Spent: 2 weeks, 3 days, 3 hours, 30 minutes
Original Estimate: Not Specified

Attachments: JPEG File 5744dca4-6300-498c-a40e-82073433471f.jpg     File IPV4 after Reimport.csv     File IPV6 AFTER SCRIPT AND RE-IMPORT.csv     Text File deletionscript_20250513.txt     JPEG File fcd08b09-5833-43fc-bfa5-adc82bf0ba40.jpg     File ipv4 report after script.csv     File ipv6 after script.csv     Text File updationQueryNodeinterface06052025.txt    
Issue Links:
Relates
relates to LS-788 AIRTEL_IP Count Mismatch in IP Report... Closed
Customer:
Airtel India
Planned Start:
Planned End:
Defect Category: Regression
Classification: Req. Tuning
Actual Start:
Date of Baselining:

 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.



 Comments   
Comment by Srishti Kashyap [ 22/Apr/25 ]

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.

Comment by Srishti Kashyap [ 23/Apr/25 ]

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.

Comment by Priyasha Tiwari [ 28/Apr/25 ]

all required details shared on email on 23-04-2025

Comment by Srishti Kashyap [ 19/May/25 ]

updation and deletion queries executed

Comment by Priyasha Tiwari [ 17/Jul/25 ]

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.

Comment by Priyasha Tiwari [ 17/Jul/25 ]

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 -

  1. 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

Comment by Abir Messaikeh [ 23/Jul/25 ]

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

Comment by Priyasha Tiwari [ 13/Aug/25 ]

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

Comment by Srishti Kashyap [ 20/Aug/25 ]

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

Comment by Priyasha Tiwari [ 22/Aug/25 ]

requested XML shared on email , awaiting the update on resolution.

Comment by Srishti Kashyap [ 02/Sep/25 ]

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.

Comment by Priyasha Tiwari [ 02/Sep/25 ]

under testing, testing involves mutliple import of XML in test DB timeline -04-09

Comment by Priyasha Tiwari [ 05/Sep/25 ]

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.

Comment by Priyasha Tiwari [ 05/Sep/25 ]

also attach the updated script that was shared on mail for both ipv4 and v6

Comment by Srishti Kashyap [ 09/Sep/25 ]

Build 3.7.71.486 is released containing file committed with changes.

Comment by Priyasha Tiwari [ 08/Oct/25 ]

not on customer priority list, will check this after service routing topic are closed

Comment by Priyasha Tiwari [ 08/Jan/26 ]

new ticket ls-788 for this issue

Generated at Fri Apr 17 12:06:56 EEST 2026 using JIRA 6.1.4#6159-sha1:44eaedef2e4a625c6c7183698b2468d4719c20dc.