[LS-301] Implementation of New Rule for Node Deletion Post XML Import Created: 18/Mar/25  Updated: 17/Apr/26  Due: 20/Mar/25  Resolved: 26/Nov/25

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

Type: CR Priority: Deferred
Reporter: Priyasha Tiwari Assignee: Priyasha Tiwari
Resolution: Fixed Votes: 0
Labels: None
Σ Remaining Estimate: 0 minutes Remaining Estimate: 0 minutes
Σ Time Spent: 2 weeks, 2 days, 3 hours, 30 minutes Time Spent: 2 weeks, 2 days, 3 hours, 30 minutes
Σ Original Estimate: Not Specified Original Estimate: Not Specified

Attachments: PNG File 1.png     Microsoft Word API Functionality and Test Report.docx     PNG File VLAN.png     PNG File WB ENODE SNAP.PNG    
Sub-Tasks:
Key
Summary
Type
Status
Assignee
LS-542 Implementation of New Rule for Node D... Technical task Open Bug Khaled Khalil  
LS-544 Implementation of New Rule for Node D... Technical task Open Bug Khaled Khalil  
LS-543 Implementation of New Rule for Node D... Technical task Open Bug Khaled Khalil  
Customer:
Airtel India
Planned Start:
Planned End:
Actual Start:
Date of Baselining:

 Description   

We need to implement a new rule to delete data for Nodes (BOARD REPORT ,VLAN REPORT, INVENTORY REPORT ,IDU,IP DATA, TRANSMISSION LINK REPORT ,BTS, eNodeB, gNodeB, SRANBs, Role 2G, Role 4G, Role 5G) where the updated date is not in sync with today's date. This rule should be executed every time after the XML import is completed in each circle and can be modified as per te customer requirement.

Additionally, the deletion process will only proceed if the item quantity is 50 or less (otherwise, it should not be executed.), also we can modify the item quantity and date for the deletion as per the requirement for every report ;



 Comments   
Comment by Anonymous [ 03/Jun/25 ]

Build 3.7.71.463 is released with 50 node deletion restriction for RAN nodes

Comment by Priyasha Tiwari [ 03/Jun/25 ]

kindly confirm whether it is done for all the mention nodes or not ..BOARD REPORT ,VLAN REPORT, INVENTORY REPORT ,IDU,IP DATA, TRANSMISSION LINK REPORT ,BTS, eNodeB, gNodeB, SRANBs, Role 2G, Role 4G, Role 5G)

Comment by Anonymous [ 10/Jun/25 ]

Hi Dear as discussed its done for all RAN nodes and its related configurational attributes.

Comment by Anonymous [ 11/Jun/25 ]

Build 3.7.71.465 is released containing below requested changes
Hi Srishti,

As discussed, we need to update the code to allow the number of nodes to be deleted to be configurable based on customer requirements.

Additionally, please add a condition for date based deletions, so that customer can specify a range like deleting data from the past 10 or 15 days ,as needed.

Comment by Anonymous [ 16/Jul/25 ]

Build 3.7.71.472 released containing idu and other deletion addition to api.

Comment by Priyasha Tiwari [ 17/Jul/25 ]

under testing wl-1day

Comment by Priyasha Tiwari [ 22/Jul/25 ]

This is the condition-based logic we plan to implement, combining date and count rules. Please review and confirm.
first condition to consider the count is limit can be set to true or false
if Condition of count is set to true , below will be the cases:
Case 1: Data older than x days ( x configurable)
If the date is set to delete data older than x days ( Today -X) and the node count is set to Y, then deletion will proceed only if the number of nodes older than ( today-X) is less than Y , else no deletion and warning will be shown in logs
Case 2: Data except for today's date , Duration is set to 0
If we want to delete all data except for today date and the node count is set to Y , then deletion will proceed only if the number of nodes older than ( today-X) is less than Y , else no deletion and warning will be shown in log
If Count Condition is set to false ,the deletion will occur according to the duration set ( older than X days )

Comment by Priyasha Tiwari [ 23/Jul/25 ]

testing completed for patch -3.7.71.472, and found that only RAN nodes data are getting deleted, mw, ip, vlan,idu report no deleteion executed .

Comment by Anonymous [ 28/Jul/25 ]

The build 3.7.71.473 has been released with the updated support for configurable duration and nodeSize parameters.
To trigger the deletion, please use the following API call:
http://localhost:8090/NEP_SERVER/services/airtel/deletion/deleteRanNodes?versionName=Test_IPV6&key=y@8j-bZHqp@teHvVB3-@w?K!R5M?YX&duration=1352&nodeSize=500&isByNodeSize=true
Parameters:
• versionName – Name of the version
• duration – Number of days for which data is eligible for deletion (i.e., Delete all nodes that were last modified before 19-July-2025, today is 25-July-2025, so 6 days ago is 19-July-2025)
• nodeSize – Maximum number of nodes allowed for deletion
• isByNodeSize – Flag to control deletion based on node count (true = limit by node size, false = delete regardless of size)

Comment by Priyasha Tiwari [ 20/Aug/25 ]

this details regarding the API working, shared with the customer ..
Dear Team,
The implementation of the logic for node deletion is now ready for production. The patch has already been applied and tested. Below is the API link that needs to be triggered as required.
http://localhost:8090/NEP_SERVER/services/airtel/deletion/deleteRanNodes?versionName=Test_IPV6&key=y@8j-bZHqp@teHvVB3-@w?K!R5M?YX&duration=1352&nodeSize=500&isByNodeSize=true

All the points mentioned below have been added into the logic. Here is a summary of the API

The deletion process is applicable to all nodes and report types for RAN and MW domains, including - eNodeB, gNodeB, BTS SRANBS,IDU, transmission links, and their sub-elements such as board, inventory, addinfo, IPDATA, interfaces,cells , vlan etc.
Note - The main elements like Nodes and link deleted can also be tracked in the logs.

The deletion criteria can be modified based on requirements. The logic implemented includes-
• Count Condition: The first condition to consider is whether the count limit is set to true or false.
• If Count Condition is set to true, the following cases apply:
Case 1: Data older than X days (X configurable)
o If the deletion is set to remove data older than X days (where the cutoff date is calculated as Today – X days, inclusive of Today) and the node count threshold is Y, deletion will proceed only if the number of nodes older than the cutoff date is less than Y.
o Otherwise, no deletion will occur, and a warning will be logged.

NOTE--_ ( today-X) is where the cutoff date is calculated as Today – X days, inclusive of Today)
Example: If we want to delete data older than 7th August and today’s date is 15th August (inclusive), X will be 9 (i.e., 9 days older data).

Case 2: Delete all data except today’s date (Duration = 0)
o If the deletion is set to remove all data except today’s date and the node count threshold is Y, deletion will proceed only if the number of nodes older than the cutoff date is less than Y.
o Otherwise, no deletion will occur, and a warning will be logged.
• If Count Condition is set to false, deletion will occur according to the configured duration (i.e., older than X days) without checking the node count threshold.

Tracking of deleted element or count for every circle- This can be monitored from the logs provided by the integration team. Keywords such as “Deleted” and “to delete” will help determine the exact number of nodes deleted from the database.

Comment by Anonymous [ 22/Aug/25 ]

Build 3.7.71.479 is released containing fixes for object not found error during deletion of sranbsnode

Comment by Priyasha Tiwari [ 22/Aug/25 ]

under testing , unable to apply the patch for testing due to BO machine issue

Comment by Priyasha Tiwari [ 29/Aug/25 ]

after testing , found out that the only sranbs node are getting deleted .. BTS ENODEB GNODEB nodes are not getting deleted

Comment by Priyasha Tiwari [ 02/Sep/25 ]

after testing the new patch 481 for this bug, its working fine data is now deleting .. but l3 need to share the details regarding the days calculation for this API again ..

Comment by Srishti Kashyap [ 07/Oct/25 ]

Hi Team,
As per the logic implemented in the code, the duration value represents the number of days from today after which data is considered old and eligible for deletion.
So, to delete all GNodeB data before 1st October 2025, we calculate how many days have passed between today (7th October 2025) and 1st October 2025, which is 6 days. Duration = (Today’s date) − (Cut-off date you want to delete before)

Comment by Priyasha Tiwari [ 26/Nov/25 ]

close this ticket

Generated at Fri Apr 17 10:34:36 EEST 2026 using JIRA 6.1.4#6159-sha1:44eaedef2e4a625c6c7183698b2468d4719c20dc.