Details

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

      1. deletionscript_20250513.txt
        0.5 kB
        Srishti Kashyap
      2. IPV4 after Reimport.csv
        8.34 MB
        Priyasha Tiwari
      3. ipv4 report after script.csv
        8.06 MB
        Priyasha Tiwari
      4. ipv6 after script.csv
        1.85 MB
        Priyasha Tiwari
      5. IPV6 AFTER SCRIPT AND RE-IMPORT.csv
        3.00 MB
        Priyasha Tiwari
      6. updationQueryNodeinterface06052025.txt
        0.6 kB
        Srishti Kashyap
      1. 5744dca4-6300-498c-a40e-82073433471f.jpg
        76 kB
      2. fcd08b09-5833-43fc-bfa5-adc82bf0ba40.jpg
        79 kB

      Issue Links

        Activity

        Hide
        Srishti Kashyap added a comment -

        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.

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

        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.

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

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

        Show
        Priyasha Tiwari added a comment - all required details shared on email on 23-04-2025
        Hide
        Srishti Kashyap added a comment -

        updation and deletion queries executed

        Show
        Srishti Kashyap added a comment - updation and deletion queries executed
        Hide
        Priyasha Tiwari added a comment -

        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.

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

        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

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

        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

        Show
        Abir Messaikeh added a comment - 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
        Hide
        Priyasha Tiwari added a comment - - edited

        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

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

        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

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

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

        Show
        Priyasha Tiwari added a comment - requested XML shared on email , awaiting the update on resolution.
        Hide
        Srishti Kashyap added a comment - - edited

        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.

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

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

        Show
        Priyasha Tiwari added a comment - under testing, testing involves mutliple import of XML in test DB timeline -04-09
        Hide
        Priyasha Tiwari added a comment -

        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.

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

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

        Show
        Priyasha Tiwari added a comment - also attach the updated script that was shared on mail for both ipv4 and v6
        Hide
        Srishti Kashyap added a comment -

        Build 3.7.71.486 is released containing file committed with changes.

        Show
        Srishti Kashyap added a comment - Build 3.7.71.486 is released containing file committed with changes.
        Hide
        Priyasha Tiwari added a comment -

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

        Show
        Priyasha Tiwari added a comment - not on customer priority list, will check this after service routing topic are closed
        Hide
        Priyasha Tiwari added a comment -

        new ticket ls-788 for this issue

        Show
        Priyasha Tiwari added a comment - new ticket ls-788 for this issue

          People

          • Assignee:
            Priyasha Tiwari
            Reporter:
            Priyasha Tiwari
          • Votes:
            0 Vote for this issue
            Watchers:
            3 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, 3 days, 3 hours, 30 minutes
              2w 3d 3h 30m

                Drag and Drop