L3 Support
  1. L3 Support
  2. LS-917

NEW Attribute to add in 5g cell report SSB frequency

        Details

        • Customer:
          Airtel India

          Description

          TO ADD NEW ATTRIBUTE TO 5 CELL REPORT (SSB FREQUENCY).. ADD THIS DATA IN LAST OF THIS REPORT

          The Attribute type is a number (Long)
          Add the attribute to the model (and share it with AI team for parsing)
          The new parameter shall be considered in:
          Import from XML/CSV for 5G cells
          Reports of 5G cells
          Edit Panels OF 5G cells
          DB Views: 5G_cell_report

          1. File
            20260216_V_5G_CELL_REPORT_DBVIEW.sql
            5 kB
            Marwan Kanaan
          2. File
            Ericsson_xml.rar
            834 kB
            Priyasha Tiwari
          3. File
            Nokia_xml.rar
            1.08 MB
            Priyasha Tiwari

            Activity

            Ascending order - Click to sort in descending order
            Permalink
            Priyasha Tiwari logged work - 02/Feb/26 12:00 AM
            • Time Spent:
              4 hours
               

              NEW REQUIREMENT ANALYSIS

            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-04 24:00 (milestone: set planned start date to due date)
            Planned End 2026-02-04 24:00 (milestone: set planned end date to due date)
            Priyasha Tiwari made changes -
            Labels DEV
            Priyasha Tiwari made changes -
            Component/s NEP [ 16200 ]
            Priyasha Tiwari made changes -
            Labels DEV NEP_D
            Priyasha Tiwari made changes -
            Description WE NEED A NEW ADDITION OF COLUMN WITH HEADER "SSB FREQUENCY" AT THE END OF THE REPORT . TO ADD NEW ATTRIUTE TO 5 CELL REPORT (SSB FREQUENCY).. N
            Priyasha Tiwari made changes -
            Description TO ADD NEW ATTRIUTE TO 5 CELL REPORT (SSB FREQUENCY).. N TO ADD NEW ATTRIUTE TO 5 CELL REPORT (SSB FREQUENCY).. ADD THIS DATA IN LAST OF THIS REPORT

            The Attribute type is a number (Long)
            Add the attribute to the model (and share it with AI team for parsing)
            The new parameter shall be considered in:
            Import from XML/CSV for 5G cells
            Reports of 5G cells
            Edit Panels OF 5G cells
            DB Views: 5G_cell_report
            Hide
            Permalink
            Marwan Kanaan added a comment -

            this is a CR not a bug

            Show
            Marwan Kanaan added a comment - this is a CR not a bug
            Abir Messaikeh made changes -
            Issue Type Bug [ 1 ] CR [ 10900 ]
            Workflow Mobinets_Dev_BugWF_J4.4 [ 204105 ] Mobinets_Dev_WF_J4.4 [ 204107 ]
            Status Open Bug [ 10108 ] Opened [ 1 ]
            Priyasha Tiwari made changes -
            Summary SSB FREQUENCY COLUMN IN 5G CELL REPORT NEW Attribute to add in 5g cell report SSB frequency
            Permalink
            Srishti Kashyap logged work - 05/Feb/26 12:00 AM - edited
            • Time Spent:
              1 hour
               

              worked and added the column for ai to work on

            Priyasha Tiwari made changes -
            Remaining Estimate 0 minutes [ 0 ]
            Time Spent 4 hours [ 14400 ]
            Worklog Id 290705 [ 290705 ]
            Priyasha Tiwari made changes -
            Baseline Start 2026-02-04 24:00 (set baseline based of initial work logging)
            Baseline End 2026-02-04 24:00 (set baseline based of initial work logging)
            Priyasha Tiwari made changes -
            Status Opened [ 1 ] Need More Info [ 10011 ]
            Priyasha Tiwari made changes -
            Status Need More Info [ 10011 ] Opened [ 1 ]
            Hide
            Permalink
            Srishti Kashyap added a comment -

            Hi Dear
            Build 3.7.71.556 is release with attribute ssbFrequency added in model of 5g cell.

            Show
            Srishti Kashyap added a comment - Hi Dear Build 3.7.71.556 is release with attribute ssbFrequency added in model of 5g cell.
            Khaled Khalil made changes -
            Assignee Khaled Khalil [ kkhalil ] Srishti Kashyap [ skashyap ]
            Khaled Khalil made changes -
            Status Opened [ 1 ] Pending Requirements [ 10300 ]
            Khaled Khalil made changes -
            Status Pending Requirements [ 10300 ] Pending Design Session [ 10112 ]
            Assignee Srishti Kashyap [ skashyap ] Khaled Khalil [ kkhalil ]
            Khaled Khalil made changes -
            Status Pending Design Session [ 10112 ] Dev Scheduled [ 10014 ]
            Assignee Khaled Khalil [ kkhalil ] Srishti Kashyap [ skashyap ]
            Khaled Khalil made changes -
            Status Dev Scheduled [ 10014 ] Implementation in progress [ 10016 ]
            Assignee Srishti Kashyap [ skashyap ] Khaled Khalil [ kkhalil ]
            Khaled Khalil made changes -
            Assignee Khaled Khalil [ kkhalil ] Srishti Kashyap [ skashyap ]
            Khaled Khalil made changes -
            Status Implementation in progress [ 10016 ] To Be Released [ 10400 ]
            Khaled Khalil made changes -
            Status To Be Released [ 10400 ] Ready for QA [ 10023 ]
            Assignee Srishti Kashyap [ skashyap ] Priyasha Tiwari [ ptiwari ]
            Permalink
            Marwan Kanaan logged work - 12/Feb/26 12:00 AM
            • Time Spent:
              2 hours
               

              implementation done and handed to srishti to test it

            Permalink
            Priyasha Tiwari logged work - 12/Feb/26 12:00 AM
            • Time Spent:
              30 minutes
               

              CALL WITH L3 TEAM,

            Abir Messaikeh made changes -
            Status Ready for QA [ 10023 ] QA In Progress [ 10015 ]
            Assignee Priyasha Tiwari [ ptiwari ] Abir Messaikeh [ amessaikeh ]
            Abir Messaikeh made changes -
            Status QA In Progress [ 10015 ] Bug/s Found [ 10208 ]
            Hide
            Permalink
            Abir Messaikeh added a comment -

            incomplete

            Show
            Abir Messaikeh added a comment - incomplete
            Khaled Khalil made changes -
            Description TO ADD NEW ATTRIUTE TO 5 CELL REPORT (SSB FREQUENCY).. ADD THIS DATA IN LAST OF THIS REPORT

            The Attribute type is a number (Long)
            Add the attribute to the model (and share it with AI team for parsing)
            The new parameter shall be considered in:
            Import from XML/CSV for 5G cells
            Reports of 5G cells
            Edit Panels OF 5G cells
            DB Views: 5G_cell_report             		TO ADD NEW ATTRIBUTE TO 5 CELL REPORT (SSB FREQUENCY).. ADD THIS DATA IN LAST OF THIS REPORT

            The Attribute type is a number (Long)
            Add the attribute to the model (and share it with AI team for parsing)
            The new parameter shall be considered in:
            Import from XML/CSV for 5G cells
            Reports of 5G cells
            Edit Panels OF 5G cells
            DB Views: 5G_cell_report
            Khaled Khalil made changes -
            Assignee Abir Messaikeh [ amessaikeh ] Marwan Kanaan [ mkanaan ]
            Priyasha Tiwari made changes -
            Attachment Nokia_xml.rar [ 128109 ]
            Attachment Ericsson_xml.rar [ 128110 ]
            Hide
            Permalink
            Priyasha Tiwari added a comment -

            AI patch releases, model attribute only added to database, all other changes to be done

            Import from XML/CSV for 5G cells
            Reports of 5G cells
            Edit Panels OF 5G cells
            DB Views: 5G_cell_report

            Show
            Priyasha Tiwari added a comment - AI patch releases, model attribute only added to database, all other changes to be done Import from XML/CSV for 5G cells Reports of 5G cells Edit Panels OF 5G cells DB Views: 5G_cell_report
            Hide
            Permalink
            Marwan Kanaan added a comment - - edited

            Dear @Priyasha Tiwari,

            The patch has been handed over to Srishti for testing on the DB clone environment, as my local schema currently has significant missing data.

            Once the DB view is delivered by the Integration team, I will proceed with updating it accordingly.

            Best Regards,
            Marwan Kanaan I Software Developer

            Show
            Marwan Kanaan added a comment - - edited Dear @Priyasha Tiwari, The patch has been handed over to Srishti for testing on the DB clone environment, as my local schema currently has significant missing data. Once the DB view is delivered by the Integration team, I will proceed with updating it accordingly. Best Regards, Marwan Kanaan I Software Developer
            Marwan Kanaan made changes -
            Assignee Marwan Kanaan [ mkanaan ] Srishti Kashyap [ skashyap ]
            Marwan Kanaan made changes -
            Time Spent 4 hours [ 14400 ] 6 hours [ 21600 ]
            Worklog Id 291321 [ 291321 ]
            Permalink
            Basant Kumar logged work - 13/Feb/26 12:00 AM - edited
            • Time Spent:
              1 hour
               

              i have share 5g cell report from AS circle .

            Priyasha Tiwari made changes -
            Time Spent 6 hours [ 21600 ] 6 hours, 30 minutes [ 23400 ]
            Worklog Id 291404 [ 291404 ]
            Permalink
            Priyasha Tiwari logged work - 15/Feb/26 12:00 AM
            • Time Spent:
              4 hours
               

              LATEST PATCH 9 VALIDATION, INCLUDED XML IMPORT , CORDINATING WITH L2 FOR SERVER DOWN ISSUE and logs check for L3

            Permalink
            Marwan Kanaan logged work - 16/Feb/26 12:00 AM - edited
            • Time Spent:
              2 hours
               

              checks logs provide the alter query

              update the db view

            Permalink
            Priyasha Tiwari logged work - 16/Feb/26 12:00 AM - edited
            • Time Spent:
              2 hours
               

              testing of multiple script for DB and patch on test server , customer and internal connect

            Priyasha Tiwari made changes -
            Time Spent 6 hours, 30 minutes [ 23400 ] 1 day, 2 hours, 30 minutes [ 37800 ]
            Worklog Id 291511 [ 291511 ]
            Hide
            Permalink
            Marwan Kanaan added a comment -

            Dear @Integration Support team,

            Kindly execute the below query on the target database and restart the server afterward:

            ALTER TABLE NRCELL
            ADD SSBFREQUENCY NUMBER(25);
            COMMIT;

            Please note that this query was already included in the latest patch and should have been executed during the deployment phase to prevent the reported issue.

            Kindly confirm once completed.

            Best Regards,
            Marwan Kanaan I Software Developer

            Show
            Marwan Kanaan added a comment - Dear @Integration Support team, Kindly execute the below query on the target database and restart the server afterward: ALTER TABLE NRCELL ADD SSBFREQUENCY NUMBER(25); COMMIT; Please note that this query was already included in the latest patch and should have been executed during the deployment phase to prevent the reported issue. Kindly confirm once completed. Best Regards, Marwan Kanaan I Software Developer
            Hide
            Permalink
            Marwan Kanaan added a comment -

            Db view handed to srishti to test it

            Show
            Marwan Kanaan added a comment - Db view handed to srishti to test it
            Marwan Kanaan made changes -
            Attachment 20260216_V_5G_CELL_REPORT_DBVIEW.sql [ 128313 ]
            Hide
            Permalink
            Marwan Kanaan added a comment - - edited

            Dear @Priyasha Tiwari,

            Kindly find the updated DB view attached.

            Best Regards,
            Marwan Kanaan I Software Developer

            Show
            Marwan Kanaan added a comment - - edited Dear @Priyasha Tiwari, Kindly find the updated DB view attached. Best Regards, Marwan Kanaan I Software Developer
            Marwan Kanaan made changes -
            Time Spent 1 day, 2 hours, 30 minutes [ 37800 ] 1 day, 5 hours, 30 minutes [ 48600 ]
            Worklog Id 291524 [ 291524 ]
            Marwan Kanaan made changes -
            Remaining Estimate 0 minutes [ 0 ] 1 hour [ 3600 ]
            Time Spent 1 day, 5 hours, 30 minutes [ 48600 ] 1 day, 4 hours, 30 minutes [ 45000 ]
            Worklog Id 291524 [ 291524 ]
            Permalink
            Marwan Kanaan logged work - 17/Feb/26 12:00 AM
            • Time Spent:
              1 hour
               

              fix the view

            Permalink
            Priyasha Tiwari logged work - 17/Feb/26 12:00 AM
            • Time Spent:
              1 day
               

              testing of multiple script for DB and patch on test server , customer and internal connect

            Permalink
            Basant Kumar logged work - 17/Feb/26 12:00 AM
            • Time Spent:
              2 hours
               

              i have sync the db on ASCOPY2026 then executed 5g cell report script .

            Marwan Kanaan made changes -
            Attachment 20260216_V_5G_CELL_REPORT_DBVIEW.sql [ 128313 ]
            Marwan Kanaan made changes -
            Attachment 20260216_V_5G_CELL_REPORT_DBVIEW.sql [ 128406 ]
            Marwan Kanaan made changes -
            Remaining Estimate 1 hour [ 3600 ] 0 minutes [ 0 ]
            Time Spent 1 day, 4 hours, 30 minutes [ 45000 ] 1 day, 5 hours, 30 minutes [ 48600 ]
            Worklog Id 291612 [ 291612 ]
            Permalink
            Srishti Kashyap logged work - 18/Feb/26 12:00 AM
            • Time Spent:
              2 hours
               

              checked the script if ssb frquency column added or not in dbview..shared script..column not reflecting checking db not commit re sharing after checking test db

            Permalink
            Basant Kumar logged work - 18/Feb/26 12:00 AM
            • Time Spent:
              2 hours
               

              i have sync db on .177 and executed script for NEW Attribute to add in 5g cell report SSB frequency

            Basant Kumar made changes -
            Time Spent 1 day, 5 hours, 30 minutes [ 48600 ] 1 day, 6 hours, 30 minutes [ 52200 ]
            Worklog Id 291718 [ 291718 ]
            Permalink
            Basant Kumar logged work - 19/Feb/26 12:00 AM
            • Time Spent:
              2 hours
               

              i have executed 5g cell secipt on AS prod then resrsted the server .

            Permalink
            Basant Kumar logged work - 20/Feb/26 12:00 AM
            • Time Spent:
              2 hours
               

              i have executed the 5G Cell SSB Frequency Column and Data missing in 5G cell script on all prods .

            Priyasha Tiwari made changes -
            Status Bug/s Found [ 10208 ] Closed [ 6 ]
            Resolution Fixed [ 1 ]
            Priyasha Tiwari made changes -
            Time Spent 1 day, 6 hours, 30 minutes [ 52200 ] 2 days, 6 hours, 30 minutes [ 81000 ]
            Worklog Id 292222 [ 292222 ]
            Priyasha Tiwari made changes -
            Worklog Id 292222 [ 292222 ]
            Priyasha Tiwari made changes -
            Remaining Estimate 0 minutes [ 0 ] 3 hours [ 10800 ]
            Time Spent 2 days, 6 hours, 30 minutes [ 81000 ] 2 days, 3 hours, 30 minutes [ 70200 ]
            Worklog Id 292222 [ 292222 ]
            Priyasha Tiwari made changes -
            Remaining Estimate 3 hours [ 10800 ] 6 hours [ 21600 ]
            Time Spent 2 days, 3 hours, 30 minutes [ 70200 ] 2 days, 30 minutes [ 59400 ]
            Worklog Id 292222 [ 292222 ]
            Priyasha Tiwari made changes -
            Remaining Estimate 6 hours [ 21600 ] 0 minutes [ 0 ]
            Time Spent 2 days, 30 minutes [ 59400 ] 3 days, 30 minutes [ 88200 ]
            Worklog Id 292223 [ 292223 ]
            Priyasha Tiwari made changes -
            Time Spent 3 days, 30 minutes [ 88200 ] 4 days, 30 minutes [ 117000 ]
            Worklog Id 292224 [ 292224 ]
            Priyasha Tiwari made changes -
            Remaining Estimate 0 minutes [ 0 ] 1 day [ 28800 ]
            Time Spent 4 days, 30 minutes [ 117000 ] 3 days, 30 minutes [ 88200 ]
            Worklog Id 292224 [ 292224 ]
            Worklog Time Spent 1 day [ 28800 ]
            Srishti Kashyap made changes -
            Remaining Estimate 1 day [ 28800 ] 30 minutes [ 1800 ]
            Time Spent 3 days, 30 minutes [ 88200 ] 4 days [ 115200 ]
            Worklog Id 292329 [ 292329 ]
            Srishti Kashyap made changes -
            Remaining Estimate 30 minutes [ 1800 ] 0 minutes [ 0 ]
            Time Spent 4 days [ 115200 ] 4 days, 2 hours [ 122400 ]
            Worklog Id 292330 [ 292330 ]
            Srishti Kashyap made changes -
            Remaining Estimate 0 minutes [ 0 ] 7 hours, 30 minutes [ 27000 ]
            Time Spent 4 days, 2 hours [ 122400 ] 3 days, 2 hours, 30 minutes [ 95400 ]
            Worklog Id 292329 [ 292329 ]
            Worklog Time Spent 7 hours, 30 minutes [ 27000 ]
            Srishti Kashyap made changes -
            Remaining Estimate 7 hours, 30 minutes [ 27000 ] 6 hours, 30 minutes [ 23400 ]
            Time Spent 3 days, 2 hours, 30 minutes [ 95400 ] 3 days, 3 hours, 30 minutes [ 99000 ]
            Worklog Id 292337 [ 292337 ]
            Srishti Kashyap made changes -
            Worklog Id 292337 [ 292337 ]
            Basant Kumar made changes -
            Worklog Id 291718 [ 291718 ]
            Basant Kumar made changes -
            Remaining Estimate 6 hours, 30 minutes [ 23400 ] 4 hours, 30 minutes [ 16200 ]
            Time Spent 3 days, 3 hours, 30 minutes [ 99000 ] 3 days, 5 hours, 30 minutes [ 106200 ]
            Worklog Id 292528 [ 292528 ]
            Basant Kumar made changes -
            Remaining Estimate 4 hours, 30 minutes [ 16200 ] 2 hours, 30 minutes [ 9000 ]
            Time Spent 3 days, 5 hours, 30 minutes [ 106200 ] 3 days, 7 hours, 30 minutes [ 113400 ]
            Worklog Id 292530 [ 292530 ]
            Basant Kumar made changes -
            Remaining Estimate 2 hours, 30 minutes [ 9000 ] 30 minutes [ 1800 ]
            Time Spent 3 days, 7 hours, 30 minutes [ 113400 ] 4 days, 1 hour, 30 minutes [ 120600 ]
            Worklog Id 292536 [ 292536 ]
            Basant Kumar made changes -
            Remaining Estimate 30 minutes [ 1800 ] 0 minutes [ 0 ]
            Time Spent 4 days, 1 hour, 30 minutes [ 120600 ] 4 days, 3 hours, 30 minutes [ 127800 ]
            Worklog Id 292542 [ 292542 ]
            Transition Time In Source Status Execution Times Last Executer Last Execution Date
            Open Bug Open Bug Opened Opened
            		35m 17s 1 Abir Messaikeh 04/Feb/26 7:41 AM
            Opened Opened Need More Info Need More Info
            		20h 13m 1 Priyasha Tiwari 05/Feb/26 3:54 AM
            Need More Info Need More Info Opened Opened
            		5s 1 Priyasha Tiwari 05/Feb/26 3:55 AM
            Opened Opened Pending Requirements Pending Requirements
            		2h 40m 1 Khaled Khalil 05/Feb/26 6:35 AM
            Pending Requirements Pending Requirements Pending Design Session Pending Design Session
            		9s 1 Khaled Khalil 05/Feb/26 6:35 AM
            Pending Design Session Pending Design Session Dev Scheduled Dev Scheduled
            		16s 1 Khaled Khalil 05/Feb/26 6:35 AM
            Dev Scheduled Dev Scheduled Implementation in progress Implementation in progress
            		8s 1 Khaled Khalil 05/Feb/26 6:36 AM
            Implementation in progress Implementation in progress To Be Released To Be Released
            		32m 21s 1 Khaled Khalil 05/Feb/26 7:08 AM
            To Be Released To Be Released Ready for QA Ready for QA
            		5s 1 Khaled Khalil 05/Feb/26 7:08 AM
            Ready for QA Ready for QA QA In Progress QA In Progress
            		7d 1h 42m 1 Abir Messaikeh 12/Feb/26 8:51 AM
            QA In Progress QA In Progress Bug/s Found Bug/s Found
            		5s 1 Abir Messaikeh 12/Feb/26 8:51 AM
            Bug/s Found Bug/s Found Closed Closed
            		11d 1h 9m 1 Priyasha Tiwari 23/Feb/26 10:00 AM
            Subversion JIRA

            Links Hierarchy

            		  Documentation

            Invalid license: EXPIRED

            Cancel

              People

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

                    Drag and Drop