Details

    • Type: CR CR
    • Status: Closed Closed (View Workflow)
    • Priority: Deferred Deferred
    • Resolution: Fixed
    • Component/s: NEP
    • Labels:
      None Labels
    • Customer:
      Airtel India

      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 ;

      1. API Functionality and Test Report.docx
        394 kB
        Priyasha Tiwari
      1. 1.png
        100 kB
      2. VLAN.png
        56 kB
      3. WB ENODE SNAP.PNG
        98 kB

        Activity

        Hide
        added a comment -

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

        Show
        added a comment - Build 3.7.71.463 is released with 50 node deletion restriction for RAN nodes
        Hide
        Priyasha Tiwari added a comment -

        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)

        Show
        Priyasha Tiwari added a comment - 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)
        Hide
        added a comment -

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

        Show
        added a comment - Hi Dear as discussed its done for all RAN nodes and its related configurational attributes.
        Hide
        added a comment -

        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.

        Show
        added a comment - 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.
        Hide
        added a comment -

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

        Show
        added a comment - Build 3.7.71.472 released containing idu and other deletion addition to api.
        Hide
        Priyasha Tiwari added a comment -

        under testing wl-1day

        Show
        Priyasha Tiwari added a comment - under testing wl-1day
        Hide
        Priyasha Tiwari added a comment -

        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 )

        Show
        Priyasha Tiwari added a comment - 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 )
        Hide
        Priyasha Tiwari added a comment -

        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 .

        Show
        Priyasha Tiwari added a comment - 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 .
        Hide
        added a comment -

        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)

        Show
        added a comment - 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)
        Hide
        Priyasha Tiwari added a comment -

        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.

        Show
        Priyasha Tiwari added a comment - 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.
        Hide
        added a comment -

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

        Show
        added a comment - Build 3.7.71.479 is released containing fixes for object not found error during deletion of sranbsnode
        Hide
        Priyasha Tiwari added a comment -

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

        Show
        Priyasha Tiwari added a comment - under testing , unable to apply the patch for testing due to BO machine issue
        Hide
        Priyasha Tiwari added a comment -

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

        Show
        Priyasha Tiwari added a comment - after testing , found out that the only sranbs node are getting deleted .. BTS ENODEB GNODEB nodes are not getting deleted
        Hide
        Priyasha Tiwari added a comment -

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

        Show
        Priyasha Tiwari added a comment - 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 ..
        Hide
        Srishti Kashyap added a comment -

        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)

        Show
        Srishti Kashyap added a comment - 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)
        Hide
        Priyasha Tiwari added a comment -

        close this ticket

        Show
        Priyasha Tiwari added a comment - close this ticket

          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 - 2 weeks, 2 days, 3 hours, 30 minutes
              2w 2d 3h 30m

                Drag and Drop