L3 Support
  1. L3 Support
  2. LS-937

DUPLICATE CELL ENTRY IN DB VIEW

        Details

        • Customer:
          Airtel India
        • Defect Category:
          Integration

          Description

          DUPLICATE CELL ENTERY IN 5G CELL REPORT DB VIEW,

            Activity

            Ascending order - Click to sort in descending order
            Permalink
            Priyasha Tiwari logged work - 18/Feb/26 12:00 AM
            • Time Spent:
              1 day
               

              validation of deletion script

            Priyasha Tiwari made changes -
            Field Original Value New Value
            Gantt Options Milestone (set to milestone: having a due date but zero effort)
            Planned Start 2026-02-18 24:00 (milestone: set planned start date to due date)
            Planned End 2026-02-18 24:00 (milestone: set planned end date to due date)
            Priyasha Tiwari made changes -
            Labels NEP_D
            Priyasha Tiwari made changes -
            Component/s NEP [ 16200 ]
            Priyasha Tiwari made changes -
            Description DUPLICATE CELL ENTERY IN 5G CELL REPORT DB VIEW,
            Hide
            Permalink
            Priyasha Tiwari added a comment -

            AS DISCUSSED AFTER PATCH 560 DB SCRIPT WE FOUND DUPLICATE CELL ENTRY IN DB VIEW OF AS CIRCLE. COUNT IN NEP 8733 AND IN DB 17466

            Show
            Priyasha Tiwari added a comment - AS DISCUSSED AFTER PATCH 560 DB SCRIPT WE FOUND DUPLICATE CELL ENTRY IN DB VIEW OF AS CIRCLE. COUNT IN NEP 8733 AND IN DB 17466
            Priyasha Tiwari made changes -
            Attachment NEP REPORT AS FOR DB VIEW.png [ 128503 ]
            Attachment DB VIEW AS CIRCLE.jpg [ 128504 ]
            Attachment DB VIEW SS.png [ 128505 ]
            Permalink
            Srishti Kashyap logged work - 19/Feb/26 12:00 AM
            • Time Spent:
              7 hours, 30 minutes
               

              found that the script shared had duplicate in result working on that the result row not duplicate have different insert chnage date tracking issue found duplicacy at cell level in cell for gnodeb..discussed preparing script for the deletion of duplicate cells from db..script created tested ..rleleased for execution

            Khaled Khalil made changes -
            Assignee Khaled Khalil [ kkhalil ] Srishti Kashyap [ skashyap ]
            Priyasha Tiwari made changes -
            Remaining Estimate 0 minutes [ 0 ]
            Time Spent 1 day [ 28800 ]
            Worklog Id 292226 [ 292226 ]
            Priyasha Tiwari made changes -
            Baseline Start 2026-02-18 24:00 (set baseline based of initial work logging)
            Baseline End 2026-02-18 24:00 (set baseline based of initial work logging)
            Hide
            Permalink
            Priyasha Tiwari added a comment -

            CLOSE OPTION NOT VISIBLE

            Show
            Priyasha Tiwari added a comment - CLOSE OPTION NOT VISIBLE
            Priyasha Tiwari made changes -
            Assignee Srishti Kashyap [ skashyap ] Khaled Khalil [ kkhalil ]
            Srishti Kashyap made changes -
            Time Spent 1 day [ 28800 ] 1 day, 7 hours, 30 minutes [ 55800 ]
            Worklog Id 292333 [ 292333 ]
            Srishti Kashyap made changes -
            Status Open Bug [ 10108 ] Dev Scheduled [ 10014 ]
            Srishti Kashyap made changes -
            Assignee Khaled Khalil [ kkhalil ] Srishti Kashyap [ skashyap ]
            Srishti Kashyap made changes -
            Status Dev Scheduled [ 10014 ] Implementation in progress [ 10016 ]
            Hide
            Permalink
            Srishti Kashyap added a comment -

            shared deletion script for deletion of duplicate cell from db

            Show
            Srishti Kashyap added a comment - shared deletion script for deletion of duplicate cell from db
            Srishti Kashyap made changes -
            Status Implementation in progress [ 10016 ] To Be Released [ 10400 ]
            Defect Category Integration [ 11212 ]
            Dev Verification Done Code Review [ 10702 ]
            Attachment 20260219_DELETEdUPLICATECELL5G.txt [ 128909 ]
            Khaled Khalil made changes -
            Status To Be Released [ 10400 ] Ready for QA [ 10023 ]
            Assignee Srishti Kashyap [ skashyap ] Priyasha Tiwari [ ptiwari ]
            Transition Time In Source Status Execution Times Last Executer Last Execution Date
            Open Bug Open Bug Dev Scheduled Dev Scheduled
            		5d 20h 16m 1 Srishti Kashyap 24/Feb/26 5:30 AM
            Dev Scheduled Dev Scheduled Implementation in progress Implementation in progress
            		19s 1 Srishti Kashyap 24/Feb/26 5:30 AM
            Implementation in progress Implementation in progress To Be Released To Be Released
            		47s 1 Srishti Kashyap 24/Feb/26 5:31 AM
            To Be Released To Be Released Ready for QA Ready for QA
            		4h 26m 1 Khaled Khalil 24/Feb/26 9:58 AM
            Subversion JIRA

            Links Hierarchy

            		  Documentation

            Invalid license: EXPIRED

            Cancel

              People

              • Assignee:
                Priyasha Tiwari
                Reporter:
                Priyasha Tiwari
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Due:
                  Created:
                  Updated:
                  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 - 1 day, 7 hours, 30 minutes
                  1d 7h 30m

                    Drag and Drop