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

        Srishti Kashyap logged work - 23/Apr/25 12:00 AM
        • Time Spent:
          2 hours
           

          details missing asked the telco to provide detailed analysis with sample case to study

        Srishti Kashyap logged work - 28/Apr/25 12:00 AM
        • Time Spent:
          4 hours
           

          checked the issue checked the error report forwarded the same to telco for analysis

        Srishti Kashyap logged work - 30/Apr/25 12:00 AM
        • 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

        Srishti Kashyap logged work - 05/May/25 12:00 AM
        • Time Spent:
          4 hours
           

          checking the issue

        Srishti Kashyap logged work - 06/May/25 12:00 AM
        • 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

        Srishti Kashyap logged work - 12/May/25 12:00 AM
        • Time Spent:
          3 hours
           

          worked on checking data on PROD for making deletion queries for IP

        Srishti Kashyap logged work - 13/May/25 12:00 AM - edited
        • 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

        Srishti Kashyap logged work - 14/May/25 12:00 AM
        • Time Spent:
          1 hour
           

          worked with integartion to resolve problem of data not reflecting in dbview

        Srishti Kashyap logged work - 16/May/25 12:00 AM
        • Time Spent:
          5 hours
           

          checking the ipdatas with respect to db and generating the queries and sharing the same

        Srishti Kashyap logged work - 19/May/25 12:00 AM - edited
        • Time Spent:
          4 hours
           

          some remaining at DL circle testing for same generation queries for same

        Srishti Kashyap logged work - 22/May/25 12:00 AM - edited
        • Time Spent:
          2 hours
           

          checked the report on all circles mentioned share dthe script checked for manual deletion of same

        Srishti Kashyap logged work - 12/Jun/25 12:00 AM
        • Time Spent:
          1 hour
           

          blank IP coming on some circle checked

        Srishti Kashyap logged work - 13/Aug/25 12:00 AM
        • 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

        Srishti Kashyap logged work - 14/Aug/25 12:00 AM
        • 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

        Srishti Kashyap logged work - 18/Aug/25 12:00 AM
        • 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

        Srishti Kashyap logged work - 19/Aug/25 12:00 AM
        • 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

        Srishti Kashyap logged work - 20/Aug/25 12:00 AM - edited
        • 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..

        Srishti Kashyap logged work - 22/Aug/25 12:00 AM
        • 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

        Srishti Kashyap logged work - 28/Aug/25 12:00 AM
        • 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

        Srishti Kashyap logged work - 29/Aug/25 12:00 AM - edited
        • Time Spent:
          6 hours, 30 minutes
           

          Did testing after deleting all ipv6 multiple import over import

        Srishti Kashyap logged work - 01/Sep/25 12:00 AM
        • Time Spent:
          4 hours
           

          tested for creation of blank formation for ipdata4 also

        Priyasha Tiwari logged work - 02/Sep/25 12:00 AM
        • Time Spent:
          2 hours
           

          testing

        Priyasha Tiwari logged work - 03/Sep/25 12:00 AM
        • Time Spent:
          1 hour
           

          validation and import

        Priyasha Tiwari logged work - 04/Sep/25 12:00 AM
        • Time Spent:
          30 minutes
           

          discussion with srishti

        Srishti Kashyap logged work - 04/Sep/25 12:00 AM
        • Time Spent:
          30 minutes
           

          checked the deletion of ipv6 at .37 ,only ipdata v4 deletion query shared by telco shared ipv6 also

        Priyasha Tiwari logged work - 05/Sep/25 12:00 AM
        • Time Spent:
          30 minutes
           

          testing and discussion with L3

        Srishti Kashyap logged work - 20/Nov/25 12:00 AM
        • 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

        Srishti Kashyap logged work - 21/Nov/25 12:00 AM - edited
        • 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

          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